单选题Evaluate the following SQL statement used to create the PRODUCTS table： CREATE TABLE products （product_id NUMBER（3） PRIMARY KEY， product_desc VARCHAR2（25）， qtyNUMBER（8，2）， rate NUMBER（10，2）， total_value AS （ qty * rate）） PARTITION BY RANGE （total_val

题目

单选题

Evaluate the following SQL statement used to create the PRODUCTS table： CREATE TABLE products （product_id NUMBER（3） PRIMARY KEY， product_desc VARCHAR2（25）， qtyNUMBER（8，2）， rate NUMBER（10，2）， total_value AS （ qty * rate）） PARTITION BY RANGE （total_value）（PARTITION p1 VALUES LESS THAN （100000）， PARTITION p2 VALUES LESS THAN （150000）， PARTITION p3 VALUES LESS THAN （MAXVALUE）） COMPRESS FOR ALL OPERATIONS； Which statement is true regarding this command？（）

It executes successfully but partition pruning cannot happen for this partition key.

It produces an error because the TOTAL_VALUE column cannot be used as a partition key.

It produces an error because compression cannot be used for the TOTAL_VALUE partition key.

It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

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

相似问题和答案

第1题：

Evaluate this SQL statement:In the statement, which capabilities of a SELECT statement are performed?()

A. Selection, projection, join

B. Difference, projection, join

C. Selection, intersection, join

D. Intersection, projection, join

E. Difference, projection, product

参考答案：A

第2题：

Evaluate the SQL statement:What will be displayed?()

A. 0

B. 1

C. 0.00

D. An error statement

参考答案：A

第3题：

Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?()

A. It executes successfully but partition pruning cannot happen for this partition key.

B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.

C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.

D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

参考答案：D

第4题：

Given the following function: CREATE FUNCTION emplist （　） RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END How can this function be used in an SQL statement?

A、SELECT TABLE(EMPLIST()) FROM EMPLOYEE
B、SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE
C、SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE
D、SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t

正确答案:D

第5题：

Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?（）

A、The DESCRIBE DEPT statement displays the structure of the DEPT table.
B、The ROLLBACK statement frees the storage space occupied by the DEPT table.
C、The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D、The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.

正确答案:A

第6题：

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? （）

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

第7题：

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

参考答案：C

第8题：

Which of the following cannot be used as input to the SQL Tuning Advisor?() (Choose all that apply.)

A. A single SQL statement provided by a user

B. An existing SQL Tuning Set (STS)

C. A preprocessed Database Replay workload

D. A schema name

E. SQL statement identified in EM as using excessive resources

参考答案：C, D

第9题：

You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）

A、A text copy of the control file.
B、A binary copy of the control file.
C、A file containing a SQL statement which will re-create the database.
D、A file containing a SQL statement which will re-create the control file.

正确答案:D

第10题：

Evaluate the CREATE TABLE statement： CREATE TABLE products （product_id NUMBER （6） CONSTRAINT prod_id_pk PRIMARY KEY， product_name VARCHAR2 （15））； Which statement is true regarding the PROD_ID_PK constraint？（）

A、 It would be created only if a unique index is manually created first.
B、 It would be created and would use an automatically created unique index.
C、 It would be created and would use an automatically created nonunique index.
D、 It would be created and remains in a disabled state because no index is specified in the command.

正确答案:B

Evaluate the following SQL statement used to create the PROD

题目

相似问题和答案

更多相关问题

相关内容