What are the various type of snapshots?

What are the various type of snapshots?
by

1 Answer

Answer :

Simple and Complex.
by

Related questions

Differentiate simple and complex, snapshots ?

Description : Differentiate simple and complex, snapshots ?

Last Answer : A simple snapshot is based on a query that does not contains GROUP BY clauses, CONNECT BY clauses, JOINs, sub-query or snashot of operations. - A complex snapshots contain atleast any one of the above.

What are the options available to refresh snapshots ?

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.

What is snapshots?

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.

How can you Enforce Referential Integrity in snapshots ?

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.

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

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

What is the use of break group? What are the various sub events a mouse double click event involves?

Description : What is the use of break group? What are the various sub events a mouse double click event involves?

Last Answer : A break group is used to display one record for one group ones. While multiple related records in other group can be displayed.

What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?

Description : What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?

Last Answer : Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.

What is an anchoring object & what is its use? What are the various sub events a mouse double click event involves?

Description : What is an anchoring object & what is its use? What are the various sub events a mouse double click event involves?

Last Answer : An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself.

What are the Various Block Coordination Properties

Description : What are the Various Block Coordination Properties

Last Answer : The various Block Coordination Properties are a) Immediate Default Setting. The Detail records are shown when the Master Record are shown. b) Deffered with Auto Query Oracle Forms defer fetching the ... No Auto Query The operator must navigate to the detail block and explicitly execute a query

What are the Various Master and Detail Relation ships.

Description : What are the Various Master and Detail Relation ships.

Last Answer : The various Master and Detail Relationship are a) NonIsolated :: The Master cannot be deleted when a child is exisiting b) Isolated :: The Master can be deleted when the child is exisiting c) Cascading :: The child gets deleted when the Master is deleted.

What are various constraints used in SQL?

Description : What are various constraints used in SQL?

Last Answer : NULL -NOT NULL -CHECK -DEFAULT

What are various privileges that a user can grant to another user?

Description : What are various privileges that a user can grant to another user?

Last Answer : SELECT -CONNECT -RESOURCES

What are various joins used while writing SUBQUERIES?

Description : What are various joins used while writing SUBQUERIES?

Last Answer : Self join-Its a join foreign key of a table references the same table. Outer Join--Its a join condition used where One can query all the rows of one of the tables in the join condition even though ... in which one or more columns in one table are equal to one or more columns in the second table.

What are the various methods of performing a calculation in a report ?

Description : What are the various methods of performing a calculation in a report ?

Last Answer : 1. Perform the calculation in the SQL statements itself. 2. Use a calculated / summary column in the data model.

Give the sequence of execution of the various report triggers?

Description : Give the sequence of execution of the various report triggers?

Last Answer : Before form , After form , Before report, Between page, After report.

What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?

Description : What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?

Last Answer : Destype and Desname.

What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?

Description : What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?

Last Answer : Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.

What is the use of hidden column? What are the various sub events a mouse double click event involves?

Description : What is the use of hidden column? What are the various sub events a mouse double click event involves?

Last Answer : A hidden column is used to when a column has to embed into boilerplate text.

What is the use of place holder column? What are the various sub events a mouse double click event involves?

Description : What is the use of place holder column? What are the various sub events a mouse double click event involves?

Last Answer : A placeholder column is used to hold calculated values at a specified place rather than allowing is to appear in the actual row where it has to appear.

How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Description : How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Last Answer : By dragging the column outside the group.

The value recorded in system.last_record variable is of type

Description : The value recorded in system.last_record variable is of type

Last Answer : a. Number b. Boolean c. Character. ? b. Boolean.

What type of index should you use on a fact table?

Description : What type of index should you use on a fact table?

Last Answer : A Bitmap index.

Give the two types of tables involved in producing a star schema and the type of data they hold.

Description : Give the two types of tables involved in producing a star schema and the type of data they hold.

Last Answer : Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ?

Description : What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ?

Last Answer : CHAR pads blank spaces to the maximum length. VARCHAR2 does not pad blank spaces. For CHAR it is 255 and 2000 for VARCHAR2.

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

Description : What should be the return type for a cursor variable.Can we use a scalar data type as return type?

Last Answer : The return type for a cursor must be a record type.It can be declared explicitly as a user-defined or %ROWTYPE can be used. eg TYPE t_studentsref IS REF CURSOR RETURN students%ROWTYPE

