Here, you can read Oracle Tables multiple choice questions and answers with explanation.
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!
|
|
