PM-DB.com

You work as a Database Administrator for PM-DB Inc. You have given the Data Pump command as follows:

expdp system/secret full=Y dumpfi|e= dir1:fulla%U.dmp, dir2:fullb%U.dmp

filesize 4g parallel=2 logfile=dir:full.log

Which of the following actions will the above-mentioned Data Pump command perform?

A: Perform a full database mode export to files in dir1 and dir2.

B: Perform a full table mode export to files in dir1 and dir2.

C: Perform a full schema mode export to files in dir1 and dir2.

You work as a Database Administrator for PM-DB Inc. One of the users in your company has committed an inappropriate transaction against a database. Which of the following Flashback

techniques will you use so that all the changes made in the database are reversed?

A: Flashback Transaction Query

B: Flashback Table

C: Flashback Version Query

D: Flashback Database

You work as a Database Administrator for PM-DB Inc. The database is functional but one of the disks containing a mirrored redo log member has bad sectors in it (corrupted). You are not able to fix this issue. Which of the following statements about the effect on the current database instance is true?

A: The instance will remain open but the LGWR process will fail.

B: There will be no effect on the instance.

C: The instance will remain open and will automatically create the corrupted redo log file member.

D: The instance will abort.

You work as a Database Administrator for PM-DB Inc. To start up a database, you issue the STARTUP command at the SQL*Plus prompt. While running the STARTUP command, you come across an error message due to datafile corruption. Which of the following error messages is most likely to have occurred?

A: ORA-30044: 'Retention' can only be specified for undo tablespace.

B: ORA-00054: resource busy and acquire with NOWAIT specified.

C: ORA-01157: cannot identify/lock data file 4 - see DBWR trace file

ORA-01110: data file 4: '/u05/oradata/ord/users01.dbf'

D: ORA-0155: snapshot too old.

You work as a Database Administrator for PM-DB Inc. You have been asked by your manager to submit a report regarding the settings of the production database server. While checking these settings, you come across the following parameter in the parameter file of the database:

REMOTE_05_AUTHENT = TRUE

What does this parameter imply?

A: It implies that the operating system authentication is enabled for a remote client.

B: It implies that the administration of the operating system is enabled from a remote client.

C: It implies that the administration of the operating system is disabled from a remote client.

D: It implies that the users are allowed to start up and shut down the database from a remote client.

You work as a Database Administrator for Bell Ceramics Inc. Your Manager has asked you to explain the minimum unit of I/O in a database. Which of the following units is correct, pertaining to this?

 Each correct answer represents a complete solution. Choose all that apply.

A: Page

B: Oracle block

C: Data block

D: Operating system block

A: SPFILE is used to configure instance and database options, where as PFILE is used to find out the memory allocation to SGA.

B: SPFILE is a text file, whereas PFILE is a binary file.

C: There is no basic difference between the two.

D: While making modifications in SPFILE, the instance has to be open and running, where as in the case of PFILE, the instance will have to be restarted before making any modifications in it.

You work as a Database Administrator for Gadgets Inc. The company uses Oracle as its database. The database contains a table named Employee. You create a constraint while creating the Employee table. However, you have not given a name to the constraint. Which of the following statements are true in such a scenario?

Each correct answer represents a part of the solution. Choose two.

A: The constraint and all the information are stored in USER_CONTRAINTS data dictionary view.

B: Oracle server displays an error message.

C: Oracle server creates the constraint name.

D: Oracle server does not create the constraint.

You work as a Database Administrator for PM-DB Inc. You have issued the following command to maintain a backup of the control file:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

Which of the following will you find in the trace file after execution of the above-mentioned command?

A: Contents of the control file in text format

B: SQL script to re-create the control file

C: An image of the control file

D: Contents of the control file in binary format