The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan？（）

A . SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id); B . SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id); C . SELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id); D . SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id); E . SELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id); F . SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY))

A . Because row IDs may change during the flashback operation B . Because the object number changes after the flashback operation C . Because the rows are retrieved from the recycle bin during the flashback operation D . Because the table is moved forward and back to a temporary during the flashback opertio

A . INSERT INTO employees VALUES ( NULL, 'John', 'Smith'); B . INSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith'); C . INSERT INTO employees VALUES ( '1000', 'John', NULL); D . INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith'); E . INSERT INTO employees (employee_id) VALUES (1000); F . INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ')

A . The EMPLOYEES table will be changed to read-only mode during the shrink operation. B . The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over. C . The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation. D . Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

A . SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id); B . SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id); C . SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id); D . SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id); E . SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id); F . SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY))

A . It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database. B . It fails because no SQL *Loader data file location is specified. C . It fails if the HR user does not have the CREATE ANY DIRECTORY privilege. D . It fails because no SQL *Loader control file location is specified.

A .https://assets.asklib.com/images/image2/2018080115372627375.jpg B .https://assets.asklib.com/images/image2/2018080115372921481.jpg C .https://assets.asklib.com/images/image2/2018080115373261310.jpg D .https://assets.asklib.com/images/image2/2018080115373612285.jpg

A . SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE > 5; B . SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE > 5; C . SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)/365 > 5; D . SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)* 365 > 5

A . INSERT INTO employees VALUES (NULL, 'JOHN','Smith'); B . INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith'); C . INSERT INTO employees VALUES ('1000','JOHN','NULL'); D . INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith'); E . INSERT INTO employees (employee_id) VALUES (1000); F . INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',")

A .https://assets.asklib.com/images/image2/2018080114532989067.jpg B .https://assets.asklib.com/images/image2/2018080114533475360.jpg C .https://assets.asklib.com/images/image2/201808011453398583.jpg D .https://assets.asklib.com/images/image2/2018080114534220354.jpg E .https://assets.asklib.com/images/image2/2018080114534550259.jpg F .https://assets.asklib.com/images/image2/2018080114535031305.jpg

A . SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5; B . SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5; C . SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5; D . SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5

A . INSERT INTO employees VALUES (NULL, 'John', 'smith'); B . INSERT INTO employees (first_name, last_name) VALUES ('John', 'smith'); C . INSERT INTO employees VALUES ('1000, 'John', 'smith'); D . INSERT INTO employees (first_name, last_name, employee_id) VALUES (1000, 'John', 'smith'); E . INSERT INTO employees (employee_id) VALUES (1000); F . INSERT INTO employees ( employee_id, first_name, last_name, ) VALUES (1000, 'John','')

A . SELECT COUNT(*) FROM employees WHERE last_name='Smith'; B . SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith'; C . SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith'; D . SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith'; E . SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith'

A .https://assets.asklib.com/images/image2/2018080115514154580.jpg B .https://assets.asklib.com/images/image2/2018080115514431184.jpg C .https://assets.asklib.com/images/image2/2018080115515173356.jpg D .https://assets.asklib.com/images/image2/2018080115515828127.jpg

A . the DBNEWID utility B . the ANALYZE command C . the RMAN LIST command D . the RMAN REPORT command E . the RMAN CROSSCHECK command F . the RMAN BLOCKRECOVER command

A . The data in the segment will be compacted but the high water mark will not be adjusted  B . The EMPLOYEES table will be changed to read-only mode during the shrink operation  C . The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over D . The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation  E . Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operatio

A . sum B . amount C . number

A . null lock on the row being updated B . null lock on the table containing the row C . ROW SHARE lock for the row being updated D . ROW EXCLUSIVE lock for the row being updated E . shared row-exclusive lock for the row being updated F . a shareable table lock for the table containing the row G . exclusive table-level lock for the table containing the row

A .  Because row IDs may change during the flashback operation B .  Because the object number changes after the flashback operation C .  Because the rows are retrieved from the recycle bin during the flashback operation D .  Because the table is moved forward and back to a temporary during the flashback opertio

<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/24b8b2127f6e518cc48ee2eb3e995f55.jpg' /> A．<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/9c9ecd3bc18e9e5ea56864899f6fd379.jpg' /> B．<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/ce2012a411732ad75a4283de3ff8e2ef.jpg' /> C．<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/07b2ad486cb8e688542e91608c75a123.jpg' /> D．<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/a73cb726d1955a9d3c0133877ce50fd8.jpg' />

You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use？（）<img src='https://img2.soutiyun.com/shangxueba/ask/18264001-18267000/18266966/2018080111484519157.jpg' /> A. SELECT last_name, department_name FROM employees NATURAL JOIN departments; B. SELECT last_name, department_name FROM employees JOIN departments ; C. SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id); D. SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id); E. SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id); F . SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id)

A. Because row IDs may change during the flashback operation B. Because the object number changes after the flashback operation C. Because the rows are retrieved from the recycle bin during the flashback operation D. Because the table is moved forward and back to a temporary during the flashback operation

The EMPLOYEES table contains these columns:EMPLOYEE_ID NUMBER(4)LAST_NAME VARCHAR2 (25)JOB_ID VARCHAR2(10)You want to search for strings that contain ‘SA_‘ in the JOB_ID column. Which SQL statement do you use？（） A.SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA\_%‘ ESCAPE ‘\‘; B.SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA_‘; C.SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA_‘ ESCAPE &quot;\&quot;; D.SELECT employee_id, last_name, job_id FROM employees WHERE job_id = ‘%SA_‘;

<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/6bce46904716f2e8357f4849d2a3423d.jpg' /> <img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/c5c76fa6bab26c6735c868df586306cf.jpg' /> A.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/0f921b8c15106e9d6cc8e36a50134106.jpg' /> B.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/d072515564553d90b433296aa71e021a.jpg' /> C.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/b4721c6b94a9b61c92cdbe82aabc3ae1.jpg' /> D.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/b27c35e83798de4bbbccaef22fa31b48.jpg' /> E. The SQL statement produces an error.