出自:Oracle认证

Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state， prior to the load operation？（）
A:INDEXES
B:SKIP_INDEXES_MAINTENANCE
C:SKIP_UNUSABLE_INDEXES
D:RESUMABLE
E:INDEXES_UNUSABLE
The Automatic Database Diagnostic Monitor （ADDM） analysis runs every 60 minutes on your database. Your database if facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do？（）
A:A
B:B
C:C
D:D
E:E
You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP;  How does RMAN find the control file autobackup？（）
A:by using the trace file
B:by using the alert log file
C:by using the database ID
D:by using the server parameter file
E:by using the V$CONTROLFILE view
F:by using the autobackup format configuration setting
In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN: RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2 BACKUP TYPE TO BACKUPSET; RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE disk FORMAT '/home/oracle/disk1/%U'; RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE disk FORMAT '/home/oracle/disk2/%U'; You issue the following RMAN command to backup the database: RMAN> RUN 2> { 3> ALLOCATE CHANNEL ch1 DEVICE TYPE disk; 4> BACKUP DATABASE; 5> } Which statement is true about the outcome?（）
A:Only one channel is allocated and the backup is created in the flash recovery area
B:Only one channel is allocated and the backup is created in the destination specified for channel 1
C:Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
D:Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid?（）
A:DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
B:DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);
C:DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');
D:DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');
Which two statements are true about constraints? （）
A:The UNIQUE constraint does not permit a null value for the column.
B:A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.
C:The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.
D:The NOT NULL constraint ensures that null values are not permitted for the column.
Which statement is true regarding the effect of this command on the transaction in Scott’s session（）
A:The command fails as a transaction is still pending.
B:The transaction in Scott’s session is rolled back and the tablespace becomes read-only.
C:The command waits and the user SCOTT can execute data manipulation language （DML） statements only as part of the current transaction.
D:The command hangsuntil all transactions on the objects in the tablespace commit or rollback， and then the tablespace is placed in read-only mode.
Click the Exhibit button. Given:Which statement is true if a TestException is thrown on line 3 of class B? （）
A:Line 33 must be called within a try block.
B:The exception thrown by method1 in class A is not required to be caught.
C:The method declared on line 31 must be declared to throw a RuntimeException.
D:On line 5 of class A, the call to method2 of class B does not need to be placed in a try/catch block.
You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option.  After some days， you want to change the status of the database backup and you issued the following command：   RMAN>CHANGE BACKUPSET 231 NOKEEP；   What is the implication of this command？（）
A: The backup is deleted.
B: The backup is marked unavailable.
C: The backup overrides the backup retention policy.
D: the backup becomes eligible for deletion according to the existing retention policy.
In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command: Which authentication method would be used first?（）
A:authentication by password file
B:authentication by using certificates over SSL
C:authentication by using the Oracle Internet Directory
D:authentication by using the local OS of the database server
Which two tasks can your perform by using the TO_CHAR function? （）
A:Convert 10 to 'TEN'
B:Convert '10' to 10
C:Convert '10' to '10'
D:Convert 'TEN' to 10
E:Convert a date to a character expression
F:Convert a character expression to a date
Which object privileges can be granted on a view?（）
A:none
B:DELETE, INSERT,SELECT
C:ALTER, DELETE, INSERT, SELECT
D:DELETE, INSERT, SELECT, UPDATE
Examine the description of the MARKS table: SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: What is the result of the SELECT statement?（）
A:The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.
B:The statement returns an error at the SELECT clause.
C:The statement returns an error at the WHERE clause.
D:The statement returns an error at the ORDER BY clause.
You created a tabular report for human resources department. After viewing layout users have requested that you change the label of the dept column to something more meaningful. How would you change the label in the live previewer?（）
A:Use the report wizard to change the column label. 
B:Click and high light the column label and replace it with desired text. 
C:Click the column label and alter its property palette. 
D:Click the dept column and alter its property palette. 
You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode.  How would you do this？（）
A:Execute the ALTER DATABASE ARCHIVELOG statement 
B:Select ARCHIVELOG option in the database control and restart the database to apply the changes. 
C:Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement. 
D:Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement. 
Given: What is the result?（）
A:210
B:211
C:321
D:322
E:Compilation fails.
F:An exception is thrown at runtime.
The configuration of the online redo log files is as follows：   Based on this configuration， which statement is true？（）
A: The LGWR process concurrently writes the redo log entries to both the members of a group.
B: When a member of a group becomes corrupt， the database crashes.
C: The sizes of the redo01a.log and redo01b.log online redo log members of group Group1 can be different.
D: When redo02a.log and redo02b.log files become corrupt， then the database operations will proceed as normal.
You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components？（）  
A: MMAN
B: PMON
C: MMON
D: MMNL
You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）
A: rman TARGET / NOCATALOG
B: rman TARGET sys/password
C: rman TARGET sys/password AS SYSDBA
D: rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
To make audit information more productive， the DBA executes the following command before starting an auditoperation： SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting Thedatabase（）
A:It contains only the plan for the SQL statement executed by the user.
B:It contains the SQL text executed by the user and the bind variables used with it.
C:It contains the plan and statistics associated with the SQL statement executed by the user.
D:It contains the plan for the SQL statement executed by the user and the bind variables used with it
Which two statements about Oracle Direct Network File System (NFS) are true?（）
A:It bypasses the OS file system cache.
B:A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.
C:It uses the operating system kernel NFS layer for user tasks and network communication modules.
D:File systems need not be mounted by the kernel NFS system when being served through Direct NFS.
E:Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.
You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）
A: Memory Advisor
B: Segment Advisor
C: SQL Access Advisor
D: Automatic Workload Repository （AWR）
E: Automatic Database Diagnostic Monitor （ADDM）
Which three tasks can be performed using a duplicate database? （）(Choose three.)
A:Testing the backup and recovery procedures
B:Testing the upgrade of an Oracle database to a new release
C:Testing the effect of an application changes on database performance
D:Continuously updating archive log files from the target database to support failover
以下对INSERT语句，说法错误的是（）。
A:INSERT语句是数据操纵语言中的一条语句
B:在使用INSERT语句执行数据插入时，表中的列顺序一定要与提供的值顺序相同
C:在使用INSERT语句执行数据插入时，必须为表中所有列定义数据值
D:在插入数据时，应当满足表中定义的检查约束
You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）
A: Query the V$FLASHBACK_DATABASE_LOG view.
B: Query the V$FLASHBACK_DATABASE_STAT view.
C: Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
D: Query the V$RECOVERY_FILE_DEST view.
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL: There is enough free space in the disk group for mirroring to be done. What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?（）
A:Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
B:Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
C:The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
D:ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
E:Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
怎样取出在集合A中，但却不在集合B中的数据（）
A:A MIUS B
B:B MINUS A
C:A INTERSECT B
D:B INTERSECT A
You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）
A: restore the tablespace from the backup； there is no need to apply the redo information
B: restore the full database to recover the data up to the point when you performed the backup
C: restore the tablespace from the backup and then perform a recovery using the backup control file
D: restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied
Which command would you use to determine what database backups are currently available for restore?（）
A:list database backup
B:report database backup  
C:list backup of database
D:list summary backup
E:report backup of database
DRAG DROP Click the Task button.
首页 <上一页 9 10 11 12 13 下一页> 尾页