Oracle认证 - 自考题库

出自:Oracle认证

View the Exhibit to see the output of queries on DATABASEPROPERTIES and DBAUSERS.

You observe that the current default permanent tablespace of the database is running out of space and you decide to change it to NEWDEFTBSP. You create a new user， USER04， after changing the default permanent tablespace of the database. What would be the new user’s default tablespace？（）
A:DEFTBSP
B:SYSTEM
C:NEWDEFTBSP
D:USERS and NEWDEFTBSP both
E:USERS

（）是Oracle最高一级逻辑存储结构。
A:块
B:盘区
C:段
D:表空间

The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner？（）
A: Allow the database to continue running，drop the TEMP tablespace，and then re-create it with new tempfiles
B: Shut down the database， restore and recover the tempfile from backup，and then open the database with RESETLOGS
C: Allow the database to continue running，take the TEMP tablespace offline，drop the missing tempfile，and then create a new tempfile
D: Allow the database to continue running，add a new tempfile to TEMP tablespace with a new name，and drop the tempfile that has been corrupted

You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）
A:Enable the flash recovery area and specify it as the archived redo log destination.
B:Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
C:Enable the flash recovery area but do not specify it as the archived redo log destination.
D:Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.

You executed the following command in the Recovery Manager （RMAN）： RMAN> REPORT NEED BACKUP days 3； What is the output of this command？（）
A: A list of files that require a backup within 3 days
B: A list of files requiring more than 3 days of archivelogs to apply
C: A list of files that RMAN recommends be backed up only once in every three days，based on low volatility
D: A list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

假设需要删除某个角色test_role，可以使用如下（）语句。
A:DELETE ROLE test_role
B:REVOKE ROLE test_role
C:DROP ROLE test_role
D:DELETE test_role

在Oracl中，哪种表分区维护操作可以将非分区表转换为分区表的分区（）。
A:添加分区
B:结合分区
C:交换表分区
D:合并分区

You perform a backup using the following BACKUP command： RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE； Which statement is true of this command？（）
A: A different procedure is required to restore a database from compressed backups
B: The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
C: Using this command to create backups minimizes the bandwidth consumed
D: Using this command to create backups improves the performance of the backup process

You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）
A:All the objects of scott are moved to the Recycle Bin.
B:Any objects in the Recycle Bin belonging to scott are purged.
C:All the objects owned by scott are permanently dropped from the database.
D:All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
E:Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

Which three methods can you use to run an Automatic Database Diagnostic Monitor （ADDM） analysis over a specific time period？（）
A: Enterprise Manager GUI
B: DBMS_TRACE package APIs
C: DBMS_ADVISOR package APIs
D: DBMS_MONITOR package APIs
E: $ORACLE_HOME/rdbms/admin/addmrpt.sql script

下面哪一个不是数据库物理存储结构中的对象（）
A:数据文件
B:重做日志文件
C:控制文件
D:口令文件

An RMAN backup job fails， displaying the following error： ORA-19809： limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in the future？（）
A: take the backup of the flash recovery area less frequently
B: increase the value of the UNDO_RETENTION initialization parameter
C: change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTO
D: change the backup retention policy to retain the backups for a smaller period of time
E: increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameter
F: increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter

Given that: Gadget has-a Sprocket and Gadget has-a Spring and Gadget is-a Widget and Widget has-a Sprocket Which two code fragments represent these relationships? （）
A:

In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）
A: the V$LOG view
B: the V$DBFILE view
C: the V$LOGFILE view
D: the V$INSTANCE_RECOVERY view
E: Oracle Enterprise Manager Database Control

Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）
A:Allocates memory for RMAN backup and restore operations
B:Allocates memory for shared and private SQL areas
C:Contains a cursor area for storing runtime information about cursors
D:Contains stack space
E:Contains a hash area performing hash joins of tables

The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?（）
A:The tape I/O performed is asynchronous
B:The tape buffer is allocated from the System Global Area (SGA)
C:The tape buffer is allocated from the Program Global Area (PGA)
D:Oracle I/O uses an interrupt mechanism to determine when each I/O completes

Which datatype is returned by the FIND_MENU_ITEM built-in function?（）
A:number
B:Boolean
C:menuitem
D:VARCHAR2

Examine this statement： RMAN >BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus1 DATABASE filesperset = 2； What state must the target database be in for you to use this RMAN command？（）
A:The target database must be open.
B:The target database must be closed.
C:The target database must be mounted.
D:The target database must be mounted or open.

Which is an /SQL*Plus command?（）
A:INSERT
B:UPDATE
C:SELECT
D:DESCRIBE
E:DELETE
F:RENAME

Evaluate this SQL statement: SELECT e.emp_name, d.dept_name FROM employees e JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10,40) ORSER BY dept_name; The statement fails when executed. Which change fixes the error? （）
A:remove the ORDER BY clause
B:remove the table alias prefix from the WHERE clause
C:remove the table alias from the SELECT clause
D:prefix the column in the USING clause with the table alias
E:prefix the column in the ORDER BY clause with the table alias
F:replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"

The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1. Display the salary multiplied by the commission_pct. 2. Exclude employees with a zero commission_pct. 3. Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide?（）
A:All of the desired results
B:Two of the desired results
C:One of the desired results
D:An error statement

假设需要删除数据库中的CUSTOMER表，可以使用如下（）方式。
A:DROP TABLE CUSTOMER
B:DROP CUSTOMER
C:DELETE TABLE CUSTOMER
D:DELETE CUSTOMER

Which of the following environment variables specifies a non-default location for the listener configuration file？（）
A:LSN_ADMIN
B:TNS_ADMIN
C:ADMIN_TNS
D:TSN_ADMIN

Which statement about the enabling of table compression in Oracle Database 11g is true?（）
A:Compression can be enabled at the table, tablespace, or partition level for direct loads only.
B:Compression can be enabled only at the table level for both direct loads and conventional DML.
C:Compression can be enabled at the table, tablespace, or partition level for conventional DML only.
D:Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.

以下关于ORACLE9i的叙述正确的是（）
A:ORACLE9i是一种关系型数据库服务器产品，是在ORACLE8i的基础上发展起来的。
B:Oracle9i Application Server（AS）是一种面向Internet应用的数据库服务器。
C:Oracle9i Developer Suite（DS）是一套面向于NET框架结构的开发工具集。
D:ORACLE9i数据库服务器要在ORACLE9iAS和ORACLE9iDS的配合下才能提供服务。
E:以上所述都不正确

Which statements are true regarding the Query Result Cache? （）
A:It can be set at the system, session, or table level.
B:It is used only across statements in the same session.
C:It can store the results from normal as well as flashback queries.
D:It can store the results of queries based on normal, temporary, and dictionary tables.

You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter？（）
A: 0
B: 1
C: NONE
D: DEFAULT

Click the Exhibit button and examine the data from the EMP table. The COMMISSION column shows the monthly commission earned by the employee. Which three tasks would require subqueries or joins in order to be performed in a single step?（）

A:deleting the records of employees who do not earn commission
B:increasing the commission of employee 3 by the average commission earned in department 20
C:finding the number of employees who do NOT earn commission and are working for department 20
D:inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3
E:creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSION of the EMP table
F:decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more than 800

You issued the following block of code： SQL>BEGIN DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（ ’PROG_ROLE’， ’DEVELOPERS’ ，FALSE）； END； SQL>/ Which option is NOT a result of executing the above code？（）
A: The switch privilege is granted to the PROG_ROLE role.
B: The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.
C: The users cannot grant the switch privilege to other users.
D: The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.

首页 <上一页 77 78 79 80 81 下一页> 尾页