• Which of the following generates a series of integers that can be stored in a database?
• a number generator
• a view
• a sequence
• an index
• a synonym

 

• Which syntax is correct for removing a public synonym?
• DROP SYNONYM synonymname;
• DELETE PUBLIC SYNONYM synonymname;
• DROP PUBLIC SYNONYM synonymname;
• DELETE SYNONYM synonymname;

 

• Which of the following commands can you use to modify an index?
• ALTER SESSION
• ALTER TABLE
• MODIFY INDEX
• ALTER INDEX
• none of the above

 

• Which of the following generates an integer in a sequence?
• NEXTVAL
• CURVAL
• NEXT_VALUE
• CURR_VALUE
• NEXT_VAL
• CUR_VAL

 

• Which of the following is a valid SQL statement?
• INSERT INTO publisher VALUES (pubsequence.nextvalue, 'HAPPY PRINTING', 'LAZY LARRY', NULL);
• CREATE INDEX a_new_index ON (firstcolumn*.02);
• CREATE SYNONYM pub FOR publisher;
• all of the above
• only a and c
• none of the above
•  Suppose the user Juan creates a table called MYTABLE with four columns. The first column has a PRIMARY KEY constraint, the second column has a NOT NULL constraint, the third column has a CHECK constraint, and the fourth column has a FOREIGN KEY constraint. Given this information, how many indexes does Oracle 11g create automatically when the table and constraints are created?
• 0
• 1
• 2
• 3
• 4

 

•  Given the table created in Question 6, which of the following commands can Juan use to create a synonym that allows anyone to access the table without having to identify his schema in the table reference?
• CREATE SYNONYM thetable FOR juan.mytable;
• CREATE PUBLIC SYNONYM thetable FOR mytable;
• CREATE SYNONYM juan FOR mytable;
• none of the above

 

 

• Which of the following statements is true?
• A gap can appear in a sequence created with the NOCACHE option if the system crashes before a user can commit a transaction.
• Any unassigned sequence values appears in the USER_SEQUENCE data dictionary table as unassigned.
• Only the user who creates a sequence is allowed to delete it.
• Only the user who created a sequence is allowed to use the value generated by the sequence.

 

• When is creating an index manually inappropriate?
• when queries return a large percentage of rows in the results
• when the table is small
• when the majority of table operations are updates
• all of the above
• only a and c

 

• If a column has high selectivity or cardinality, which index type is most appropriate?
• IOT
• B-tree
• bitmap
• function-based index