Managing Views, Sequences, And Synonyms MCQs
Managing Views, Sequences, And Synonyms MCQs
Answer these Managing Views, Sequences, And Synonyms MCQs and assess your grip on the subject of Managing Views, Sequences, And Synonyms.
Scroll below and get started!
1: The rules for updatable join views in which rule Any INSERT, UPDATE, or DELETE operation on a join view can modify only one underlying base table at a time?
A. GENERAL Rule
B. INSERT Rule
C. DELETE Rule
D. UPDATE Rule
2: You can also create views that specify more than one base table or view in the FROM Clause. These are called join views?
A. False
B. True
3: When a view is dropped, all grants of corresponding object privileges are revoked from roles and users. After the view is re-created, privileges must be regranted?
A. True
B. False
4: To create a private synonym in another user's schema, you must have which privilege from the following?
A. CREATE ANY SYNONYM
B. CREATE SYNONYM
C. CREATE PUBLIC SYNONYM
D. None
5: In UPDATABLE_COLUMNS VIEWS which view Shows all columns in all tables and views accessible to the user that are modifiable?
A. USER_UPDATABLE_COLUMNS
B. DBA_UPDATABLE_COLUMNS
C. ALL_UPDATABLE_COLUMNS
D. None
6:
A sequence is referenced in SQL statements with the NEXTVAL and CURRVAL pseudocolumns, which can be used in the following places
1) VALUES clause of INSERT statements
2) The SELECT list of a SELECT statement
3) The SET clause of an UPDATE statement
A.
None
B.
CURRVAL
C.
CURRVAL And NEXTVAL
D.
NEXTVAL
7: You cannot use an ALTER VIEW statement to change the definition of a view, you can replace views in the following which of the ways?
A. You can drop and recreate the view And You can redefine the view with a CREATE VIEW statement that contains the OR REPLACE clause
B. None
C. You can drop and recreate the view
D. You can redefine the view with a CREATE VIEW statement that contains the OR REPLACE clause
E. The rules for updatable join views in which statement must not explicitly or implicitly refer to the columns of a non-key-preserved table. If the join view is defined with the WITH CHECK.
8: OPTION clause and these statements are not permitted?
A. INSERT Rule
B. DELETE Rule
C. GENERAL Rule
D. UPDATE Rule
9: Which is a database objects from which multiple users can generate unique integers?
A. None
B. Views
C. Synonyms
D. Sequences
10: In Referencing a Sequence with each new sequence number is generated by a reference to the sequence pseudocolumn?
A. NEXTVAL
B. None
C. CURRVAL And NEXTVAL
D. CURRVAL
List of Managing Views, Sequen...
Available in:
Managing Views, Sequences, And Synonyms MCQs
