The SQL statement displays the desired results.
The column in the WHERE clause should be changed to display the desired results.
The operator in the WHERE clause should be changed to display the desired results.
The WHERE clause should be changed to use an outer join to display the desired results.
第1题:
SELECT COUNT (*) FROM employees WHERE last _name='smith';
SELECT COUNT (dept_id) FROM employees WHERE last _name='smith';
SELECT DISTINCT (COUNT (dept_id) FROM employees WHERE last _name='smith';
SELECT COUNT (DISTINCT dept_id) FROM employees WHERE last _name='smith';
SELECT UNIQE (dept_id) FROM employees WHERE last _name='smith';
第2题:
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%' ESCAPE '/';
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE /;
SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';
第3题:
randomly
ascending by date
descending by date
ascending alphabetically
descending alphabetically
第4题:
SELECT last_name, 12*salary* commission_pct FROM emp;
SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
第5题:
INSERT INTO employees VALUES (NULL, 'JOHN','Smith');
INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');
INSERT INTO employees VALUES ('1000','JOHN','NULL');
INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');
INSERT INTO employees (employee_id) VALUES (1000);
INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',);
第6题:
The SQL statement displays the desired results.
The column in the WHERE clause should be changed to display the desired results.
The operator in the WHERE clause should be changed to display the desired results.
The WHERE clause should be changed to use an outer join to display the desired results.
第7题:
You have no rows in the table.
You have an employee with the name of James.
You cannot roll back to the same savepoint more than once.
Your last update fails to update any rows because employee ID 180 was already deleted.
第8题:
SELECT &1, &2 FROM &3 WHERE last_name = '&8';
SELECT &1, '&2' FROM &3 WHERE '& last_name = '&8';
SELECT &1, &2 FROM &3 WHERE last_name = '&8';
SELECT &1, '&2' FROM EMP WHERE last_name = '&8';
第9题:
You have no rows in the table.
You have an employee with the name of James.
You cannot roll back to the same savepoint more than once.
Your last update fails to update any rows because employee ID 180 was already deleted.
第10题:
The SQL statement displays the desired results.
The column in the WHERE clause should be changed to display the desired results.
The operator in the WHERE clause should be changed to display the desired results.
The WHERE clause should be changed to use an outer join to display the desired results.