Which statement about INSERT operations is true、

试卷相关题目

• 1If the following result set is desired:  LASTNAME    FIRSTNAME   SALARY      JOB --------    ---------   ------      --- HAAS        CHRISTINE   152750.00   PRES KWAN        SALLY       98250.00    MANAGER PULASKI     EVA         96170.00    MANAGER THOMPSON    MICHAEL     94250.00    MANAGER HENDERSON   EILEEN      89750.00    MANAGER Which SQL statement must be executed、

  A.SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWSONLY

  B.SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5ROWS ONLY

  C.SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS

  D.SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5ROWS

  开始考试点击查看答案
• 2Which SQL statement will retrieve the employee number (EMPNO), hire date (HIREDATE), and salary (SALARY) for each employee from a table named EMPLOYEE who was hired before 1998 and earns a salary of less than $35,000.00 per year、

  A.SELECT empno, hiredate, salary FROM employee FOR hiredate < '1998-01-01' AND salary < 35000

  B.SELECT empno, hiredate, salary FROM employee WHERE hiredate < '1998-01-01' AND salary < 35000

  C.SELECT empno, hiredate, salary FROM employee WHERE hiredate < '1998-01-01' OR salary <35000

  D.SELECT empno, hiredate, salary FROM employee FOR hiredate < '1998-01-01' OR salary < 35000

  开始考试点击查看答案
• 3User USER1 wants to retrieve records from a table named EMPLOYEE that satisfy at least one of the following criteria:-The employee's hire date (HIREDATE) is before 1999 and the employee's salary (SALARY) is less than $40,000.00 a year. -The employee has attended universityWhich SQL statement will accomplish this、

  A.SELECT * FROM employee WHERE (hiredate < '1999-01-01' AND salary < 40000) OR (education ='University')

  B.SELECT * FROM employee WHERE (hiredate < '1999-01-01') OR (salary < 40000) OR (education ='University')

  C.SELECT * FROM employee WHERE (hiredate < '1999-01-01' OR (salary < 40000 AND (education ='University')

  D.SELECT * FROM employee WHERE (hiredate < '1999-01-01' AND salary < 40000 AND (education ='University')

  开始考试点击查看答案
• 4Which function can be used to obtain values from XML documents that are to be inserted into one or more tables、

  A.XMLTABLE

  B.XMLPARSE

  C.XMLEXISTS

  D.XMLATTRIBUTES

  开始考试点击查看答案
• 5Which command will delete all rows from a table without generating log records、

  A.TRIM

  B.DROP

  C.DELETE

  D.TRUNCATE

  开始考试点击查看答案
• 6Which statement about application-period temporal tables is true、

  A.Consists of explicitly-supplied timestamps and a separate associated history table.

  B.Is based on explicitly-supplied timestamps that define the time periods during which data is valid.

  C.Is useful when one wants to keep both user-based period information and system-based historical information.

  D.Consists of a pair of columns with database-manager maintained values that indicate the period when a row is current.

  开始考试点击查看答案
• 7Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE、

  A.SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job;

  B.SELECT job, MIN(salary), MAX(salary) FROM employee ORDER BY job;

  C.SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job, MIN(salary), MAX(salary);

  D.SELECT JOB, MIN(salary), MAX(salary) FROM employee ORDER BY job, MIN(salary), MAX(salary);

  开始考试点击查看答案
• 8In a trusted context environment, if a switch request is made with an authorization ID that is not allowed on a trusted connection, what state is the connection placed in、

  A.Locked

  B.Waiting

  C.Pending

  D.Unconnected

  开始考试点击查看答案
• 9If a user has been granted SYSCTRL authority, which activities can they perform、

  A.Load operations

  B.Backup/copy table spaces

  C.Create and drop databases

  D.Monitor database performance

  开始考试点击查看答案
• 10What is the purpose of a role、

  A.To define exactly what a specific user can do within a particular database once they have been authenticated.

  B.To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users.

  C.To establish a credible relationship between DB2 and an external entity, such as a database administrator or a middleware server.

  D.To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges.

  开始考试点击查看答案