站内搜索
OCP 11G认证考试 问题列表
问题
单选题What does it mean if a backup is expired?（）A
The backup set has exceeded the retention criteria set in RMAN and is eligible for removal. B
The backup set has one or more invalid blocks in it and is not usable for recovery. C
The backup set contains one or more tablespaces no longer in the database. D
The backup set contains one or more missing backup set pieces.E
The backup set is from a previous version of RMAN and was not upgraded.
问题
多选题Which three actions are required to configure the Flashback Database? （）Aset Flash Recovery AreaBenable Flashback loggingCcreate FLASHBACK tablespaceDstart the database in the ARCHIVELOG modeEstart the database in the NOARCHIVELOG mode
问题
单选题What view might you use to try to determine how long a particular backup will take?（）A
V$SESSION_EVENT B
V$SESSION C
V$W0041ITSD
V$WAITSTAT E
V$SESSION_LONGOPS
问题
单选题Which statement is true regarding this setting?（）A
It drops the connection after the specified number of login attempts fail for any user.B
It is enforced only if the password profile is enabled for the user. C
It locks the user account after the specified number of attempts. D
It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.
问题
多选题User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?（）AALTER DATABASE FLASHBACK ON;BGRANT SELECT any transaction TO scott;CGRANT EXECUTE ON dbms_flashback TO scott;DALTER DATABASE ADD SUPPLEMENTAL LOG DATA;EALTER TABLESPACE undots1 RETENTION GUARANTEE;FALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
问题
单选题You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?（）A
Set a threshold for the default system-defined moving window baseline.B
Add directives to the Automatic Database Diagnostic Monitor (ADDM).C
Modify the profile for the targeted users for which control needs to be imposed.D
Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.
问题
单选题Which statement is true regarding the INTERSECT operator?（）A
It ignores NULL values B
Reversing the order of the intersected tables alters the result C
The names of columns in all SELECT statements must be identical D
The number of columns and data types must be identical for all SELECT statements in the query
问题
单选题Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?（）A
2, 4, 3B
1, 4, 3, 2C
2, 5, 4, 3, 6D
5, 2, 4, 3, 6E
1, 5, 4, 3, 6, 2
问题
多选题What elements of globalization can be explicitly defined using the NLS_LANG environment variable?（）ANLS_LANGUAGEBNLS_SORTCNLS_CALENDARDNLS_CHARACTERSETENLS_TERRITORY
问题
多选题Which two statements about Oracle Direct Network File System (NFS) are true?（）AIt bypasses the OS file system cache.BA separate NFS interface is required for use across Linux, UNIX, and Windows platforms.CIt uses the operating system kernel NFS layer for user tasks and network communication modules.DFile systems need not be mounted by the kernel NFS system when being served through Direct NFS.EOracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.
问题
多选题Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（）AAlert log fileBArchived redo log filesCControl file autobackupsDServer Parameter file (SPFILE)ERecovery Manager (RMAN) backup piece
问题
单选题Which steps are mandatory to enable Direct NFS?（） 1. Mount all required file systems using the kernel NFS driver. 2. Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS. 3. Replace the ODM library libodm11.so_stub with libodm11.so.A
2 and 3B
1 and 3C
1 and 2D
1, 2 and 3
问题
单选题Automatic data conversion will occur if which of the following happens?（）A
The client and server have different NLS_LANGUAGE settings.B
The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.C
The client and server are in different time zones.D
The client requests automatic data conversion.E
The AUTO_CONVERT initialization parameter is set to TRUE.
问题
单选题Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?（）A
It cannot be done in parallel.B
It can be done at the table level or partition level.C
It does not require additional storage because the operation is done online.D
Local and global indexes are maintained automatically during the operation.
问题
单选题The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this: 1.SQL GRANT recovery_catalog_owner TO vpc1; 2.RMAN CONNECT CATALOG vpc1/password@catdb; 3.RMAN GRANT CATALOG FOR DATABASE prod1 TO vpc1; 4.RMAN CONNECT CATALOG catowner/password@catdb; 5.RMAN CREATE VIRTUAL CATALOG; What is the correct sequence in which the commands have to be executed?（）A
1, 4, 5, 2, 3B
1, 4, 3, 2, 5C
4, 5, 2, 3, 1D
2, 3, 4, 5, 1E
1, 4, 2, 3, 5