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 constra…
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 12c create automatically
when the table and constraints are created?
a. 0
b. 1
c. 2
d. 3
e. 4
7. 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?
a. CREATE SYNONYM thetable
FOR juan.mytable;
b. CREATE PUBLIC SYNONYM thetable
FOR mytable;
c. CREATE SYNONYM juan
FOR mytable;
d. none of the above
8. Which of the following statements is true?
a. A gap can appear in a sequence created with the NOCACHE option if the system
crashes before a user can commit a transaction.
b. Any unassigned sequence values appears in the USER_SEQUENCE data dictionary
table as unassigned.
c. Only the user who creates a sequence is allowed to delete it.
d. Only the user who created a sequence is allowed to use the value generated by the
sequence.
9. When is creating an index manually inappropriate?
a. when queries return a large percentage of rows in the results
b. when the table is small
c. when the majority of table operations are updates
d. all of the above
e. only a and c
OR