ITPub博客

（500）You opened the encryption wallet and then issued the following command:SQL>CREATE TABLESPACE securespaceDATAFILE'/home/user/oradata/secure01.dbf'SIZE 150MENCRYPTION USING '3DES168'DEFAULT STORAGE(ENCRYPT);T...

（499）Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository(ADR)?A. The incident metadata is purged when the problem is resolved and the DBA closes the SR.B. The incident files and dumps are not retained in the ADR for the...

（498）The database Is configured in ARCHIVELOG mode.The database needs to be up 24 X 7.You want to perform user managed backup for the data files of the HR_DATA tablespace.To accomplish the task,you issued the following command:SQL>ALTER TABLESPACE hi_data BEGIN BACKUP;Which two statemen...

（497）You are managing the APPPROD database as a DBA.You plan to duplicate this database in the same system with the name DUPDB.You issued the following RMAN commands to create a duplicate database:RMAN>CONNECT target sys/sys@APPPRODRMAN>DUPLICATE TARGET DAT...

（496）Which two statements are true regarding an Automatic Storage Management(ASM) instance?(Choose two.)A. An ASM instance mounts an ASM control fileB. An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC. Automatic Memory Management is enabled in an ASM i...

（495）Which statement is true regarding the VALIDATE DATABASE command?A. It checks the database for intrablock corruptions only.B. It checks for block corruption in the valid backups of the database.C. It checks the database for both intrablock and interblock corruptions.D. It checks...

（494）Which statement about Automatic Memory Management with Oracle 11g is true?A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or     PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.B. Oracle can reallocate ...

（493）Which three statements about performance analysis by SQL Performance Analyzer are true?(Choose three.)A. It detects changes in SQL execution plans.B. It produces results that can be used to create the SQL plan baseline.C. The importance of SQL statements is based on the size of the...

（492）You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database.As a part of the upgrade process,you execute the following script:SQL>@utlu111i.sqlWhich statement about the execution of this script is true?A. It must be executed from the Oracle Da...

（491）Examine the exhibit to view the parameters set in your parameter file.(Click the Exhibit(s)button.)You restart the instance.To what value will the MEMORY_MAX_TARGET parameter be set by default?A.120MB.320MC.480MD.600M答案：（D）解析：题目不完整...

（490）View the Exhibit.Examine the following command that is executed for the TRANSPORT table in the SH schema:SQL>SELECT DBMS_STATS.CREATE_EXTENDED_STATS('sh', 'customers_obe', '(country_id,cust_state_province)') FROM dual;Which statement describes the significance of this command?...

（489）For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?(Choose two.)A. viewsB. fixed tablesC. heap tablesD. external tablesE. temporary tablesF. index-organized tables(IOT)答案：（C、F）

（488）You are managing an Oracle Database 11g database with the ASM storage.The database is having big file tablespaces.You want files to open faster and less memory to be used in the shared pool to manage the extent maps.What configuration would you effect to achieve your objective?(Choose ...

（487）When executing a SQL workload,you choose to generate execution plans only,without collecting execution statistics.Which two statements describe the implications of this?(Choose two.)A. It produces less accurate results of the comparison analysis.B. It automatically calls the SQL Tu...

（486）You execute the following Recovery Manager(RMAN) commands in the following order:BACKUP VALIDATE DATABAERECOVER CORRUPTION LIST;Which two tasks are performed by these commands?(Choose two.)A. Repair the corrupted blocks.If any, In the backup created.B. Populate VSCOPV_CORRU...

（485）You want to back up your 100-GB database on a remote tape device.You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device.The current consumption of your CPU is approximately 40 percent.Which type of backup should you p...

（484）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...

（483）Evaluate the following block of code:BEGIN  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL( acl => 'mycompany-com-permissions.xml',                  &nbs...

（482）USER_DATA is a nonencrypted tablespace that contains a set of tables with data.You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format.Which methods would you use to achieve this?(Choose all that apply.)A. Use Data Pump to transf...

（481）Which statement is true about a running session that belongs to the online transaction processing(OLTP) group?A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.B. It performs the first 10000 I/O requests or ...