-
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))
-
You execute the following PL/SQL:Which two statements are true?（）
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.
-
Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）
A . ADDM
B . AWR
C . Cursor Cache
D . SQL Tuning Sets
E . Flash Recovery Area
-
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）
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.
-
Which two statements regarding a SQL profile are true?（）
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.
-
Which two statements best describe the wireless security standard that is defined by WPA (Choose two.)（）。
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
-
Which SQL statement returns a numeric value?（）
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
-
Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）
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))
-
Which two statements are true about Shared SQL Area and Private SQL Areas（）
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.
-
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
-
Which three statements are true about adaptive SQL plan management?（）
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.
-
Which two statements regarding a SQL profile are true？（）
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.
-
Which three statements describe how the strict SQL mode provides added security?（）
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
-
Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g？（）
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）.
-
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 four statements correctly describe functions that are available in SQL? （）
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.
-
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 two statements are true regarding a PL/SQL package body？（）
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.
-
Which two statements about the SQL Management Base (SMB) are true?（）
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.
-
Which two statements are true about Shared SQL Area and Private SQL Area（）
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.
-
Which statement below correctly defines topic sentences?
-
Which of the following statements accurately defines work specialization? ( )
-
In the following options, which languages can be embossed SQL statements （）
A．Java
B．C
C．PHP
D．Python
