单选题Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition? （）A SELECT &1, &2 FROM &3 WHERE last_name = '&8';B SELECT &1, '&2' FROM &3 WHERE '& last_name = '&8';C SELECT &1, &2 FROM &3 WHERE last_name =

题目

单选题

Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition? （）

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';

参考答案和解析

正确答案： A

解析：暂无解析

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

The user Sue issues this SQL statement:GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement:GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement:GRANT SELECT ON sue. EMP TO timber;The user Sue issues this SQL statement:REVOKE select on sue. EMP FROM alice;For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）

A. Alice only

B. Alice and Reena

C. Alice, Reena, and Timber

D. Sue, Alice, Reena, and Timber

参考答案：C

第2题：

Which data dictionary table should you query to view the object privileges granted to the user on specific columns? ()

A. USER_TAB_PRIVS_MADE

B. USER_TAB_PRIVS

C. USER_COL_PRIVS_MADE

D. USER_COL_PRIVS

参考答案：D

第3题：

Which view should a user query to display the columns associated with the constraints on a table owned by the user? ()

A. USER_CONSTRAINTS

B. USER_OBJECTS

C. ALL_CONSTRAINTS

D. USER_CONS_COLUMNS

E. USER_COLUMNS

参考答案：D

第4题：

Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）

A、USER_TAB_PRIVS_MADE
B、USER_TAB_PRIVS
C、USER_COL_PRIVS_MADE
D、USER_COL_PRIVS

正确答案:D

第5题：

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()

参考答案：C

第6题：

Which of the following cannot be used as input to the SQL Tuning Advisor?() (Choose all that apply.)

A. A single SQL statement provided by a user

B. An existing SQL Tuning Set (STS)

C. A preprocessed Database Replay workload

D. A schema name

E. SQL statement identified in EM as using excessive resources

参考答案：C, D

第7题：

Examine the SQL statements that creates ORDERS table:For which columns would an index be automatically created when you execute the above SQL statement? ()

A. SER_NO

B. ORDER_ID

C. STATUS

D. PROD_ID

E. ORD_TOTAL

F. Composite index on ORDER_ID and ORDER_DATE

参考答案：A, F

第8题：

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? ()

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;

参考答案：D

第9题：

A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?()

A.Table

B.Columns

C.Table and Alias

D.Columns and Alias

参考答案：A

第10题：

Which view should a user query to display the columns associated with the constraints on a table owned by the user?（）

A、USER_CONSTRAINTS
B、USER_OBJECTS
C、ALL_CONSTRAINTS
D、USER_CONS_COLUMNS
E、USER_COLUMNS

正确答案:D

Which SQL statement accepts user input for the columns to be

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容