> > Programming Languages MCQs > Schema Objects MCQs

Schema Objects MCQ

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Schema Objects MCQ

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

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

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?

You cannot issue a SET CONSTRAINT statement inside a trigger?

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.

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

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?

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?

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

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?

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

Deferrable unique and primary keys must use nonunique indexes?

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?

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.