Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age > 40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?()
第1题:
A. GRANT select ON dept TO ALL_ USER;
B. GRANT select ON dept TO ALL;
C. GRANT QUERY ON dept TO ALL_USERS
D. GRANT select ON dept TO PUBLIC;
第2题:
用SQL命令生成含有字段职工号、姓名的视图,下列语句正确的是 ______。
A.CREATE VIEW ZG_w AS SELECT职工号,姓名FROM职工
B.CREATE QUERY ZG_w AS SELECT职工号,姓名FROM职工
C.CREATE VIEW ZG w AS SELECT职工号,姓名
D.CREATE QUERY ZG_w AS SELECT职工号,姓名
第3题:
此题为判断题(对,错)。
第4题:
SQL是哪几个英语单词的缩写()
第5题:
Given the following statements:CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3);What is the result of the following query? SELECT count(*) FROM tab2;()
A.3
B.2
C.1
D.0
第6题:
Observe the structure of the table employees:The table contains 8475 records.One of the employees wants to know the names of all employees of the company. For this, he fires the following query:SELECT * FROM EMPLOYEES ORDER BY emp_fname;Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation.Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?()
A. Rollback segment
B. Temporary segment
C. Data segment
D. Index segment
第7题:
SQL是 ______的缩写。
A.Standard Query Language
B.Structured Query Language
C.Select Query Language
D.以上都不是
第8题:
用SQL命令生成含有字段职工号、姓名的视图,下列语句正确的是______。
A.CREATE VIEW ZG w AS SELECT职工号,姓名FROM职工
B.CREATE QUERY ZG w AS SELECT职工号,姓名FROM职工
C.CREATE VIEW ZG w AS SELECT职工号,姓名
D.CREATE QUERY ZG w AS SELECT职工号,姓名
第9题:
Given the following function:CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN (‘A00‘, ‘B00‘); ENDHow can this function be used in an SQL statement?
A.SELECT TABLE(EMPLIST()) FROM EMPLOYEE
B.SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE
C.SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE
D.SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
第10题:
Given the following table definitions: EMPLOYEE ID NAME DEPTID 01Smith 10 02Bossy 20 03 20 Peterson 04Goss 30 05Pape 40 06Avery 50 07O'Neal 60 08Carter 50 DEPARTMENT ID DEPTNAME 05 Hardware 10 Kitchen 20 Shoes 30 Toys 40 Electronics 50 Automotive and the following query: SELECT e.id, d.deptname FROM employee e, department d WHERE e.deptid = d.id AND e.id > 4 Which of the following queries will produce the same result set as the query above?()