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_‘;

时间：2024-04-06 14:09:20

相似题目

Click the Exhibit button and examine the data in the EMPLOYEES table. Which three subqueries work? （） https://assets.asklib.com/images/image2/2018080114403417445.jpg

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

查看最佳答案
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

查看最佳答案
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert a row into the table? （）

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', ' ')

查看最佳答案
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 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 structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table? （）

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',")

查看最佳答案
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) Which three statements insert a row into the table? （）

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','')

查看最佳答案
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 data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... 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))

查看最佳答案
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

查看最佳答案
The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）

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

查看最佳答案
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

查看最佳答案
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

查看最佳答案
Examine the data in the EMPLOYEES table:LAST_NAME DEPARTMENT_ID SALARYGetz 10 3000Davis 20 1500Bill 20 2200Davis 30 5000...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));

查看最佳答案
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' />

查看最佳答案
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)

查看最佳答案
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 operation

查看最佳答案
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.

查看最佳答案
Click the Exhibit button to examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.Two new departments are added to your company as shown:DEPARTMENT_ID DEPARTMENT_NAME MGR_ID LOCATION_ID9998 Engineering 1239999 Administrative BostonYou need to list the names of employees, the department IDs, the department names, and the cities where the departments are, even if there are no employees in the departments and even if the departments are not yet assigned to a location. You need to join the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables to retrieve this information.Which statement do you execute to retrieve this information？（）

<img src='https://img2.soutiyun.com/shangxueba/ask/17136001-17139000/17136038/f28d8f90a50d72312b6b87c172d89320.jpg' /> A.SELECT e.last_name, d.department_id, d.department_name, l.city FROM departments d RIGHT OUTER JOIN employees e ON d.department_id = e.department_id RIGHT OUTER JOIN locations l ON d.location_id = l.location_id; B.SELECT e.last_name, d.department_id, d.department_name, l.city FROM departments d FULL OUTER JOIN employees e ON d.department_id = e.department_id FULL OUTER JOIN locations l ON d.location_id = l.location_id; C.SELECT e.last_name, d.department_id, d.department_name, l.city FROM departments d LEFT OUTER JOIN employees e ON d.department_id = e.department_id LEFT OUTER JOIN locations l ON d.location_id = l.location_id; D.SELECT last_name, department_id, department_name, city FROM departments d NATURAL JOIN employees e NATURAL JOIN locations l;

查看最佳答案

推荐题目