Examine the SQL statements that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL STATUS VARCHARD2(10) CHECK (status IN ('CREDIT','CASH')), PROD_ID_NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order id, order date)); For which columns would an index be automatically created when you execute the aboveSQL statement? （）A、SER_NOB、ORDER_IDC、STATUSD、PROD_IDE、ORD_TOTALF、Composite index on ORDER_ID and ORDER_DATE
Examine the SQL statements that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL STATUS VARCHARD2(10) CHECK (status IN ('CREDIT','CASH')), PROD_ID_NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order id, order date)); For which columns would an index be automatically created when you execute the aboveSQL statement? （）
- A、SER_NO
- B、ORDER_ID
- C、STATUS
- D、PROD_ID
- E、ORD_TOTAL
- F、Composite index on ORDER_ID and ORDER_DATE
相关考题：
Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?() A.B.C.D.
Examine the SQL statements that creates ORDERS table:For which columns would an index be automatically created when you execute the above SQL statement? () A. SER_NOB. ORDER_IDC. STATUSD. PROD_IDE. ORD_TOTALF. Composite index on ORDER_ID and ORDER_DATE
Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?() A.B.C.D.
Examine the contents of SQL loader control file:Which three statements are true regarding the SQL* Loader operation performed using the control file?() A. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.B. The SQL* Loader data file myfile1.dat has the column names for the EMP table.C. The SQL* Loader operation fails because no record terminators are specified.D. Field names should be the first line in the both the SQL* Loader data files.E. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.
Which three statements about performance analysis by SQL Performance Analyzer are true? （）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 objects accessed.D、It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.E、It shows only the overall impact on workload and not the net SQL impact on workload.
Which of these appropriately describes the results of a manual SQL Tuning Advisor task？（） A、 A list of SQL statements and recommendations for tuningB、 A list of SQL statements that have been tuned by the Advisor，with before and after metrics C、 Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changesD、 All of the above
Which statement correctly describes SQL and /SQL*Plus?（）A、Both SQL and /SQL*plus allow manipulation of values in the database.B、/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.C、/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.D、/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.
Which of these appropriately describes the results of a manual SQL Tuning Advisor task?（）A、A list of SQL statements and recommendations for tuningB、A list of SQL statements that have been tuned by the Advisor, with before and after metricsC、Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changesD、All of the above
Which two statements are true regarding the SQL Repair Advisor？（） A、 The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.B、 The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.C、 The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.D、 The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.
Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file?（）A、An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.B、The SQL* Loader data file myfile1.dat has the column names for the EMP table.C、The SQL* Loader operation fails because no record terminators are specified.D、Field names should be the first line in the both the SQL* Loader data files.E、The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.
You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting？（） A、 The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.B、 The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.C、 The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.D、 The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.
What happens when you run the SQL Tuning Advisor with limited scope？（） A、 Access path analysis is not performed for SQL statements.B、 SQL structure analysis is not performed for SQL statements.C、 SQL Profile recommendations are not generated for SQL statements.D、 Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）A、 SQL statements that are part of the AWR baseline onlyB、 SQL statements based on the AWR top SQL identificationC、 SQL statements that are part of the available SQL Tuning Set （STS） onlyD、 SQL statements that are available in the cursor cache and executed by a user other than SYS
What happens when you run the SQL Tuning Advisor with limited scope?（）A、Access pathanalysis is not performed for SQL statements.B、SQL structure analysis is not performed for SQL statements.C、SQL Profile recommendations are not generated for SQL statements.D、Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.
Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（） A、ADDMB、AWRC、Cursor CacheD、SQL Tuning SetsE、Flash Recovery Area
Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）A、The constraint remains valid.B、The index on the constraint is dropped.C、It allows the loading of data into the table using SQL*Loader.D、New data conforms to the constraint， but existing data is not checkedE、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
单选题Which statement is true when you run the SQL Tuning Advisor with limited scope？（）AAccess path analysis is not performed for the SQL statements.BSQL structure analysis is not performed for the SQL statements.CSQL Profile recommendations are not generated for the SQL statements.DThe staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.
多选题Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）AThe constraint remains valid.BThe index on the constraint is dropped.CIt allows the loading of data into the table using SQL *Loader.DNew data conforms to the constraint， but existing data is not checked.EIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
单选题Which of these appropriately describes the results of a manual SQL Tuning Advisor task?（）AA list of SQL statements and recommendations for tuningBA list of SQL statements that have been tuned by the Advisor, with before and after metricsCGraphs showing the actual performance improvement made by the Advisor after it implemented the recommended changesDAll of the above
多选题Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）AThe constraint remains valid.BThe index on the constraint is dropped.CIt allows the loading of data into the table using SQL*Loader.DNew data conforms to the constraint， but existing data is not checkedEIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
多选题Examine the commands executed to monitor database operations: $ conn sys oracle/oracle@prod as sysdba SQL VAR eid NUMBER SQL EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING = ‘Y’); Which two statements are true?（）ADatabase operations will be monitored only when they consume a significant amount of resource.BDatabase operations for all sessions will be monitored.CDatabase operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.DOnly DML and DDL statements will be monitored for the session.EAll subsequent statements in the session will be treated as one database operation and will be monitored.
单选题Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）ASQL statements that are part of the AWR baseline only BSQL statements based on the AWR top SQL identificationCSQL statements that are part of the available SQL Tuning Set (STS) only DSQL statements that are available in the cursor cache and executed by a user other than SYS
单选题Which statement correctly describes SQL and /SQL*Plus?（）ABoth SQL and /SQL*plus allow manipulation of values in the database.B/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.C/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.D/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.
单选题What happens when you run the SQL Tuning Advisor with limited scope？（）A Access path analysis is not performed for SQL statements.B SQL structure analysis is not performed for SQL statements.C SQL Profile recommendations are not generated for SQL statements.D Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.
单选题Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）A SQL statements that are part of the AWR baseline onlyB SQL statements based on the AWR top SQL identificationC SQL statements that are part of the available SQL Tuning Set （STS） onlyD SQL statements that are available in the cursor cache and executed by a user other than SYS
多选题What happens when you run the SQL Tuning Advisor with limited scope?（）AAccess pathanalysis is not performed for SQL statements.BSQL structure analysis is not performed for SQL statements.CSQL Profile recommendations are not generated for SQL statements.DStaleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.
单选题You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting？（）A The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.B The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.C The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.D The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.
多选题Examine the SQL statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFComposite index on ORDER_ID and ORDER_DATE