Oracle Schema - Oracle (MCQ) questions and answers

Here, you can read Oracle Schema multiple choice questions and answers with explanation.

1)   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?

- Published on 13 Aug 15

a. It fails if any existing row violates the constraint
b. It does not validate the existing data in the table
c. It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.
d. Both A & C
e. Both A & B
Answer  Explanation 

ANSWER: Both A & C

Explanation:
No explanation is available for this question!


2)   DBMS_ADVISOR package procedures relevant to the segment advisor which package procedure name use this procedure to create the Segment Advisor task. Specify 'Segment Advisor ‘as the value of the ADVISOR_NAME parameter?
- Published on 12 Aug 15

a. CREATE_TASK
b. CREATE_OBJECT
c. EXECUTE_TASK
d. SET_TASK_PARAMETER
Answer  Explanation 

ANSWER: CREATE_TASK

Explanation:
No explanation is available for this question!


3)   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?
- Published on 12 Aug 15

a. DBA_OBJECTS, ALL_OBJECTS, USER_OBJECTS
b. DBA_DEPENDENCIES, ALL_DEPENDENCIES, USER_DEPENDENCIES
c. DBA_CATALOG, ALL_CATALOG, USER_CATALOG
d. None of the above
Answer  Explanation 

ANSWER: DBA_CATALOG, ALL_CATALOG, USER_CATALOG

Explanation:
No explanation is available for this question!


4)   The following query lists all of the base objects for the synonyms created by user jward. What is displayed by the following example?

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

- Published on 12 Aug 15

a. Displaying Schema Objects by Type
b. Displaying Dependencies of Views and Synonyms
c. Both A & B
d. None of the above
Answer  Explanation 

ANSWER: Displaying Dependencies of Views and Synonyms

Explanation:
No explanation is available for this question!


5)   What can be included in the CREATE SCHEMA statement which is useful if you want to guarantee the creation of several tables, views, and grants in one operation?

- Published on 12 Aug 15

a. CREATE TABLE
b. CREATE VIEW
c. GRANT
d. All mentioned above
Answer  Explanation 

ANSWER: All mentioned above

Explanation:
No explanation is available for this question!


6)   Where are the LOBs and varrays stored?
- Published on 12 Aug 15

a. LOB segments
b. Storage table
c. Both A & B
d. None of the above
Answer  Explanation 

ANSWER: LOB segments

Explanation:
No explanation is available for this question!


7)   Efficient Use of Integrity Constraints: A Procedure Using integrity constraint states in which of 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.

- Published on 12 Aug 15

a. 1, 2, 3, 4
b. 2, 1, 3, 4
c. 4, 2, 1, 3
d. 1, 3, 2, 4
Answer  Explanation 

ANSWER: 1, 2, 3, 4

Explanation:
No explanation is available for this question!


8)    The Input parameter time limit for DBMS_ADVISOR>SET_TASK_PARAMETER in which the time limit for the Segment Advisor run, specified in seconds the possible value is any number of seconds and default value will be _________.
TRUE

- Published on 12 Aug 15

a. TRUE
b. FALSE
c. UNLIMITED
d. None of the above
Answer  Explanation 

ANSWER: UNLIMITED

Explanation:
No explanation is available for this question!


9)   To rename an object, it must be in your schema. What are the ways to rename the schema objects?
- Published on 04 Aug 15

a. Drop and re-create the object
b. Rename the object using the RENAME statement
c. Create the object
d. Both A & B
Answer  Explanation 

ANSWER: Both A & B

Explanation:
No explanation is available for this question!


10)   In DBMS_RESUMABLE Package, which function returns the current timeout value of resumable space allocation for the current session and the returned value is in seconds?
- Published on 04 Aug 15

a. SET_SESSION_TIMEOUT(sessionID,timeout)
b. GET_TIMEOUT()
c. SET_TIMEOUT(timeout)
d. GET_SESSION_TIMEOUT(sessionID)
Answer  Explanation 

ANSWER: GET_TIMEOUT()

Explanation:
No explanation is available for this question!


1 2 3