Placement papers on Oracle - Set 2

Placement papers on Oracle - Set 2


1. Which of the following is the fastest query method for a table?

Fetch by columnid
Fetch by tableid
Fetch by rowid
Fetch by indexid
View Answer / Hide Answer

ANSWER: Fetch by rowid




2. How should a many-to-many relationship be handled?

By adding an join entity table
By adding intersection entity table
By adding union entity table
By adding Cartesian entity table
View Answer / Hide Answer

ANSWER: By adding intersection entity table




3. How many triggers can be applied to a single table in Oracle?

10
12
15
16
View Answer / Hide Answer

ANSWER: 12




4. Which of the following statements is true?

Implicit cursors are not named
Implicit cursors must be developed by the database developers
Explicit cursors can handle tables with only 16 rows
Explicit cursors does not occupy Oracle’s memory space
View Answer / Hide Answer

ANSWER: Implicit cursors are not named




5. Which of the following are the pseudo-columns?

DUAL,USER_ID,CUR_VAL
USER_ID,DUAL,ROW_ID
SYSDATE,USER,CURVAL,NEXTVAL
ROW_NUM,ROW_ID
View Answer / Hide Answer

ANSWER: SYSDATE,USER,CURVAL,NEXTVAL




6. ___________ contains the physical structure of a database

Archive log files
Initialization files
Control files
SGA definition files
View Answer / Hide Answer

ANSWER: Control files




7. Using synonyms is a good way to implement location transparency.

True
False
View Answer / Hide Answer

ANSWER: True




8. A cluster is a schema object that contains data from _____________ , all of which have one or more columns in common.

one table
one or more tables
two or more tables
atleast two tables
View Answer / Hide Answer

ANSWER: two or more tables


Post your comment

You may like