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));

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));

相关考题:

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

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.

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.

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

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.

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 PeekingB. SQL Plan BaselinesC. Adaptive Cursor SharingD. Bind variable used in a SQL statementE. Literals in a SQL statement

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.

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 PeekingB、SQL Plan BaselinesC、Adaptive Cursor SharingD、Bind variable used in a SQL statementE、Literals in a SQL statement

Which of the following will begin a new unit of work?()A、The CONNECT statementB、The first FETCH of a cursorC、The BEGIN TRANSACTION statementD、The first executable SQL statement

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.

Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()  A、 The SGA Tuning AdvisorB、 The SQL Access AdvisorC、 The SQL Tuning AdvisorD、 The Memory Advisor

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 AdvisorB、SQL OptimizerC、SQL Access AdvisorD、SQL Tuning Advisor

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

Which of the following cannot be used as input to the SQL Tuning Advisor?()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

单选题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()AIt contains only the plan for the SQL statement executed by the user.BIt contains the SQL text executed by the user and the bind variables used with it.CIt contains the plan and statistics associated with the SQL statement executed by the user.DIt contains the plan for the SQL statement executed by the user and the bind variables used with it.

单选题Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()AThe SGA Tuning AdvisorBThe SQL Access AdvisorCThe SQL Tuning AdvisorDThe Memory Advisor

单选题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?()AAlice onlyBAlice and ReenaCAlice, Reena, and TimberDSue, Alice, Reena, and Timber

单选题Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()A The SGA Tuning AdvisorB The SQL Access AdvisorC The SQL Tuning AdvisorD The Memory Advisor

单选题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()AIt contains only the plan for the SQL statement executed by the user.BIt contains the SQL text executed by the user and the bind variables used with it.CIt contains the plan and statistics associated with the SQL statement executed by the user.DIt contains the plan for the SQL statement executed by the user and the bind variables used with it

单选题Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?()ASQL Repair AdvisorBSQL OptimizerCSQL Access AdvisorDSQL Tuning Advisor SQL

多选题Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?()ABind Variable PeekingBSQL Plan BaselinesCAdaptive Cursor SharingDBind variable used in a SQL statementELiterals in a SQL statement

单选题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 AdvisorB SQL OptimizerC SQL Access AdvisorD SQL Tuning Advisor

多选题Which two statements are true regarding the SQL Repair Advisor?()AThe SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.BThe SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.CThe SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.DThe 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.

单选题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?()AThe tuned plan is not added to the SQL plan baseline.BThe tuned plan is added to the fixed SQL plan baseline as a fixed plan.CThe tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.DThe tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

单选题You issue this statement:ALTER DATABASE BACKUP CONTROLFILE TO TRACE;  What does the statement generate?()AA text copy of the control file.BA binary copy of the control file.CA file containing a SQL statement which will re-create the database.DA file containing a SQL statement which will re-create the control file.

多选题Which of the following cannot be used as input to the SQL Tuning Advisor?() (Choose all that apply.)AA single SQL statement provided by a userBAn existing SQL Tuning Set (STS)CA preprocessed Database Replay workloadDA schema nameESQL statement identified in EM as using excessive resources

多选题Which of the following cannot be used as input to the SQL Tuning Advisor?()AA single SQL statement provided by a userBAn existing SQL Tuning Set (STS)CA preprocessed Database Replay workloadDA schema nameESQL statement identified in EM as using excessive resources