单项选择题

You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file：  
INSTANCE_TYPE = ASM  ASM_POWER_LIMIT = 11  LARGE_POOL_SIZE = 4M  
ASM_DISKGROUPS = DG1， DG2  DB_UNIQUE_NAME = +ASM  
You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）

A. only the INSTANCE_TYPE initialization parameter is set to an invalid value
B. only the ASM_POWER_LIMIT initialization parameter is set to an invalid value
C. only the LARGE_POOL_SIZE initialization parameter is set to an invalid value
D. both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题

You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database.  
Which information is NOT required during the migration process？（）

A. Database Identifier （DBID）
B. names and location of datafiles
C. names and location of control files
D. names and location of online redo log files

点击查看答案
2.单项选择题You are the Database Administrator for WonderWeb， which has recently acquired a media company TXGlobal. You have been assigned the task to migrate all the database applications of TXGlobal to the database server of WonderWeb. To accommodate more database applications， you need to add disks to the existing disk group. Whenever you add or remove disks from the disk group， Automatic Storage Management （ASM） rebalancing distributes the data evenly across all the disks of the disk group. Which background process performs this actual rebalancing activity， resulting in the movement of data extents in the disk groups？（）  

A. ASMB
B. ARBn
C. RBAL in the ASM instance
D. RBAL in the database instance

点击查看答案
3.单项选择题

Consider the following configuration：  
/devices/diskP1 is a member of disk group grp1.       
/devices/diskP2 is a member of disk group grp1.       
/devices/diskP3 is a member of disk group grp1.       
/devices/diskP4 is a candidate disk.       
/devices/diskQ1 is a member of disk group grp2.       
/devices/diskQ2 is a member of disk group grp2.       
/devices/diskQ3 is a member of disk group grp2.       
/devices/diskQ4 is a candidate disk.  
Which command will add the disk /devices/diskP4 to the disk group， grp1？（）  

A. ALTER DISKGROUP grp1  ADD DISK ’/devices/diskP1’，  ADD DISK ’/devices/diskP4’；
B. ALTER DISKGROUP grp1  ADD DISK ’/devices/disk*4’；
C. ALTER DISKGROUP grp1  ADD DISK ’/devices/diskP*’；
D. ALTER DISKGROUP grp1  ADD DISK ’/devices/diskQ*’，  ADD DISK ’/devices/diskP*’；

点击查看答案
4.单项选择题You are maintaining the SALES database on Oracle 10g. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter will you specify to control the speed of the rebalancing activity？ （） 

A. ASM_POWER_LIMIT
B. ASM_DISKSTRING
C. ASM_DISKGROUPS
D. LARGE_POOL_SIZE

点击查看答案
5.单项选择题Which statement will NOT create a tablespace？（）

A. CREATE TABLESPACE DATA1 DATAFILE ’+grp1/abc（datafile）’；
B. CREATE TABLESPACE DATA1 DATAFILE ’+grp1’；
C. CREATE TABLESPACE DATA1 DATAFILE ’+data1（tempfile）’；
D. CREATE TABLESPACE DATA1 DATAFILE ’+grp1.256.34359’；

点击查看答案
6.单项选择题You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）  

A. The database will not start.
B. The database will start but will not retain the undo data in the undo segment.
C. The database will start， and the undo segment will contain the undo data for at least one hour.
D. The database will start， and the undo segment will retain the undo data for at least 15 minutes.

点击查看答案
7.单项选择题You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）

A. The database must be in the ARCHIVELOG mode.
B. The automatic memory tuning must be enabled.
C. The change tracking feature must be enabled.
D. The automatic memory tuning must be disabled.

点击查看答案
8.单项选择题While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）

A. Memory Advisor
B. Segment Advisor
C. Undo Advisor
D. SQL Tuning Advisor

点击查看答案
9.单项选择题Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）  

A.ADDM
B.AWR
C.Cursor Cache
D.SQL Tuning Sets
E.Flash Recovery Area

点击查看答案
10.单项选择题You find that some queries on a table are taking a long time to execute because there are no indexes created on the table. You decide to invoke the SQL Access Advisor to determine the appropriate index to be created. Which package will you use to invoke the SQL Access Advisor？（） 

A.DBMS_SERVER_ALERT
B.DBMS_ADVISOR
C.DBMS_RESOURCE_MANAGER
D.DBMS_REPAIR

点击查看答案

最新试题

You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup，you need the database ID （DBID）. In which two sources would you find the DBID？ （）

题型：多项选择题

Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）

题型：单项选择题

You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format？（） 

题型：单项选择题

You disabled the Flashback Database feature by using the following command： SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs？（）

题型：单项选择题

The loss of the control file forced you to re­create the control file. After re­creating it and opening the database， you find that some of the data files are named as MISSINGnnnnn， where nnnnn is a five­digit number starting with 0. What could be the possible reason？（）

题型：单项选择题

In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file： In what sequence would you use this process to perform the recovery？（）

题型：单项选择题

Your database operates in ARCHIVELOG mode. User­managed consistent backups are performed every Sunday night. On Tuesday， client A drops a table at 8：00 a.m. as follows： SQL> DROP TABLE cust_ord PURGE; Table dropped. Client B executes a query at 9：00 a.m. on the same table as follows： SQL> SELECT * FROM cust_ord;SELECT * FROM cust_ord* ERROR at line 1： ORA­00942： table or view does not exist Client B needs the dropped table and reports the problem to you. With reference to this scenario， which action should you take？（）

题型：单项选择题

You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re­create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re­create the indexes？（）

题型：多项选择题

You performed a backup of the flash recovery area by using the following command for the first time：RMAN> BACKUP RECOVERY AREA; Which files in the flash recovery area are backed up？（）

题型：多项选择题

Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel­based recovery？（）

题型：多项选择题