Schema Objects MCQs
Schema Objects MCQs
Try to answer these 10+ Schema Objects MCQs and check your understanding of the Schema Objects subject.
Scroll down and let's begin!
1: 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?
A. DBA_CATALOG, ALL_CATALOG, USER_CATALOG
B. None
C. DBA_DEPENDENCIES, ALL_DEPENDENCIES, USER_DEPENDENCIES
D. DBA_OBJECTS, ALL_OBJECTS, USER_OBJECTS
2: Deferrable unique and primary keys must use nonunique indexes?
A. False
B. True
3: Which DBA System Privilege used for the operations authorized for drops a table in any schema?
A. DROP USER
B. CREATE USER
C. BACKUP ANY TABLE
D. DROP ANY TABLE
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
A.
Displaying Schema Objects by Type And Displaying Dependencies of Views and Synonyms
B.
None
C.
Displaying Schema Objects by Type
D.
Displaying Dependencies of Views and Synonyms
5: 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?
A. All
B. GRANT
C. CREATE VIEW
D. CREATE TABLE
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?
A.
Flashback Database
B.
Flashback Table
C.
Flashback Drop
D.
Flashback Version Query
7: Which User System Privilege used for this operation authorized to connect to the database?
A. CREATE SEQUENCE
B. CREATE TABLE
C. CREATE VIEW
D. CREATE SESSION
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?
A. Use the DROP and CREATE statements
B. Use the TRUNCATE statement
C. Use the DELETE statementc
D. All
9: 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?
A. It fails if any existing row violates the constraint
B. It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.
C. 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.
D. It does not validate the existing data in the table
10: To rename an object, it must be in your schema. You can rename schema objects in either of the following ways?
A. Drop and re-create the object And Rename the object using the RENAME statement
B. Rename the object using the RENAME statement
C. Create the object
D. Drop and re-create the object
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.
A.
4,2,1,3
B.
2,1,3,4
C.
1,3,2,4
D.
1,2,3,4
12: You cannot issue a SET CONSTRAINT statement inside a trigger?
A. False
B. True
13: 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?
A. False
B. True
14: Which two are valid locking levels that are used by transactions in an Oracle database?
A. Row level
B. Object level
C. Block level
D. Row level And Object level
15: You analyze a schema object (table, index, or cluster) to?
A. UnIdentify migrated and chained rows of a table or cluster
B. None
C. Does not verify the validity of its storage format
D. No need to Collect and manage statistics for it
List of Schema Objects MCQs Mu...
Available in:
Schema Objects MCQs
