> > Programming Languages MCQs > Schema Objects MCQs

Schema Objects MCQ

1. You analyze a schema object (table, index, or cluster) to?

UnIdentify migrated and chained rows of a table or cluster

None

Does not verify the validity of its storage format

No need to Collect and manage statistics for it

Answer

Correct Answer: None

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

2. Which two are valid locking levels that are used by transactions in an Oracle database?

Row level

Object level

Block level

Row level And Object level

Answer

Correct Answer: Row level And Object level

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

3. You can use RENAME for a stored PL/SQL program unit, public synonym, or cluster. To rename such an object, you no need to drop and re-create it?

False

True

Answer

Correct Answer: False

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

4. You cannot issue a SET CONSTRAINT statement inside a trigger?

False

True

Answer

Correct Answer: True

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

5.
Efficient Use of Integrity Constraints: A Procedure Using integrity constraint states in the following order can ensure the best benefits?

1. Disable state.
2. Perform the operation (load, export, import).
3. Enable novalidate state.
4. Enable state.

4,2,1,3

2,1,3,4

1,3,2,4

1,2,3,4

Answer

Correct Answer:

1,2,3,4

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

6. To rename an object, it must be in your schema. You can rename schema objects in either of the following ways?

Drop and re-create the object And Rename the object using the RENAME statement

Rename the object using the RENAME statement

Create the object

Drop and re-create the object

Answer

Correct Answer: Drop and re-create the object And Rename the object using the RENAME statement

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

7. A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the two effects of this command?

It fails if any existing row violates the constraint

It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.

It fails if any existing row violates the constraint And It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.

It does not validate the existing data in the table

Answer

Correct Answer: It fails if any existing row violates the constraint And It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.

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

8. You can delete all rows of a table or all rows in a group of clustered tables so that the table (or cluster) still exists, but is completely empty?

Use the DROP and CREATE statements

Use the TRUNCATE statement

Use the DELETE statementc

All

Answer

Correct Answer: All

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

9. Which User System Privilege used for this operation authorized to connect to the database?

CREATE SEQUENCE

CREATE TABLE

CREATE VIEW

CREATE SESSION

Answer

Correct Answer: CREATE SESSION

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

10.
On Tuesday, a junior DBA dropped an important application user account, whose schema has important tables. You are asked to recover all the objects in the schema. On investigation, you

find that the user account was dropped at 11:00 a.m. and Sunday's backup is the most recent backup. Which flashback feature would you use?

Flashback Database

Flashback Table

Flashback Drop

Flashback Version Query

Answer

Correct Answer:

Flashback Drop

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

11. The CREATE SCHEMA statement is useful if you want to guarantee the creation of several tables, views, and grants in one operation it can include?

All

GRANT

CREATE VIEW

CREATE TABLE

Answer

Correct Answer: All

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

12.
The following query lists all of the base objects for the synonyms created by user jward this example is used for displaying?

SELECT TABLE_OWNER, TABLE_NAME, SYNONYM_NAME
FROM DBA_SYNONYMS
WHERE OWNER = 'JWARD';
The following is the query output:
TABLE_OWNER----TABLE_NAME----SYNONYM_NAME
---------------------- ----------- -----------------
SACHIN---------DEPT----------DEPT
SACHIN---------EMP-----------EMP

Displaying Schema Objects by Type And Displaying Dependencies of Views and Synonyms

None

Displaying Schema Objects by Type

Displaying Dependencies of Views and Synonyms

Answer

Correct Answer:

Displaying Dependencies of Views and Synonyms

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

13. Which DBA System Privilege used for the operations authorized for drops a table in any schema?

DROP USER

CREATE USER

BACKUP ANY TABLE

DROP ANY TABLE

Answer

Correct Answer: DROP ANY TABLE

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

14. Deferrable unique and primary keys must use nonunique indexes?

False

True

Answer

Correct Answer: True

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

15. In Schema Objects Data Dictionary Views which view List the name, type, and owner (USER view does not display owner) for all tables, views, synonyms, and sequences in the database?

DBA_CATALOG, ALL_CATALOG, USER_CATALOG

None

DBA_DEPENDENCIES, ALL_DEPENDENCIES, USER_DEPENDENCIES

DBA_OBJECTS, ALL_OBJECTS, USER_OBJECTS

Answer

Correct Answer: DBA_CATALOG, ALL_CATALOG, USER_CATALOG

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

Programming Languages MCQs | Topic-wise

MCQ on Alligation	MCQ on Application Software
MCQ on Artificial Intelligence (AI)	MCQ on Assembly Language
MCQ on Backup And Recovery	MCQ on Basic Programming Languages
MCQ on Caching Application Pages And Data	MCQ on Cobol
MCQ on Coding And Decoding	MCQ on Exception Handling
MCQ on File Handling	MCQ on Fortran
MCQ on General	MCQ on Inheritance
MCQ on Input System	MCQ on Language Processors
MCQ on Operator Overloading	MCQ on Polymorphism And Abstract Function
MCQ on Processing System	MCQ on Schema Objects
MCQ on UML (Unified Modeling Language)	MCQ on Validation Control And Web Page Navigation
MCQ on huffman	General Programming Languages MCQs

Schema Objects MCQ

1. You analyze a schema object (table, index, or cluster) to?

2. Which two are valid locking levels that are used by transactions in an Oracle database?

3. You can use RENAME for a stored PL/SQL program unit, public synonym, or cluster. To rename such an object, you no need to drop and re-create it?

4. You cannot issue a SET CONSTRAINT statement inside a trigger?

5. Efficient Use of Integrity Constraints: A Procedure Using integrity constraint states in the following order can ensure the best benefits?1. Disable state.2. Perform the operation (load, export, import).3. Enable novalidate state.4. Enable state.

6. To rename an object, it must be in your schema. You can rename schema objects in either of the following ways?

7. A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the two effects of this command?

8. You can delete all rows of a table or all rows in a group of clustered tables so that the table (or cluster) still exists, but is completely empty?

9. Which User System Privilege used for this operation authorized to connect to the database?

11. The CREATE SCHEMA statement is useful if you want to guarantee the creation of several tables, views, and grants in one operation it can include?

13. Which DBA System Privilege used for the operations authorized for drops a table in any schema?

14. Deferrable unique and primary keys must use nonunique indexes?

15. In Schema Objects Data Dictionary Views which view List the name, type, and owner (USER view does not display owner) for all tables, views, synonyms, and sequences in the database?

5.
Efficient Use of Integrity Constraints: A Procedure Using integrity constraint states in the following order can ensure the best benefits?

1. Disable state.
2. Perform the operation (load, export, import).
3. Enable novalidate state.
4. Enable state.