Description : What are the options available to refresh snapshots ?
Last Answer : COMPLETE - Tables are completely regenerated using the snapshots query and the master tables every time the snapshot referenced. FAST - If simple snapshot used then a snapshot log can be used to ... Default value. If possible it performs a FAST refresh; Otherwise it will perform a complete refresh.
Description : What are the various type of snapshots?
Last Answer : Simple and Complex.
Description : What is snapshots?
Last Answer : Snapshot is an object used to dynamically replicate data between distribute database at specified time intervals. In ver 7.0 they are read only.
Description : How can you Enforce Referential Integrity in snapshots ?
Last Answer : Time the references to occur when master tables are not in use. Peform the reference the manually immdiately locking the master tables. We can join tables in snopshots by creating a complex snapshots that will based on the master tables.
Description : Differentiate between TRUNCATE and DELETE?
Last Answer : TRUNCATE deletes much faster than DELETE TRUNCATE DELETE It is a DDL statement It is a DML statement It is a one way trip,cannot ROLLBACK One can Rollback Doesn't have selective features (where clause) Has Doesn't fire database triggers Does It requires disabling of referential constraints.
Description : Define the term 'sample rate'. A. Snapshots of sound are taken as the wave cannot be represented as a series of continuous changes. B. The number of samples taken each second C. The number of bits used per second of audio D. The number of bits available for each clip
Last Answer : B. The number of samples taken each second
Description : What are Most Common types of Complex master-detail relationships?
Last Answer : There are three most common types of complex master-detail relationships: master with dependent details master with independent details detail with two masters
Description : Differentiate between Evaporation and Distillation and explain the working and application of simple distillation.
Last Answer : Evaporation Distillation: 1. Free escape of vapors from the surface of liquid below its boiling point. Evaporation takes place even at room temperature 1) Process of ... Concentration of liquid and to separate non volatile solid from the volatile liquid such as alcohol and ether.
Description : Differentiate between simple and modified maceration with example.
Last Answer : Sr.No. Simple maceration Modified maceration 1 Drug along with whole menstruum is used in maceration process Drug along with 4/5th of menstruum is used in maceration process 2 ... made by this process are: a. Tincture of Tolu b. Tincture of Myrrh c. Tincture of Benzoin
Description : Differentiate between simple levelling and differential levelling with neat sketch.
Last Answer : S.N Simple Levelling Differential levelling 1 Instrument is not shifted till the end of survey work. Instrument is shifted as per requirements. 2 In this difference in elevation between ... elevation between two points is more or any obstacle between them. 4
Description : I may be simple, I may be complex; I may have a name, but no gender or sex; I am often a question, or statements as a setup; I tend to have an answer, 'til you find it I won't let up. What am I? -Riddles
Last Answer : A riddle.
Description : 3. How are simple tissues different from complex tissues in plants? -Science
Last Answer : The following are the differences: Simple tissues Complex tissues They are made up of a single type of cell that performs only one common function They are made up of more than one kind of a cell that coordinate to perform one particular function
Description : Difference between simple and complex tissues in plants. -Biology
Last Answer : answer:
Description : Difference between simple permanent tissue and complex permanent tissue. -Biology
Description : Why Our is complex but is based on units that are simple?
Last Answer : Need answer
Description : How do you find out if a sentence is a simple sentence a compound sentence or a complex sentence?
Last Answer : if it has a conjunctive in the sentence its not a simple
Description : How might simple molecules find each other and combine to make a complex molecule?
Last Answer : Feel Free to Answer
Description : The Correct Statements with reference to single called organisms are (i) Complex substances are not broken down in to simpler substances. (ii) Simple diffusion is sufficient to meet the requirement of exchange of gases. (iii) Specialized ... b) (ii) and (iii) (c) (ii) and (iv) (d) (i) and (iv)
Last Answer : Answer: (c)
Description : The activities that make up the project are not simple, repetitive acts, such as mowing the lawn, painting the house, washing the car, or loading the delivery truck. a. They are complex b. They are simple c. Different d. Same
Last Answer : a. They are complex
Description : Under complex or simple loading, strain energy is (a) External work done (b) Internal work done (c) Both internal and external work (d) None
Last Answer : (b) Internal work done
Description : Why do we determine principal stresses? a. Failure is due to simple stress or strain b. Failure is due to complex stress or strain c. Both (a) & (b) d. None
Last Answer : a. Failure is due to simple stress or strain
Description : Is principal a? a. Simple stress b. Complex stress c. Bending stress d. None
Last Answer : a. Simple stress
Description : Which is the complete specification of the state of the world? a) Atomic event b) Complex event c) Simple event d) None of the mentioned
Last Answer : a) Atomic event
Description : Low geographical concentration with High co-ordination suggests which International Strategy? A. Complex Export B. Multi-Domestic C. Simple Export D. Global Strategy
Last Answer : Global Strategy
Description : High geographical concentration with High co-ordination suggests which International Strategy? A. Global Strategy B. Complex Export C. Simple Export D. None of the above
Last Answer : Complex Export
Description : In non profit oriented marketing ____________ 1. objectives are more complex 2. objectives are less complex 3. objectives are very simple 4. objectives are not defined 5. none of these
Last Answer : objectives are more complex
Description : The transmission mode which allows both communicating devices to transmit and receive data simultaneously is: a) Full Duplex b) Simplex c) Half Duplex d) Simple Complex e) None of These
Last Answer : a) Full Duplex
Description : Allosteric enzymes are A- larger than simple enzyme B- smaller than simple enzyme C- larger and more complex than simple enzyme D- .smaller than simple enzyme but not complex
Last Answer : larger and more complex than simple enzyme
Description : Hypervisor also known as? A. high-level program B. simple program C. complex program D. low-level program
Last Answer : low-level program
Description : How are complex tissues different from simple tissues?
Last Answer : Complex tissues are made of more than one type of cells.
Description : Parenchyma is a type of ____ (a) simple tissue (b) complex tissue (c) xylem d) phloem
Last Answer : (a) simple tissue
Description : Characteristic of a good test A. Reasonable probability of catching an error and can be redundant B. It is not simple or too complex C. Reasonable probability of catching an error and cannot be redundant D. It is either simple or too complex
Last Answer : C. Reasonable probability of catching an error and cannot be redundant
Description : A hypothesis which states the relationship among three or more variables is called as a. Simple Hypothesis b. Complex Hypothesis c. Research Hypothesis d. Non directional Hypothesis
Last Answer : b. Complex Hypothesis
Description : The instruction set of RISC processor is A. Simple and lesser in number B. Complex and lesser in number C. Simple and larger in number D. Complex and larger in number
Last Answer : A. Simple and lesser in number
Description : Simple and complex carbohydrates. What is the difference?
Last Answer : Simple and complex carbohydrates. What is the difference? The main components of human nutrition are fats, proteins and carbohydrates. Each of them plays an important role in the life of the body. Let's ... of sugar, which means they can cause an insulin surge and the conversion of sugar into fat.
Description : An attacker sits between the sender and receiver and captures the information and retransmits to the receiver after some time without altering the information. This attack is called as .............. (A) Denial of service attack (B) Masquarade attack (C) Simple attack (D) Complex attack
Last Answer : (A) Denial of service attack
Description : What does "jumps off the screen" mean?
Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.
Description : How to add conditions in select statement in oracle?
Last Answer : Just add the decode
Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?
Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?
Description : What are the two ways to incorporate images into a oracle forms application?
Last Answer : Boilerplate Images Image_items
Description : Can one export a subset of a table? (for DBA
Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"
Description : What are the types of visual attribute settings?
Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window
Description : How does one use the import/export utilities? (for DBA
Last Answer : Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters ... and export data with the "Schema Manager" GUI that ships with Oracle Enterprise Manager (OEM).
Description : what is a display item?
Last Answer : Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.
Description : What is import/export and why does one need it? (for DBA
Last Answer : The Oracle export (EXP) and import (IMP) utilities are used to perform logical database backup and recovery. They are also used to move Oracle data from one machine, database or schema to ... corruption. Ensure that all the data can be read. . Transporting tablespaces between databases . Etc.
Description : Are there any troubleshooting tips for OEM? (for DBA
Last Answer : . Create the OEM repository with a user (which will manage the OEM) and store it in a tablespace that does not share any data with other database users. It is a bad practice to create ... successfully. Check the log to see the results of the execution rather than relying on this status.
Description : Where can one get more information about TCL? (for DBA
Last Answer : One can write custom event checking routines for OEM using the TCL (Tool Command Language) language. Check the following sites for more information about TCL: . The Tcl Developer Xchange - ... the OraTCL package . Tom Poindexter's Tcl Page - Oratcl was originally written by Tom Poindexter
Description : How does one start the Oracle Intelligent Agent? (for DBA
Last Answer : One needs to start an OIA (Oracle Intelligent Agent) process on all machines that will to be managed via OEM. For OEM 9i and above:
Description : What is the Oracle Intelligent Agent? (for DBA
Last Answer : The Oracle Intelligent Agent (OIA) is an autonomous process that needs to run on a remote node in the network to make the node OEM manageable. The Oracle Intelligent Agent is ... events registered in Enterprise Manager; and . Executing tasks associated with jobs submitted to Enterprise Manager.
Description : What are the types of SQL Statement ?
Last Answer : Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.