ITPub博客

（37）During the installation of Oracle Database 11g,you do not set ORACLE_BASE explicitly.You selected the option to create a database as part of the installation.How would this environment variable setting affect the installation?A. The installation terminates with an error.B. The i...

（36）Which two statements are true regarding the functionality of the remap command in ASMCMD?(Choose two.)A. It repairs blocks that have read disk I/O errors.B. It checks whether the alias metadata directory and the file directory are linked correctly.C. It repairs blocks by always read...

（35）You want the Automatic SQL Tuning process to stop accepting and implementing the recommended SQL profiles automatically.Which action would you perform to achieve this?A. Edit the automatic maintenance window group configuration.B. Set the CURSOR_SHARING parameter to EXACT for the da...

（34）Examine the following RMAN command:BACKUP DATABASETAG TESTDBKEEP UNTIL 'SYSDATE+1'RESTORE POINT TESTDB06;Which two statements are true regarding the backup taken by using the above RMAN command?(Choose two.)A. Only data files and the control file are backed up.B. Arc...

（33）You want to perform the following operations for the DATA ASM disk group:-Verify the consistency of the disk.-Cross-check all the file extent maps and allocation tables for consistency. check whether the alias metadata directory and file directory are linked correctly.-Check that AS...

（32）In your production database,you:-Are using Recovery Manager(RMAN) with a recovery catalog to perform the backup operation at regular intervals-Set the control file autobackup to on-Are maintaining image copies of the database files-You have lost the server parameter tile(SPFILE)...

（31）Which two statements are correct about database transportation?(Choose two.)A. The source and target platforms must be the sameB. Redo logs,control files and temp files are also transportedC. The transported database must have the same database identifier(DBID) as the source databas...

（30）Which two statements are true with respect to the maintenance window?(Choose two)A. A DBA can enable or disable an individual task in all maintenance windows.B. A DBA cannot change the duration of the maintenance window after it is created.C. In case of a long maintenance window,all...

（29）Which two statements are true regarding the Automatic Diagnostic Repository(ADR) in Oracle Database 11g?(Choose two.)A. A single ADR can support multiple ADR homes for different database instances.B. The alert files are stored in XML file format in the TRACE directory of each ADR home....

（28）You have a range-partitioned table in your database.Each partition in the table contains the sales data for a quarter.The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations.The preferences for the table are set to their ...

（27）You are using the flash recovery area(fast recovery area in 11g Release 2) to store backup related files in your database.After regular monitoring of space usage in the Mash recovery area.You realize that the flash recovery area is(jetting filled up very fast and it is running out of space....

（26）You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11.The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and ...

（25）You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（choose threee.)A. Drop the table.B. Partition the tableC. Truncate the table.D. Add a column to the table.E. Rename a column in...

（24）Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems?(Choose all that apply.)A. ADR diagnostic filesB. all the optimizer statisticsC. initialization parameter settingsD. PL/SQL functions,procedures,a...

（23）Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?A. only encryption and compression settings for all SecureFile LOBsB. only encryption and deduplication settings for only SecureFile CLOBsC. deduplication,encryption,and compression settings for all SecureFile L...

（22）An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:SQL>CREATE INDEX ord_custname_ix ON orders(custname);The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause.You want to check the imp...

（21）You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose.What are the prerequisites for performing the active database duplication?(Choose all that apply)A. The source database backup must be copied over the net for test database.B...

（20）View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based on the output?(Choose two.)Exhibit:A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an errorB...