题目
A.A
B.B
C.C
D.D
E.E
第1题
A.A
B.B
C.C
D.D
E.E
第2题
A.A
B.B
C.C
D.D
E.E
第3题
A. Right-click the connection, and click Properties. Modify the Provider property of the data connection.
B. Click the Change button, and change the data provider for the selected data source.
C. Click the Advanced button, and change the Data Source property to the target provider.
D. Click the Advanced button, and change the Application Name property to the target provider.
第4题
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.
第5题
A.There is no row with dept_id 90 in the EMPLOYEES table.
B.You cannot delete the JOB_ID column because it is a NOT NULL column.
C.You cannot specify column names in the DELETE clause of the DELETE statement.
D.You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.
第6题
A.120M
B.320M
C.480M
D.600M
第7题
A.deleting the records of employees who do not earn commission
B.increasing the commission of employee 3 by the average commission earned in department 20
C.finding the number of employees who do NOT earn commission and are working for department 20
D.inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3
E.creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSION of the EMP table
F.decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more than 800
第8题
A.listing the employees who earn the same amount of commission as employee 3
B.finding the total commission earned by the employees in department 10
C.finding the number of employees who earn a commission that is higher than the average commission of the company
D.listing the departments whose average commission is more than 600
E.listing the employees who do not earn commission and who are working for department 20 in descending order of the employee ID
F.listing the employees whose annual commission is more than 6000
第9题
A.SELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name=‘Martin‘ AND ord_date IN (‘18-JUL-2000‘,‘21-JUL-2000‘);
B.SELECT ord_id, cust_id, ord_total FROM orders WHERE ord_date IN (SELECT ord_date FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = ‘Martin‘));
C.SELECT ord_id, cust_id, ord_total FROM orders WHERE ord_date IN (SELECT ord_date FROM orders, customers WHERE cust_name = ‘Martin‘);
D.SELECT ord_id, cust_id, ord_total FROMorders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust_name = ‘Martin‘);
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!