单选题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?（）
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 = '&8';

D

SELECT &1, '&2' FROM EMP WHERE last_name = '&8';

相似考题

1.Which view should a user query to display the columns associated with the constraints on a table owned by the user? ()A. USER_CONSTRAINTSB. USER_OBJECTSC. ALL_CONSTRAINTSD. USER_CONS_COLUMNSE. USER_COLUMNS

2.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 onlyB. Alice and ReenaC. Alice, Reena, and TimberD. Sue, Alice, Reena, and Timber

3.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 userB. An existing SQL Tuning Set (STS)C. A preprocessed Database Replay workloadD. A schema nameE. SQL statement identified in EM as using excessive resources

4.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_USERSD. GRANT select ON dept TO PUBLIC;

参考答案和解析
正确答案： D
解析： 暂无解析
更多“Which SQL statement accepts user input for the columns to be”相关问题

  • 第1题：

    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

  • 第2题：

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

    A.

    B.

    C.

    D.


    参考答案：C

  • 第3题：

    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

  • 第4题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. DB1 is available to a Windows group which is named WIIKIGO/Supervisors. A Windows user named User1 is a member of the WIIKIGO/Supervisors group. WIIKIGO/Supervisors is a member of the db_owner role in the DB1 database. You must make sure that the SQL Server instance is available to User1. In the DB1 database, which Transact-SQL statement(s) should you execute?（）  

    • A、 DROP LOGIN "WIIKIGO/User1"; 
    • B、 EXEC dbo.sp_droprolemember 'db_owner', 'WIIKIGO/User1';
    • C、 EXEC dbo.sp_revokedbaccess 'WIIKIGO/User1';EXEC dbo.sp_revokelogin 'WIIKIGO/User1'; 
    • D、 CREATE LOGIN "WIIKIGO/User1" FROM Windows;DENY CONNECT SQL TO "WIIKIGO/User1";

    正确答案:D

  • 第5题：

    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

  • 第6题：

    Which of the following cannot be used as input to the SQL Tuning Advisor？（）

    • 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题：

    单选题
    To make audit information more productive， the DBA executes the following command before startingan audit operation：  SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE；  Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）
    A

    It contains only the plan for the SQL statement executed by the user.

    B

    It contains the SQL text executed by the user and the bind variables used with it.

    C

    It contains the plan and statistics associated with the SQL statement executed by the user.

    D

    It contains the plan for the SQL statement executed by the user and the bind variables used with it.


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables.  Evaluate the following SQL statement：   SELECT oi.order_id， product_jd， order_date   FROM order_items oi JOIN orders o   USING （order_id）；   Which statement is true regarding the execution of this SQL statement？（）
    A

     The statement would not execute because table aliases are not allowed in the JOIN clause.

    B

     The statement would not execute because the table alias prefix is not used in the USING clause.

    C

     The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.

    D

     The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.


    正确答案： B
    解析： 暂无解析

  • 第9题：

    多选题
    Which three statements are true regarding the fine-grained auditing （FGA）？（）
    A

    FGA is possible on SELECT statements only.

    B

    The audit trail for FGA is stored in the FGA_LOG$ table.

    C

    The audit trail for FGA is stored in the AUD_LOG$ table.

    D

    FGA enables a SQL predicate to define when to audit an event.

    E

    FGA audits DELETE statements only when audit columns are specified.

    F

    FGA includes the SQL statement used by the user as part of the audit event entry.


    正确答案： B,D
    解析： 暂无解析

  • 第10题：

    多选题
    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


    正确答案： B,E
    解析： 暂无解析

  • 第11题：

    多选题
    Examine the statement：   SQL> CREATE TABLESPACE user_data  2> EXTENT MANAGEMENT LOCAL  3> SEGMENT SPACE MANAGEMENT AUTO；   Which twp assumptions must be true for this statement to execute successfully？（）
    A

    Oracle Managed Files are used for this instance.

    B

    The USER_DATA tablespace is managed using FET$/UET$ tables.

    C

    The COMPATIBLE initialization parameter must be 9.0.0 or higher.

    D

    Space within segments in the USER_DATA tablespace is managed with freelists.


    正确答案： B,D
    解析： 暂无解析

  • 第12题：

    多选题
    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


    正确答案： C,F
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?（）

    • A、Task Center
    • B、Command Editor
    • C、Developer Workbench
    • D、Command Line Processor

    正确答案:B

  • 第17题：

    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

  • 第18题：

    Your business has departmental reports that are generated every day. Each department must use the same set of queries， but access a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed； currently， the format changes daily. How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）

    • A、 By having each user run the report generation procedure at the scheduled time， supplying the necessary input variables.
    • B、 By creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOB.
    • C、 By having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report.
    • D、 By having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report.
    • E、 By creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER.

    正确答案:E

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    To make audit information more productive， the DBA executes the following command before starting an auditoperation： SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting Thedatabase（）
    A

    It contains only the plan for the SQL statement executed by the user.

    B

    It contains the SQL text executed by the user and the bind variables used with it.

    C

    It contains the plan and statistics associated with the SQL statement executed by the user.

    D

    It contains the plan for the SQL statement executed by the user and the bind variables used with it


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    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


    正确答案： E
    解析： 暂无解析

  • 第22题：

    单选题
    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;


    正确答案： B
    解析： 暂无解析

  • 第23题：

    多选题
    Which of the following cannot be used as input to the SQL Tuning Advisor？（）
    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


    正确答案： E,B
    解析： 暂无解析

相关内容