Oracle DBA Question $ Answers(Part 12)

1.When performing an open database backup, which statement is NOT true?

A.The database is fully accessible to all users.
B.The database must be operating in ARCHIVELOG mode.
C.The database can be open but only in READ ONLY mode.
D.The database tablespaces should be in BEGIN BACKUP mode.

correct answer: c


2.Which task can a DBA perform using the export/import facility?

A.Examine log files.
B.Recreate the control file.
C.Transport tablespaces between databases.
D.Make a logical backup of the rollback segment tablespace.

correct answer: c

3.Why does this command cause an error?
exp system/manager inctype=full file=expdat.dnp

A.The tables to export are not identified.
B.The user system cannot perform exports.
C.The full=y parameter needs to be specified.
D.The inctype parameter is not valid parameter.

correct answer: c

4. Which import option do you use to create tables without data?

A. ROWS
B. CREATE
C. INDEXES
D. CONSISTENT

correct answer: a

5. Which export option will generate code to create an initial extent that is equal to the sum of the sizes of all the extents currently allocated to an object?

A. FULL
B. DIRECT
C. COMPACT
D. COMPRESS

correct answer: d

6. Can I take 1 dump file set from my source database and import it into multiple databases?

A. Yes
B. No

correct answer: a

7. EXP command is used

A. To take Backup of the Oracle Database
B. To import data from the exported dump file
C. To create Rollback segments
D. None of the above

correct answer: a

8. Can we export a dropped table?

A. No
B. Yes

correct answer: a

9. What is the default value for IGNORE parameter in EXP/IMP?

A. Yes
B. No

correct answer: b

10. Why is Direct Path Export Faster?

A. This option By Passes the SQL Layer
B. All SGA is used for Export
C. All of the above
D. None of the above

correct answer: a