Managing Tables - Oracle placement test

Managing Tables - Oracle placement test


1) Which type of table is a group of tables that share the same data blocks because they share common columns and are often used together?

A) Ordinary table
B) Partitioned table
C) Clustered table
D) Index-organized table
View Answer / Hide Answer

ANSWER: C) Clustered table




2) The NOLOGGING clause causes minimal redo information to be generated during the table creation this has which of the benefits?

A) Space is not saved in the redo log files
B) The time it takes to create the table is increased
C) Performance does not improves for parallel creation of large tables
D) None of the above
View Answer / Hide Answer

ANSWER: D) None of the above




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

A) INSERT statement
B) MERGE statement
C) Both A & B
D) None of the above
View Answer / Hide Answer

ANSWER: A) INSERT statement




4) In the error Logging Table format which set of columns that contain data from the row that caused the error. The column names match the column names from the table being inserted into (the

"DML table")?

A) Optional set
B) Mandatory set
C) Both A & B
D) None of the above
View Answer / Hide Answer

ANSWER: A) Optional set




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

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
View Answer / Hide Answer

ANSWER: E) All mentioned above




6) In which INSERT operation the database reuses free space in the table, interleaving newly inserted data with existing data. During such operations, the database also maintains referential

integrity constraints?

A) Direct-path INSERT
B) Conventional Insert
C) Both A & B
D) None of the above
View Answer / Hide Answer

ANSWER: B) Conventional Insert




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

A) Direct-path INSERT without Logging
B) Direct-Path INSERT with Logging
C) Both A & B
D) Nome of the above
View Answer / Hide Answer

ANSWER: B) Direct-Path INSERT with Logging




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

A) True
B) False
View Answer / Hide Answer

ANSWER: B) False




9) If START_REDEF_TABLE fails for any reason, you must call ABORT_REDEF_TABLE, otherwise subsequent attempts to redefine the table will fail?

A) True
B) False
View Answer / Hide Answer

ANSWER: A) True




10) In which tables Tables schema cannot be redefined online?

A) SYS
B) SYSTEM
C) Both A & B
D) None of the above
View Answer / Hide Answer

ANSWER: C) Both A & B




11) In Viewing and querying Objects in the recycle bin which view gives administrators visibility to all dropped objects in the recycle bin?

A) USER_RECYCLEBIN
B) DBA_RECYCLEBIN
c) Both A & B
D) None of the above
View Answer / Hide Answer

ANSWER: B) DBA_RECYCLEBIN




12) For external tables which privileges are required for directory objects containing bad, log, or discard files?

A) READ
B) WRITE
C) READ & WRITE
D) None of the above
View Answer / Hide Answer

ANSWER: B) WRITE




13) All data in a database is stored in a table to include user data and the Data Dictionary?

A) True
B) False
View Answer / Hide Answer

ANSWER: A) True




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

A) True
B) False
View Answer / Hide Answer

ANSWER: A) True


Post your comment