单选题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？（）
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.

相似考题

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

2.Evaluate this SQL statement:In the statement, which capabilities of a SELECT statement are performed?()A. Selection, projection, joinB. Difference, projection, joinC. Selection, intersection, joinD. Intersection, projection, joinE. Difference, projection, product

3.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_NOB. ORDER_IDC. STATUSD. PROD_IDE. ORD_TOTALF. composite index on ORDER_ID and ORDER_DATE

4.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 userB. An existing SQL Tuning Set (STS)C. A preprocessed Database Replay workloadD. A schema nameE. SQL statement identified in EM as using excessive resources

更多“Evaluate the following SQL statement used to create the PROD”相关问题

  • 第1题：

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

    A. 0

    B. 1

    C. 0.00

    D. An error statement


    参考答案：A

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）

    • A、It releases the storage space used by the table.
    • B、It does not release the storage space used by the table.
    • C、You can roll back the deletion of rows after the statement executes.
    • D、You can NOT roll back the deletion of rows after the statement executes.
    • E、An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
    • F、You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

    正确答案:A,D,F

  • 第5题：

    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

  • 第6题：

    Which of the following cannot be used as input to the SQL Tuning Advisor？（）

    • 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

  • 第7题：

    单选题
    You issued the following statement：  SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  What will be the result of issuing the statement？（）
    A

     The control file will be multiplexed.

    B

     The control file will be recreated.

    C

    The script containing the CREATE CONTROLFILE statement will be created.

    D

     The binary backup of the control file will be created.


    正确答案： A
    解析： 暂无解析

  • 第8题：

    多选题
    Evaluate the SQL statement: TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）
    A

    It releases the storage space used by the table.

    B

    It does not release the storage space used by the table.

    C

    You can roll back the deletion of rows after the statement executes.

    D

    You can NOT roll back the deletion of rows after the statement executes.

    E

    An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.

    F

    You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table.


    正确答案： A,D,F
    解析： 暂无解析

  • 第9题：

    单选题
    Evaluate the following command：   SQL> CREATE TABLE design_data （id NUMBER， doc CLOB）  LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）；   Which statement is true regarding the above command？（）
    A

     The LOB values are automatically compressed.

    B

     The LOB values are cached by default in the buffer cache.

    C

     The LOB values are automatically stored in encrypted mode.

    D

     All LOB data that is identical in two or more rows in a LOB column share the same data blocks.


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    A new employee needs access to a SQL Server 2005 database that is located on a server named SQL1. You create a login named ajones by using the following Transact-SQL statement. CREATE LOGIN ajones WITH PASSWORD = ’SQLServer$1’ The new employee reports that when he logs in， he receives the following error message： "Login failed. The user is not associated with a trusted SQL Server connection." You need to resolve the error and allow the new employee to gain access to SQL1. What should you do？（）
    A

    Change the SQL Server security mode from Windows Authentication mode to SQL Server and Windows authentication mode.

    B

    Change the SQL Server security mode from SQL Server and Windows Authentication mode to Windows authentication mode.

    C

    Ensure that the login name is created with square brackets （[]）.

    D

    Give the login access to a specific database by using the CREATE USER Transact-SQL statement.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    You created the ORDERS table in your database by using the following code：   SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）；   Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）；   SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）；   SQL> COMMIT；   Next， you issued the following statement to change the time zone for the database：   SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’；   What will be the result of executing the above statement？（）
    A

     The statement will fail.

    B

     The statement will be executed successfully， and the new time zone will be set for the database.

    C

     The statement will be executed successfully， but the new time zone will be set for the current session.

    D

    The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.


    正确答案： A
    解析： 暂无解析

  • 第12题：

    多选题
    Which of the following cannot be used as input to the SQL Tuning Advisor？（）
    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


    正确答案： E,B
    解析： 暂无解析

  • 第13题：

    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.


    参考答案：C

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    You issued the following statement：  SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  What will be the result of issuing the statement？（）  

    • A、 The control file will be multiplexed.
    • B、 The control file will be recreated.
    • C、The script containing the CREATE CONTROLFILE statement will be created.
    • D、 The binary backup of the control file will be created.

    正确答案:C

  • 第17题：

    Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?（）

    • A、0
    • B、1
    • C、0.00
    • D、An error statement

    正确答案:A

  • 第18题：

    单选题
    To make audit information more productive， the DBA executes the following command before startingan audit operation：  SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE；  Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）
    A

    It contains only the plan for the SQL statement executed by the user.

    B

    It contains the SQL text executed by the user and the bind variables used with it.

    C

    It contains the plan and statistics associated with the SQL statement executed by the user.

    D

    It contains the plan for the SQL statement executed by the user and the bind variables used with it.


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables.  Evaluate the following SQL statement：   SELECT oi.order_id， product_jd， order_date   FROM order_items oi JOIN orders o   USING （order_id）；   Which statement is true regarding the execution of this SQL statement？（）
    A

     The statement would not execute because table aliases are not allowed in the JOIN clause.

    B

     The statement would not execute because the table alias prefix is not used in the USING clause.

    C

     The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.

    D

     The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    To make audit information more productive， the DBA executes the following command before starting an auditoperation： SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting Thedatabase（）
    A

    It contains only the plan for the SQL statement executed by the user.

    B

    It contains the SQL text executed by the user and the bind variables used with it.

    C

    It contains the plan and statistics associated with the SQL statement executed by the user.

    D

    It contains the plan for the SQL statement executed by the user and the bind variables used with it


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    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
    解析： 暂无解析

  • 第22题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第23题：

    多选题
    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


    正确答案： B,E
    解析： 暂无解析

相关内容