Stay longer
Go slowly
Ok, see you later
第1题:
The EMP table contains these columns:LAST NAME VARCHAR2(25)SALARY NUMBER(6,2)DEPARTMENT_ID NUMBER(6)You need to display the employees who have not been assigned to any department. You write the SELECT statement:SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMPWHERE DEPARMENT_ID = NULL;What is true about this SQL statement? ()
A. The SQL statement displays the desired results.
B. The column in the WHERE clause should be changed to display the desired results.
C. The operator in the WHERE clause should be changed to display the desired results.
D. The WHERE clause should be changed to use an outer join to display the desired results.
第2题:
第3题:
A:The senior managers need the results from last month straight away, so I can't stop to talk. I've got to hurry. B:()
A Stay longer
B Go slowly
C Ok, see you later
第4题:
“Shipment is to be made in the second half of a month.” means shipment to be made from ().
第5题:
SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';
SELECT last_name FROM EMP WHERE last name ='*A%'
SELECT last_name FROM EMP WHERE last name ='_A%';
SELECT last_name FROM EMP WHERE last name LIKE '*A%'
第6题:
to sign
to be signed
signed
signing
第7题:
The two statements produce identical results.
The second statement returns a syntax error.
There is no need to specify DESC because the results are sorted in descending order by default.
The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
第8题:
SMON would automatically restore the lost file.
You would need to restore the whole database from the last backup.
You would need to restore the file from the last full database backup.
You would need to use flashback technology to restore the lost redo log member.
You would need to use Recovery Manager (RMAN) to restore the lost redo log member.
You would need to restore the missing log file by copying one of the remaining files from the same group.
第9题:
The two statements produce identical results.
The second statement returns a syntax error.
There is no need to specify DESC because the results are sorted in descending order by default.
The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
第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.
第11题:
SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;
SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;
SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;
SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;
第12题:
the 1st to the 10th
the 11th to the 20th
the 1st to the 15th
the 16th to the last day of such month
第13题:
第14题:
第15题:
A:The senior managers need the results from last month straight away, so I can't stop to talk. I've got to hurry. B:()
第16题:
Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?()
第17题:
He banned McDonald from using meat from unhealthy cattle.
He stopped the selling of meat from unhealthy cattle.
He lost the trust from the public.
He issued a recall of the meat from unhealthy cattle sold last month.
第18题:
safety screens are of poor quality
working at a VDU for a long time is good for one’s health
more and more British offices will use word processors
British companies will need fewer and fewer managers
第19题:
The two statements produce identical results.
The second statement returns a syntax error.
There is no need to specify DESC because the results are sorted in descending order by default.
The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
第20题:
has taught
had been teaching
has been teaching
had been taught
第21题:
SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit DESC
SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit
SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LAST
SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_last_name, cust_credit_limit NULLSLAST
第22题:
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.
第23题:
Right.
Wrong.
Doesn’t say.