Oracle Practice test for OCP

Where can you obtain information about full data base backup set created using RMAN, if the control file was used as the repository?
V$BACKUPSET
RC_DATABASE
V$BACKUP_SET
RC_BACKUP_SSET
Which script must you to query to display the code associated with RMAN stored scripts?
RC_STORED_SCRIPT
RC_STORED_SCRIPT-LINE
RC_SCRIPTS
RC_STORED_LINE_SCRIPT
Which of the following parameters would you use to record the errors that might be generated during the import operation?
LOG
HELP
BUFFER
PARFILE
Which oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener?
PMON
SMON
LGWR
CKRT
Which of the following options enables a user to get authenticated through a single password instead of using multiple passwords?
Wallet manager
Rdius
Oracle internet Directory
None of the above
Which of the following roles must be granted to use to perform a full data base import?
connect
IMPORT-FULL-DATABASE
RESOURCE
FULL-IMPORT_PRIVS
Which parameter allows SQL * loader to load data into a table with the indexes in the unusable state, prior to the load operation?
INDEXES
SKIP_UNUSABLE_INDEXES
RESUMABLE
INDEXES_UNUSABLE
Which of the following roles provides the privileges to maintain and query the recovery cat log schema?
CONNECT
RESOURCE
RECOVERY_CATLOG_OWNER
RECOVERY_CATLOG_USER
Which of the following files can not be cataloged using the CATALOG COMMAND?
Data files
Control files
Archived log iles
Files sorting RMAN SCRIPTS
To perform a data base point in-time-recovery using RMAN, after database restoration, you must ensure that the database in which of the following states?
OPEN
MOUNT
NOMOUNT
CLOSE
Using the command shown here, what time format must you specify to recover the until a point-in-time? SQL> RECOVER DATABASE UNTILIME <’time format>’
YYYY-DD-MM:HH24:SS:MI
YYYY-DD-MM:HH24:SS:MM
YYYY-DD-MM:HH24:MI:SS
YYYY-DD-MM:HH24:SS:MI
Which of the following statements is NOT true about RMAN?
It improves usability by enabling you to reuse the scripts to perform recovery operations.
It detects block corruption while restoration and recovery operation.
It enables you to perform block media recovery.
It is capable to recover through un recoverable operations, with only full data base backups.
Which of the following would you use to enable automatic media recovery for a database?
SET AUTORECOVERY ON
SET RECOVERY ON
SET AUTO ON
You cannot enable automatic media recovery.
What is a significance of specifying the DELETEINPUT OPTION WHILE PERFORMING THE BACKUP OF ARCHIVE LOG FILES?
RMAN will delete the archive log files from the first archive destination.
RMAN will delete the archive log files from all enabled archiving destinations after backing up.
RMAN will delete the archive log files from all enabled archiving destinations expect the primary destination.
RMAN deletes any other files from its location that accompany the archive log files during the backup operation.
Which of the following shut down options should not be used before performing a consistent whole database backup?
NORMAL
TRANSACTIONAL
ABORT
IMMEDIATE
Which of the following commands can not be use the functionally associated with the NLS_DATE_FORMAT variable?
RESTORE
RECOVER
REPORT
BACKUP
What is the maximum number of ARCn process that can be defined using the initialization parameter LOG_ARCHIVE_MAX_PROCESSES?
1
5
10
115
Which of the following statement is incorrect regarding RMAN?
It detects corrupt blocks.
It performs only offline database backups.
It omits empty blocks during backups.
It performs tablespace point-in-time recovery.
The oracle net Architecture is based on the following?
OCI
OSI
TCP/IP
SNMP
Which of the following file should be configured for dynamic service registration?
LISTNER.ORA
SQLNET.ORA
INIT.ORA
TNSNAMES.ORA
Description:

Oracle Practice test for OCP
Disclaimer: Content, such as images used in the questions (if any), have been picked up from various places for the sole purpose of Instruction.

Discussion

Shankar

not able to load the questions

1123 days 21 hours 59 minutes ago

I_will_not_tell

Hurr Durrr

3032 days 2 hours 23 minutes ago

shiri

it is good for every oracle job holder bcz it is essential before going to interviews

3052 days 7 hours 36 minutes ago

Ahmad Al-Baik

I Alrady work with SQL , But i would like to make test and have License.

3613 days 1 hours 18 minutes ago

hem singh paraste

i am request to you also that advice me for it preperation. i want world class books for its prepetion so please message ocp books name also. thanku

3735 days 1 hours 46 minutes ago

hem singh paraste

i want to do ocp course and want to make career in oracle so i want advice from you. it is good for my futer or not.please advice write.

3735 days 1 hours 52 minutes ago

Your Facebook Friends on WizIQ

More Tests By Author

ASP Server Controls
10 Questions | 667 Attempts

ASP.NET, Namespaces ASP.NET
10 Questions | 2028 Attempts

An ASP.NET Application
10 Questions | 437 Attempts

Explore Similar Courses

Oracle ADF Online

Price:$100