What is difference between % ROWTYPE and TYPE RECORD ?

Description : What is difference between % ROWTYPE and TYPE RECORD ?

Last Answer : % ROWTYPE is to be used whenever query returns a entire row of a table or view. TYPE rec RECORD is to be used whenever query returns columns of different table or views and variables. E.g. ... emp ename %type ); e_rec emp% ROWTYPE cursor c1 is select empno,deptno from emp; e_rec c1 %ROWTYPE.

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

Description : What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

Last Answer : % TYPE provides the data type of a variable or a database column to that variable. % ROWTYPE provides the record type that represents a entire row of a table or view or columns selected in ... database definition of a column in a table changes, the data type of a variable changes accordingly.

Explain the two type of Cursors ?

Description : Explain the two type of Cursors ?

Last Answer : There are two types of cursors, Implicit Cursor and Explicit Cursor. PL/SQL uses Implicit Cursors for queries. User defined cursors are called Explicit Cursors. They can be declared and used.

What are the different type of a record group?

Description : What are the different type of a record group?

Last Answer : Query record group Static record group Non query record group

What are the type of User Exits ?

Description : What are the type of User Exits ?

Last Answer : ORACLE Precompliers user exits OCI (ORACLE Call Interface) Non-ORACEL user exits. Page :

When do you use data parameter type?

Description : When do you use data parameter type?

Last Answer : When the value of a data parameter being passed to a called product is always the name of the record group defined in the current form. Data parameters are used to pass data to produts invoked with the run_product built-in subprogra

What are the different type of Segments ?

Description : What are the different type of Segments ?

Last Answer : Data Segment, Index Segment, Rollback Segment and Temporary Segment.

What are the type of Synonyms?

Description : What are the type of Synonyms?

Last Answer : There are two types of Synonyms Private and Public.

What are the different absence type patterns available in Fusion Absence Management?

Description : What are the different absence type patterns available in Fusion Absence Management?

Last Answer : An absence pattern contains a predefined set of rules that you can use as a starting point to create an absence type. The pattern that you select determines whether special fields ... patterns available in Fusion Absence Management. ∙Illness or injury ∙Childbirth or placement ∙Generic absence

What is degree of Relationship type?

Description : What is degree of Relationship type?

Last Answer : It is the number of entity type participating.

What is Relationship type?

Description : What is Relationship type?

Last Answer : Relationship type defines a set of associations or a relationship set among a given set of entity types.

What is an Extension of entity type?

Description : What is an Extension of entity type?

Last Answer : The collections of entities of a particular entity type are grouped together into an entity set.

What is an Entity type?

Description : What is an Entity type?

Last Answer : It is a collection (set) of entities that have same attributes.

A Column is having many repeated values which type of index you should create on this column, if you have to?

Description : A Column is having many repeated values which type of index you should create on this column, if you have to?

Last Answer : For example, assume there is a motor vehicle database with numerous low-cardinality columns such as car_color, car_make, car_model, and car_year. Each column contains less than 100 distinct values by themselves, and a b tree index would be fairly useless in a database of 20 million vehicles.

What type of indexes are available in Oracle?

Description : What type of indexes are available in Oracle?

Last Answer : There are many index types within Oracle: B*Tree Indexes - common indexes in Oracle. They are similar construct to a binary tree; they provide fast access by key, to an individual row or range of ... They allow data to be sorted from big to small (descending) instead of small to big (ascending).

SQL> SELECT * FROM MY_SCHEMA.MY_TABLE; SP2-0678: Column or attribute type cannot be displayed by SQL*Plus Why I’m getting this error?

Description : SQL> SELECT * FROM MY_SCHEMA.MY_TABLE; SP2-0678: Column or attribute type cannot be displayed by SQL*Plus Why I’m getting this error?

Last Answer : The table has a BLOB column.

What does "jumps off the screen" mean?

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.

How to add conditions in select statement in oracle?

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

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)?

What are the two ways to incorporate images into a oracle forms application?

Description : What are the two ways to incorporate images into a oracle forms application?

Last Answer : Boilerplate Images Image_items

Can one export a subset of a table? (for DBA

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\"

What are the types of visual attribute settings?

Description : What are the types of visual attribute settings?

Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window

How does one use the import/export utilities? (for DBA

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).

what is a display item?

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.

What is import/export and why does one need it? (for DBA

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.