Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(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 above SQL statement? （）..

第1题

[单选题] 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 plan is not added to the SQL plan baseline. B、The tuned plan is added to the fixed SQL plan baseline as a fixed plan. C、The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan. D、The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

点击查看答案

第2题

[单选题] 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 plan is not added to the SQL plan baseline. B、The tuned plan is added to the fixed SQL plan baseline as a fixed plan. C、The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan. D、The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

点击查看答案

第3题

[单选题] View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?（）

A、Accept the recommended SQL profile. B、Collect statistics for the related objects. C、Run the Access Advisor for the SQL statement. D、Run the Segment Advisor for recommendations.

点击查看答案

第4题

[单选题] 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 plan is not added to the SQL plan baseline. B、 The tuned plan is added to the fixed SQL plan baseline as a fixed plan. C、 The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan. D、 The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

点击查看答案

第5题

[] The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan evolution task manually. Examine the following steps: 1. Set the evolve task parameters. 2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function. 3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function. 4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function. 5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps:（） The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan evolution task manually. Examine the following steps: 1. Set the evolve task para

A、A.2，4，5 B、B.2，1，4，3，5 C、C.1，2，3，4，5 D、D.1，2，4，5

点击查看答案

第6题

[多选题] 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.

点击查看答案

第7题

[] Examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: What is the result when the query is executed?（） Examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: What is the result when the query is executed?（）

A、A.
B.
C.
D. The query fails because the subquery returns more than one row.
E. The query fails because the outer query and the inner query are using different tables.

点击查看答案

第8题

[] Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Smith'); What is the result when the query is executed?（） Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Smith'); What is the result when the query is executed?（）

A、A.A B、B.B C、C.C D、D.D E、E.E

点击查看答案

第9题

[] Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（） Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（）

A、A. The shrink operation touches every block in the BOOKING table B、B. The high-water mark (HWM) for the BOOKING table is shifted from its original position C、C. The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table D、D. The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation

点击查看答案

第10题

[单选题] View the Exhibit exhibit1 to examine the series of SQL commands. View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS. Which statement is true if the SQL query in exhibit1 is executed again when the valueof OPTIMIZER_MODE is set to FIRST_ROWS?（）

A、The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans. B、The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan. C、The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan. D、The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.

点击查看答案

请使用微信扫码支付