ITPub博客

333.Which command would you use to determine what database backups are currently available for restore?A. list database backup;B. report database backup;C. list backup of database;D. list summary backup;E. report backup of database;Answer: CC:\Users\dell>rman target /...

284.Evaluate the following SQL statement used to create the PRODUCTS table:CREATE TABLE products (    product_id NUMBER(3) PRIMARY KEY,    product_desc VARCHAR2(25),    qty  NUMBER(8,2),    rate NUMBER(10,2),&...

266.View the Exhibit to examine the parameters set for your database instance. You execute the following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command:SQL> EXECUTE dbms_resource_manager.calibrate_io( num_physical_disks=>1, -&...

265.View the Exhibit for the object interdependency diagram.The PRODUCTS table is used to create the TPMRODCAT_VW view. PRODCAT_VW is used in the GET_DATA procedure. GET_DATA is called in the CHECK_DATA function.A new column PROD_QTY is added to the PRODUCTS table. How does this impact the status...

257.Which client requests to the database can be captured as a part of the workload capture?(Choose all that apply.)A. flashback queryB. distributed transactionsC. logging in and logging out of sessionsD. all DDL statements having bind variablesE. direct path load of data from external filesAn...

 185.A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger, which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?A. backup database allB. ...

183.Which of the following RMAN structures can data from a datafile span?A. RMAN backup-set pieces spanning backup setsB. RMAN backup-set pieces within a given backup setC. RMAN backupsD. RMAN channelsE. None of the aboveAnswer: B数据文件可以跨跃RMAN备份集的备份片。

181.Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generated since the previous Monday, but you have archived redo logs available from the previous Sunday and earlier. You now n...

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, and packages...

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 LOBsD. d...

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 impact on the ...

19.A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?A. It remains valid.B. It becomes invalid for all options of online table redefinition but automatica...

 18.You create a new Automatic Database Diagnostic Monitor (ADDM) task:instance_analysis_mode_task. To view the ADDM report, you use the following command:SQL> SELECT dbms_addm.get_report('my_instance_analysis_mode_task') FROM dual;You want to suppress ADDM output relating to Seg...

14.Which two statements are true regarding hot patching? (Choose two.)A. It requires relinking of the Oracle binary.B. It does not require database instance shutdown.C. It can detect conflicts between two online patches.D. It is available for installing all patches on all platforms.E. It works ...

11.View the Exhibit to examine the metrics with a threshold. Which statement is true regarding the Number of Transactions (per second) metric?A. Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.B. The statistics for the metric values obser...

9.Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?A. It returns space usage of only BasicFile LOB chunks.B. It returns space usage of only SecureFile LOB chunks.C. It returns both BasicFile and SecureFile LOB space usage for only nonp...

7.You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.Which statement is true regarding the ACL created?A. It is a list of remote database links stored in the XML...

6.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 1423242, ...

5.Examine the section of the Health Check report given below:DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')Run Name : HM_RUN_1061Run Id : 1061Check Name : Data Block Integrity CheckMode :REACTIVEStatus : COMPLETEDStart Time : 2007-05-12 22:11:02.032292 -07:00End Time : 2007-05-12 22:11:20.835135 -07:...

2.You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold.Which statement factors in this consideration while increasing the size of the moving window.?A. The collection level for the AWR should be set to BAS...