-
Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）
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
-
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）
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.
-
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which UPDATE statement is valid?（）
A . UPDATE employees SET first_name = 'John' SET last_name ='Smith' WHERE employee_id = 180;
B . UPDATE employees SET first_name = 'John', SET last_name ='Smith' WHERE employee_id = 180;
C . UPDATE employees SET first_name = 'John' AND last_name ='Smith' WHERE employee_id = 180;
D . UPDATE employees SET first_name = 'John', last_name ='Smith' WHERE employee_id = 180
-
Examine the data in the EMPLOYEES table:
https://assets.asklib.com/images/image2/2018080117313142970.jpg
Which three subqueries work? （）
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))
-
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）
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.
-
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:
https://assets.asklib.com/images/image2/2018080115371724654.jpg
Which UPDATE statement is valid?（）
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
-
Examine the data in the EMPLOYEES table:
https://assets.asklib.com/images/image2/2018080114531692453.jpg
Which three subqueries work?（）
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
-
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE Which UPDATE statement is valid? （）
A . UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;
B . UPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;
C . UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;
D . UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180
-
Examine the description of the EMPLOYEES table:
https://assets.asklib.com/images/image2/2018080110341576486.jpg
Which statement produces the number of different departments that have employees with last name Smith?（）
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'
-
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER SALARY NUMBER What is the correct syntax for an inline view? （）
A . SELECT a.last_name, a.salary, a.department_id, b.maxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) b WHERE a.department_id = b.department_id AND a.salary < b.maxsal;
B . SELECT a.last name, a.salary, a.department_id FROM employees a WHERE a.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees))
C . SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE a.salary = (SELECT max(salary) FROM employees b WHERE a.department _ id = b.department _ id);
D . SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE (a.department_id, a.salary) IN (SELECT department_id, a.salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department _ id)
-
Examine the structure of the EMPLOYEES table:
https://assets.asklib.com/images/image2/2018080116355281637.jpg
You issue these statements:
https://assets.asklib.com/images/image2/2018080116355826082.jpg
At the end of this transaction, what is true?（）
A . You have no rows in the table.
B . You have an employee with the name of James.
C . You cannot roll back to the same savepoint more than once.
D . Your last update fails to update any rows because employee ID 180 was already eleted.
-
Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables:
https://assets.asklib.com/images/image2/201808011552157673.jpg
Which MERGE statement is valid?（）
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
-
Examine the structure of the EMPLOYEES table:
https://assets.asklib.com/images/image2/2018080116404390510.jpg
What is the correct syntax for an inline view?（）
A .https://assets.asklib.com/images/image2/2018080116405368499.jpg
B .https://assets.asklib.com/images/image2/2018080116405773977.jpg
C .https://assets.asklib.com/images/image2/2018080116410160098.jpg
D .https://assets.asklib.com/images/image2/2018080116410455360.jpg
-
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）
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
-
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which INSERT statement is valid? （）
A . INSERT INTO employees (employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01/01/01);
B . INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01 january 01');
C . INSERT INTO employees(employee_id, first_name, last_name, Hire_date) VALUES (1000, 'John', 'smith', To_ date ('01/01/01));
D . INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01-Jan-01')
-
User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）
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
-
Before a Flashback Table operation，you execute the following command： ALTER TABLE employees ENABLE ROW MOVEMENT； Why would you need this to be executed？（）
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
-
Click the Exhibit button and examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true？（）
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/e0e7e26248da659a6662e982bf95acc3.jpg' />
A.The SELECT statement is syntactically accurate.
B.The SELECT statement does not work because there is no HAVING clause.
C.The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.
D.The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.
-
Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000？（）
<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' />
-
Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2（25)LAST_NAME VARCHAR2（25)HIRE_DATE DATEWhich UPDATE statement is valid？（）
A.UPDATE employees SET first_name = ‘John‘ SET last_name =‘Smith‘ WHERE employee_id = 180;
B.UPDATE employees SET first_name = ‘John‘, SET last_name =‘Smith‘ WHERE employee_id = 180;
C.UPDATE employees SET first_name = ‘John‘ AND last_name =‘Smith‘ WHERE employee_id = 180;
D.UPDATE employees SET first_name = ‘John‘, last_name =‘Smith‘ WHERE employee_id = 180;
-
Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.
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)
-
The EMPLOYEES table contains these columns:EMPLOYEE_ID NUMBER（4)LAST_NAME VARCHAR2 （25)JOB
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 "\";
D.SELECT employee_id, last_name, job_id FROM employees WHERE job_id = ‘%SA_‘;
-
Examine the data of the EMPLOYEES table.EMPLOYEES （EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)Evaluate this SQL statement:What is its output？（）
<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.
-
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEESEMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2 (25)LAST_NAME VARCHAR2 (25)HIRE_DATE DATENEW EMPLOYEESEMPLOYEE_ID NUMBER Primary KeyNAME VARCHAR2 (60)Which DELETE statement is valid？ （）
A. DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
B. DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);
C. DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = (‘Carrey‘)‘
D. DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_ name = (‘Carrey‘)‘
