> > Oracle MCQs > Managing Views, Sequences, And Synonyms MCQs

Managing Views, Sequences, And Synonyms MCQ

1. In Referencing a Sequence with each new sequence number is generated by a reference to the sequence pseudocolumn?

NEXTVAL

None

CURRVAL And NEXTVAL

CURRVAL

Answer

Correct Answer: NEXTVAL

Note: This Question is unanswered, help us to find answer for this one

2. Which is a database objects from which multiple users can generate unique integers?

None

Views

Synonyms

Sequences

Answer

Correct Answer: Sequences

Note: This Question is unanswered, help us to find answer for this one

3. OPTION clause and these statements are not permitted?

INSERT Rule

DELETE Rule

GENERAL Rule

UPDATE Rule

Answer

Correct Answer: INSERT Rule

Note: This Question is unanswered, help us to find answer for this one

4. 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?

You can drop and recreate the view And You can redefine the view with a CREATE VIEW statement that contains the OR REPLACE clause

None

You can drop and recreate the view

You can redefine the view with a CREATE VIEW statement that contains the OR REPLACE clause

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.

Answer

Correct Answer: You can drop and recreate the view And You can redefine the view with a CREATE VIEW statement that contains the OR REPLACE clause

Note: This Question is unanswered, help us to find answer for this one

5.
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

None

CURRVAL

CURRVAL And NEXTVAL

NEXTVAL

Answer

Correct Answer:

CURRVAL And NEXTVAL

Note: This Question is unanswered, help us to find answer for this one

6. In UPDATABLE_COLUMNS VIEWS which view Shows all columns in all tables and views accessible to the user that are modifiable?

USER_UPDATABLE_COLUMNS

DBA_UPDATABLE_COLUMNS

ALL_UPDATABLE_COLUMNS

None

Answer

Correct Answer: ALL_UPDATABLE_COLUMNS

Note: This Question is unanswered, help us to find answer for this one

7. To create a private synonym in another user's schema, you must have which privilege from the following?

CREATE ANY SYNONYM

CREATE SYNONYM

CREATE PUBLIC SYNONYM

None

Answer

Correct Answer: CREATE ANY SYNONYM

Note: This Question is unanswered, help us to find answer for this one

8. 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?

True

False

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

9. You can also create views that specify more than one base table or view in the FROM Clause. These are called join views?

False

True

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

10. 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?

GENERAL Rule

INSERT Rule

DELETE Rule

UPDATE Rule

Answer

Correct Answer: GENERAL Rule

Note: This Question is unanswered, help us to find answer for this one

Oracle MCQs | Topic-wise

MCQ on Basic Oracle	MCQ on Managing Archived Redo Logs
MCQ on Managing Clusters	MCQ on Managing Control Files
MCQ on Managing Data-files And Temp-files	MCQ on Managing Hash Clusters
MCQ on Managing Indexes	MCQ on Managing Oracle Database Processes
MCQ on Managing Oracle Distributed Transactions	MCQ on Managing Partitioned Tables And Indexes
MCQ on Managing Space For Schema Objects	MCQ on Managing Tables
MCQ on Managing Tablespaces	MCQ on Managing The Redo Log
MCQ on Managing The Undo Tablespace	MCQ on Managing Views, Sequences, And Synonyms
MCQ on Oracle Distributed Transactions Concepts	MCQ on Oracle WebLogic
General Oracle MCQs

Managing Views, Sequences, And Synonyms MCQ

1. In Referencing a Sequence with each new sequence number is generated by a reference to the sequence pseudocolumn?

2. Which is a database objects from which multiple users can generate unique integers?

3. OPTION clause and these statements are not permitted?

4. 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?

5. A sequence is referenced in SQL statements with the NEXTVAL and CURRVAL pseudocolumns, which can be used in the following places1) VALUES clause of INSERT statements2) The SELECT list of a SELECT statement3) The SET clause of an UPDATE statement

6. In UPDATABLE_COLUMNS VIEWS which view Shows all columns in all tables and views accessible to the user that are modifiable?

7. To create a private synonym in another user's schema, you must have which privilege from the following?

8. 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?

9. You can also create views that specify more than one base table or view in the FROM Clause. These are called join views?

10. 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?

5.
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