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

A . Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed. B . FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed. C . FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column. D . FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

A . ADDM B . AWR C . Cursor Cache D . SQL Tuning Sets E . Flash Recovery Area

A . You cannot roll back this statement. B . All pending transactions are committed. C . All views based on the DEPT table are deleted. D . All indexes based on the DEPT table are dropped. E . All data in the table is deleted, and the table structure is also deleted. F . All data in the table is deleted, but the structure of the table is retained. G . All synonyms based on the DEPT table are deleted.

A . It is built by Automatic Tuning Optimizer. B . It cannot be stored persistently in the data dictionary. C . It can be used by the query optimizer automatically. D . It can be created manually by using the CREATE PROFILE command.

A . It specifies use of a static encryption key that must be changed frequently to enhance security B . It requires use of an open authentication method C . It specifies the use of dynamic encryption keys that change each time a client establishes a connection D . It requires that all access points and wireless devices use the same encryption key E . It includes authentication by PSK

A . SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP; B . SELECT ROUND(hire_date) FROM EMP; C . SELECT sysdate-hire_date FROM EMP; D . SELECT TO_NUMBER(hire_date + 7) FROM EMP

A . CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(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 VARCHAR2(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 VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp_deptno_fk REFERENCES dept (deptno))

A . Shared SQL Area will be allocated in the shared pool. B . Shared SQL Area will be allocated when a session starts. C . Shared SQL Area will be allocated in the large pool always. D . The whole of Private SQL Area will be allocated in the Program Global Area （PGA） always. E . Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool. F . The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.

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 . It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans. B . The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline. C . It adds new, bettor plans automatically as fixed plans to the baseline. D . The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans. E . The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.

A .  It is built by Automatic Tuning Optimizer. B .  It cannot be stored persistently in the data dictionary. C .  It can be used by the query optimizer automatically. D .  It can be created manually by using the CREATE PROFILE command.

A . It rejects statements that try to insert out-of-range values B . It rejects invalid dates C . It limits the operations that the server can perform D . It rejects queries that produce out-of-range values E . It rejects dates with zero day or month value

A .  It does not allow you to change the moving window size. B .  Adaptive threshold functionalities use it by default to compute statistics. C .  It is created by default with the window size being equal to the AWR retention time. D .  It is created when the first snapshot is collected by the Automatic Workload Repository （AWR）.

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.

A . INSTR returns the numeric position of a named character. B . NVL2 returns the first non-null expression in the expression list. C . TRUNCATE rounds the column, expression, or value to n decimal places. D . DECODE translates an expression after comparing it to each search value. E . TRIM trims the heading or trailing characters (or both) from a character string. F . NVL compares two expressions and returns null if they are equal, or the first expression if they are not equal. G . NULLIF compares two expressions and returns null if they are equal, or the first expression if they are not equal.

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.

A .https://assets.asklib.com/images/image2/2018080115165365786.jpg B .https://assets.asklib.com/images/image2/2018080115165818527.jpg C .https://assets.asklib.com/images/image2/2018080115170192388.jpg D .https://assets.asklib.com/images/image2/2018080115170459610.jpg

A . It cannot be created without a package specification. B . It cannot invoke subprograms defined in other packages. C . It can contain only the subprograms defined in the package specification. D . It can be changed and recompiled without making the package specification invalid.

A . It contains only SQL profiles generated by SQL Tuning Advisor. B . It stores plans generated by the optimizer using a stored outline. C . It is part of the data dictionary and stored in the SYSAUX tablespace. D . It is part of the data dictionary and stored in the SYSTEM tablespace. E . It contains the statement log, the plan history, plan baselines, and SQL profiles.

A . Shared SQL Area will be allocated in the shared pool. B . Shared SQL Area will be allocated when a session starts. C . Shared SQL Area will be allocated in the large pool always. D . Private SQL Area will be allocated in the Program Global Area （PGA） always. E . Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool. F . The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.

A．Java B．C C．PHP D．Python