多项选择题

You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode.  
Which two statements are correct in this scenario？（）

A.The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
B.The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
C.Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management.
D.The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题Your database is using shared server configuration. Which optional memory structure would you configure to store the User Global Area （UGA） information and improve the shared pool performance？（）

A.large pool
B.streams pool
C.keep buffer cache
D.recycle buffer cache

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

In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB 
DB_CACHE_SIZE = 1GB 
SHARED_POOL_SIZE = 3GB 
STATISTICS_LEVEL = BASIC 
PGA_AGGREGATE_TARGET = 0 
You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）

A.The STATISTICS_LEVEL initialization parameter is set to BASIC
B.The PGA_AGGREGATE_TARGET initialization parameter is set to zero.
C.The SGA_MAX_SIZE initialization parameter is set to less than 20 GB
D.The DB_CACHE_SIZE initialization parameter is set to less than 5 GB
E.The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.

点击查看答案
3.单项选择题In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）

A.Oracle Migration Assistant
B.Recovery Manager （RMAN）
C.Oracle Data Pump Export and Import
D.conventional Oracle Export and Import
E.operating system utilities to copy the files to the ASM instance

点击查看答案
4.单项选择题You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager（RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？（）

A.RMAN would relocate all the database files to an ASM disk group.
B.RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.
C.RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
D.RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF

点击查看答案
5.多项选择题You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method  or command would you use to accomplish this task？（）

A.the CONVERT command of RMAN
B.Data Pump Export and Import into the same database
C.conventional export and import into the same database
D.the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
E.the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

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

Your production database uses an Automatic Storage Management （ASM） instance to manage its files. 
You want to add a new disk group to the ASM instance to manage the increased data load. 
What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

A.mount the new disk group in the ASM instance
B.restart the ASM instance and the production database instance
C.register the new disk groups in the production database instance
D.restart the ASM instance without restarting the production database instance
E.include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

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

You have a disk group， DGROUP1， with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group： 
ALTER DISKGROUP dgroup1 
ADD TEMPLATE my_temp 
ATTRIBUTES （MIRROR FINE）； 
Which statement is true？（）

A.When a file is created in DGROUP1 with the template， it would have three-way mirroring.
B.When a file is created in DGROUP1， the MY_TEMP template becomes the default template.
C.When a file is created in DGROUP1 with the template， it would have two-way mirroring and file striping.
D.When a file is created in DGROUP1 with the template， it would have three-way mirroring and file striping.
E.When a file is created in DGROUP1 with the template， it would have two-way mirroring but no file Striping.

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

You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command： 
ALTER DISKGROUP dg3 REBALANCE POWER 0；
What would be the result of this command？（）

A.The rebalancing of the disk group would be stopped.
B.The rebalancing of the disk group would be completed as fast as possible.
C.The command would result in an error because the value of POWER cannot be 0.
D.The rebalancing of the disk group would be completed without affecting the disk group DG3.
E.The command would result in an error because the disk groups cannot be manually rebalanced.

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

In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups，DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective： 
DROP DISKGROUP dgroup1 EXCLUDING CONTENTS； 
What would be the result of this command？（） 

A.This command would result in an error because the disk group is not empty.
B.The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.
C.The command would result in the disk group being marked as INVALID because it cannot be dropped.
D.The command would result in the contents being moved to the parent disk group and dropping of the disk group.
E.The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.

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

Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）： 
CREATE TABLESPACE user_tbsp 
DATAFILE ’+dgroup3（user_temp）/user_files/user_tbsp’ SIZE 200M； 
What would be the result of this command？（）

A.It would result in an error because the template cannot be used along with the disk group.
B.It would result in an error because the path cannot be specified while creating a tablespace in a disk group.
C.It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.
D.It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.

点击查看答案

最新试题

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？ （）

题型：多项选择题

One of the tablespaces is read­only in your database. The loss of all control files forced you to re­create the control file. Which operation do you need to perform after re­creating the control file and opening the database？（）

题型：单项选择题

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

题型：多项选择题

You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user­managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）

题型：单项选择题

You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）; Which two statements are true？ （）

题型：多项选择题

You performed an incomplete recovery on your Oracle Database 10g database using the following command： SQL> RECOVER DATABASE 2 UNTIL TIME ’2004­08­05：12：10：03’ 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be required？（）

题型：单项选择题

You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？ （）

题型：多项选择题

The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）

题型：单项选择题

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 are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

题型：单项选择题