Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）A、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);B、CREAT

题目

Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）

  • A、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);
  • B、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
  • C、CREATE TABLE EMP (empno NUMBER(4) ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));
  • D、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));
相似考题

1.Which of the following statements about ORACLE is (are) correct?Ⅰ.ORACLE follows SQL standardⅡ.ORACLE database defines two logical types: table and viewA．ⅠonlyB．Ⅱ onlyC．Ⅰ and ⅡD．none of the above

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

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

更多“Which SQL statement defines the ”相关问题

  • 第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题：

    Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?()

    A. Bind Variable Peeking

    B. SQL Plan Baselines

    C. Adaptive Cursor Sharing

    D. Bind variable used in a SQL statement

    E. Literals in a SQL statement


    参考答案：A, C, E

  • 第3题：

    Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?（）

    • A、Bind Variable Peeking
    • B、SQL Plan Baselines
    • C、Adaptive Cursor Sharing
    • D、Bind variable used in a SQL statement
    • E、Literals in a SQL statement

    正确答案:A,C,E

  • 第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 of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）

    • A、SQL Repair Advisor
    • B、SQL Optimizer
    • C、SQL Access Advisor
    • D、SQL Tuning Advisor

    正确答案: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题：

    单选题
    Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?（）
    A

    The SGA Tuning Advisor

    B

    The SQL Access Advisor

    C

    The SQL Tuning Advisor

    D

    The Memory Advisor


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

  • 第8题：

    单选题
    Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）
    A

     The SGA Tuning Advisor

    B

     The SQL Access Advisor

    C

     The SQL Tuning Advisor

    D

     The Memory Advisor


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

  • 第9题：

    单选题
    Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）
    A

    SQL Repair Advisor

    B

    SQL Optimizer

    C

    SQL Access Advisor

    D

    SQL Tuning Advisor SQL


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

  • 第10题：

    单选题
    Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement？（）
    A

     SQL Repair Advisor

    B

     SQL Optimizer

    C

     SQL Access Advisor

    D

     SQL Tuning Advisor


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

  • 第11题：

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


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

  • 第12题：

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

  • 第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题：

    Which of the following will begin a new unit of work?（）

    • A、The CONNECT statement
    • B、The first FETCH of a cursor
    • C、The BEGIN TRANSACTION statement
    • D、The first executable SQL statement

    正确答案:D

  • 第16题：

    Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）  

    • A、 The SGA Tuning Advisor
    • B、 The SQL Access Advisor
    • C、 The SQL Tuning Advisor
    • D、 The Memory Advisor

    正确答案:C

  • 第17题：

    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

  • 第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题：

    单选题
    The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）
    A

    Alice only

    B

    Alice and Reena

    C

    Alice, Reena, and Timber

    D

    Sue, Alice, Reena, and Timber


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

  • 第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题：

    多选题
    Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?（）
    A

    Bind Variable Peeking

    B

    SQL Plan Baselines

    C

    Adaptive Cursor Sharing

    D

    Bind variable used in a SQL statement

    E

    Literals in a SQL statement


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

  • 第22题：

    多选题
    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,C
    解析： 暂无解析

  • 第23题：

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

  • 第24题：

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

相关内容