Explore topic-wise MCQs in Oracle (MCQ) questions and answers.

This section includes 15 Mcqs, each offering curated multiple-choice questions to sharpen your Oracle (MCQ) questions and answers knowledge and support exam preparation. Choose a topic below to get started.

1.

Which of the following errors are correctable?

A. Out of space condition
B. Space Quota exceeded condition
C. Minimum extents reached condition
D. Both A & B
Answer» E.
Discussion
2.

In Suspended Statements which view is used When a statement is suspended the session invoking the statement is put into a wait state. A row is inserted into this view for the session with the EVENT column containing "statement suspended, wait error to be cleared"?

A. V$SESSION_WAIT
B. DBA_RESUMABLE
C. USER_RESUMABLE
D. None of the above
Answer» B. DBA_RESUMABLE
Discussion
3.

Which effects will a trigger have in the AFTER SUSPEND trigger whenever a resumable statement is suspended in any session?

A. If an undo segment has not reached its space limit, then a message is sent to the DBA and the statement is aborted
B. If any other recoverable error has occurred, the timeout interval is reset to 10 hours
C. Both A & B
D. None of the above
Answer» E.
Discussion
4.

Why do you analyze a schema object (table, index, or cluster)?

A. No need to Collect and manage statistics for it
B. Does not verify the validity of its storage format
C. UnIdentify migrated and chained rows of a table or cluster
D. None of the above
Answer» E.
Discussion
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?

A. CREATE TABLE
B. CREATE VIEW
C. GRANT
D. All mentioned above
Answer» E.
Discussion
6.

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?

A. CREATE_TASK
B. CREATE_OBJECT
C. EXECUTE_TASK
D. SET_TASK_PARAMETER
Answer» B. CREATE_OBJECT
Discussion
7.

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_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» D. None of the above
Discussion
8.

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_NAMEFROM DBA_SYNONYMSWHERE OWNER = 'JWARD';The following is the query output:TABLE_OWNER----TABLE_NAME----SYNONYM_NAME---------------------- ----------- -----------------SACHIN---------DEPT----------DEPTSACHIN---------EMP-----------EMP

A. Displaying Schema Objects by Type
B. Displaying Dependencies of Views and Synonyms
C. Both A & B
D. None of the above
Answer» C. Both A & B
Discussion
9.

Where are theLOBs and varrays stored?

A. LOB segments
B. Storage table
C. Both A & B
D. None of the above
Answer» B. Storage table
Discussion
10.

How many levels can we request advice from the Segment Advisor?

A. 4
B. 2
C. 3
D. 1
Answer» D. 1
Discussion
11.

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

A. CREATE TABLE
B. CREATE VIEW
C. CREATE SESSION
D. CREATE SEQUENCE
Answer» D. CREATE SEQUENCE
Discussion
12.

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.

A. 1, 2, 3, 4
B. 2, 1, 3, 4
C. 4, 2, 1, 3
D. 1, 3, 2, 4
Answer» B. 2, 1, 3, 4
Discussion
13.

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?

A. SET_SESSION_TIMEOUT(sessionID,timeout)
B. GET_TIMEOUT()
C. SET_TIMEOUT(timeout)
D. GET_SESSION_TIMEOUT(sessionID)
Answer» C. SET_TIMEOUT(timeout)
Discussion
14.

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

A. TRUE
B. FALSE
C. UNLIMITED
D. None of the above
Answer» D. None of the above
Discussion
15.

To rename an object, it must be in your schema. What are the ways to rename the schema objects?

A. Drop and re-create the object
B. Rename the object using the RENAME statement
C. Create the object
D. Both A & B
Answer» E.
Discussion