ITPub博客

（256）Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily.To save disk space, you issued the following command:ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;What would be the outcome of this command?A. It pr...

（255）Which two statements about the SQL Management Base (SMB) are true? (Choose two.)A. It contains only SQL profiles generated by SQL Tuning Advisor.B. It stores plans generated by the optimizer using a stored outline.C. It is part of the data dictionary and stored in the SYSAUX tables...

（254）Which three statements correctly describe the features of the I/O calibration process? (Choose three.)  A. Only one I/O calibration process can run at a time.B. It automates the resource allocation for the Automated Maintenance Tasks.C. It improves the performa...

（253）You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline.The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile.Which statement is true when you accept the suggested SQL profile?A. The tuned ...

（252）Which three are the valid statements in relation to SQL plan baselines? (Choose three.)   A. The plans can be manually loaded to the SQL plan baseline.   B. The plans in the SQL plan baseline are verified and accepted plans.   C. The pla...

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

（250）You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation.The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system.How would you create these jobs?A...

（249）Evaluate the following command and its output:SQL>SELECT * FROM dba_temp_free_space;TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACELMTEMP                       &...

（248）（题目不完整）You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command:RMAN> CONFIGURE RETENTION POLICY TO RECOVFRY WINDOW OF 7 DAYS;After configuring the recovery window, you performed the ...

（247）Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)A. It bypasses the OS file system cache.B. A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.C. It uses the operating system kernel NFS layer for user task...

（246）The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE.The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline.Which two operations are performed by the optimizer in this scenario? (Choose two.)A. The optimizer adds the new p...

（245）Which statements are true regarding system-partitioned tables? (Choose all that apply.)A. Only a single partitioning key column can be specified.B. All DML statements must use partition-extended syntax.C. The same physical attributes must be specified for each partition.D. Uniq...

（244）Which two statements are true regarding the starting of the database instance using the following command? (Choose two.)SQL>STARTUP UPGRADEA. It enables all system triggers.B. It allows only SYSDBA connections.C. It ensures that all job queues remain active during the upgrade p...

（243）Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)A. failures because a data file is renamed by errorB. failures when no standby database is configuredC. failures that require no archive logs to be applied for recoveryD. ...

（242）You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository.Which condition must be met before you create the VPC?A. A base catalog existsB. The recovery catalog is empty...

（241）You issued the following RMAN command to back up the database:RMAN> RUN{  ALLOCATE CHANNEL c1 DEVICE TYPE sbt  BACKUP DATABASE  TAG quarterly  KEEP FOREVER...

（240）You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks.One of the disks in the disk group becomes unavailable because of power failure.You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:ALTER D...

（239）Evaluate the following command:SQL>ALTER SYSTEM SET db_securefile = 'IGNORE';What is the impact of this setting on the usage of SecureFiles?A. It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB.B. It forces SecureFiles to be created ...

（238）View the Exhibit to examine the output for the V$DIAG_INFO view.Which statements are true regarding the location of diagnostic traces?(Choose all that apply.)A. The path to the location of the background as well as the foreground process trace files is/u01/oracle/diag/rdbms/orclbi/orclb...

（237）You executed the following commands in an RMAN session for your database instance that has failures:RMAN>LIST FAILURE;After some time,you executed the following command in the same session:RMAN>ADVISE FAILURE;But there are new failures recorded in the Automatic Diagnostic Repos...