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

题目

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

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()

参考答案：C

第2题：

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.

正确答案:A,B,D

第3题：

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?()

参考答案：B, D

第4题：

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.

正确答案:B,D

第5题：

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.

正确答案:A

第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.

参考答案：A, B, E

第7题：

Which of these appropriately describes the results of a manual SQL Tuning Advisor task？（）

A、 A list of SQL statements and recommendations for tuning
B、 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 changes
D、 All of the above

正确答案:A

第8题：

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_NO

B. ORDER_ID

C. STATUS

D. PROD_ID

E. ORD_TOTAL

F. Composite index on ORDER_ID and ORDER_DATE

参考答案：A, F

第9题：

Which of these appropriately describes the results of a manual SQL Tuning Advisor task?（）

A、A list of SQL statements and recommendations for tuning
B、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 changes
D、All of the above

正确答案:A

第10题：

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.

正确答案:A,B,E

Examine the SQL statements that

题目

相似问题和答案

更多相关问题

相关内容