Oracle

Q 1. How many different types of triggers can exist in a table in Oracle?

A. 10

B. 12

C.15

D. 16

Q 2. Which of the following statements is true?

A. Implicit cursors are not named

B.Implicit cursors must be developed by the database developers

C.Explicit cursors can handle tables with only 16 rows

D. Explicit cursors does not occupy Oracle’s memory space

Q 3. Which of the following are the Pseudo-columns??

A. DUAL,USER_ID,CUR_VAL

B. USER_ID,DUAL,ROW_ID

C. SYSDATE,USER,CURVAL,NEXTVAL

D.ROW_NUM,ROW_ID

Q 4. For referential integrity to hold, any field in a table that is declared a super key can contain only values from a parent table's primary key or a candidate key.

A. True

B. False

Q 5. Which of the following statements hold true for a cursor?

A. Specify positioning at specific rows in the result set

B. Retrieve multiple columns based on the current result set position

C.Modify data in the rows at the current position in the result set

D. Both a and c

Q 6. ____________ involves putting different rows into different tables

A. Horizontal partitioning

B. Vertical partitioning

C. Range partitioning

D. Hash partitioning

Q 7. _______________ are padded with space characters to match the specified length.

A. VARCHAR

B. VARCHAR2

C. CHAR

D. CHAR2

Q 8. Which of the following are types of background processes in Oracle?

A. SMON

B. PMON

C. CKPT

D. All of above

Q 9. ___________ contains the physical structure of a database

A. Archive log files

B. Initialization files

C. Control files

D. SGA definition files

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

A. One table

B. One or more tables

C. Two or more tables

D. Atleast two tables

Oracle

More Quizzes