Oracle Tables - Oracle (MCQ) questions and answers

1)   In the error Logging Table format, which set of columns contain data from the row that caused the error and the column names match the column names from the table being inserted into (the "DML table")?

- Published on 12 Aug 15

a. Optional set
b. Mandatory set
c. Both A & B
d. None of the above
Answer  Explanation 

ANSWER: Optional set

Explanation:
No explanation is available for this question!


2)   Error Logging Restrictions and Caveats Oracle Database logs which of the following errors during DML operations?

- Published on 12 Aug 15

a. Column values those are too large
b. Constraint violations (NOT NULL, unique, referential, and check constraints)
c. Errors raised during trigger execution
d. Partition mapping errors
e. All mentioned above
Answer  Explanation 

ANSWER: All mentioned above

Explanation:
No explanation is available for this question!


3)   In which mode Oracle Database performs full redo logging for instance and media recovery. If the database is in ARCHIVELOG mode, then you can archive redo logs to tape. If the database is in NOARCHIVELOG mode, then you can recover instance crashes but not disk failures?
- Published on 12 Aug 15

a. Direct-path INSERT without Logging
b. Direct-Path INSERT with Logging
c. Both A & B
d. None of the above
Answer  Explanation 

ANSWER: Direct-Path INSERT with Logging

Explanation:
No explanation is available for this question!


4)   Which method enables you to add rows to a table, either by specifying the column values or by specifying a subquery that selects data from another existing table?
- Published on 12 Aug 15

a. INSERT statement
b. MERGE statement
c. Both A & B
d. None of the above
Answer  Explanation 

ANSWER: INSERT statement

Explanation:
No explanation is available for this question!


5)   Which INSERT operation does the database reuses free space in the table, interleaving newly inserted data with the existing data and during such operations, the database also maintains referential integrity constraints?
- Published on 12 Aug 15

a. Direct-path INSERT
b. Conventional Insert
c. Both A & B
d. None of the above
Answer  Explanation 

ANSWER: Conventional Insert

Explanation:
No explanation is available for this question!


6)   A Synonym is another name for an object. It is used to simplify access to objects such as tables owned by another user or to shorten lengthy object name.
- Published on 04 Aug 15

a. True
b. False
Answer  Explanation 

ANSWER: True

Explanation:
No explanation is available for this question!


7)   If START_REDEF_TABLE fails for any reason, you must call ABORT_REDEF_TABLE, otherwise subsequent attempts to redefine the table will fail.
- Published on 04 Aug 15

a. True
b. False
Answer  Explanation 

ANSWER: True

Explanation:
No explanation is available for this question!


8)   All data in a database is stored in a table to include user data and the Data Dictionary.
- Published on 03 Aug 15

a. True
b. False
Answer  Explanation 

ANSWER: True

Explanation:
No explanation is available for this question!


9)   Oracle Database provides a mechanism to make table structure modifications with significantly affecting the availability of the table. The mechanism is called online table redefinition.
- Published on 19 Oct 15

a. True
b. False
Answer  Explanation 

ANSWER: False

Explanation:
No explanation is available for this question!


10)   In Viewing and querying Objects in the recycle bin which view gives administrators visibility to all dropped objects in the recycle bin?
- Published on 29 Jul 15

a. USER_RECYCLEBIN
b. DBA_RECYCLEBIN
c. Both A & B
d. None of the above
Answer  Explanation 

ANSWER: DBA_RECYCLEBIN

Explanation:
No explanation is available for this question!


1 2