单选题Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition?（）ASELECT 1, 2 FROM 3 WHERE last_name = '8';BSELECT 1, '2' FROM 3 WHERE ' last_name = '8';CSELECT 1, 2 FROM 3 WHERE last_name = '8';DSELECT 1, '2' FROM EMP WHERE last_name = '8';
单选题
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';
参考解析
解析：
暂无解析
相关考题：
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
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;
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
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
Which data dictionary table should you query to view the object privileges granted to the user on specific columns? () A. USER_TAB_PRIVS_MADEB. USER_TAB_PRIVSC. USER_COL_PRIVS_MADED. USER_COL_PRIVS
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_NOB. ORDER_IDC. STATUSD. PROD_IDE. ORD_TOTALF. Composite index on ORDER_ID and ORDER_DATE
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.
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.TableB.ColumnsC.Table and AliasD.Columns and Alias
Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）A、USER_TAB_PRIVS_MADEB、USER_TAB_PRIVSC、USER_COL_PRIVS_MADED、USER_COL_PRIVS
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
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";
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 CenterB、Command EditorC、Developer WorkbenchD、Command Line Processor
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、TableB、ColumnsC、Table and AliasD、Columns and Alias
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
Which of the following cannot be used as input to the SQL Tuning Advisor？（）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
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.
单选题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（）AIt contains only the plan for the SQL statement executed by the user.BIt contains the SQL text executed by the user and the bind variables used with it.CIt contains the plan and statistics associated with the SQL statement executed by the user.DIt contains the plan for the SQL statement executed by the user and the bind variables used with it.
单选题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?（）AAlice onlyBAlice and ReenaCAlice, Reena, and TimberDSue, Alice, Reena, and Timber
单选题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.
单选题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（）AIt contains only the plan for the SQL statement executed by the user.BIt contains the SQL text executed by the user and the bind variables used with it.CIt contains the plan and statistics associated with the SQL statement executed by the user.DIt contains the plan for the SQL statement executed by the user and the bind variables used with it
多选题Which three statements are true regarding the fine-grained auditing （FGA）？（）AFGA is possible on SELECT statements only.BThe audit trail for FGA is stored in the FGA_LOG$ table.CThe audit trail for FGA is stored in the AUD_LOG$ table.DFGA enables a SQL predicate to define when to audit an event.EFGA audits DELETE statements only when audit columns are specified.FFGA includes the SQL statement used by the user as part of the audit event entry.
单选题Which view should a user query to display the columns associated with the constraints on a table owned by the user?（）AUSER_CONSTRAINTSBUSER_OBJECTSCALL_CONSTRAINTSDUSER_CONS_COLUMNSEUSER_COLUMNS
多选题Which of the following cannot be used as input to the SQL Tuning Advisor?（） (Choose all that apply.)AA single SQL statement provided by a userBAn existing SQL Tuning Set (STS)CA preprocessed Database Replay workloadDA schema nameESQL statement identified in EM as using excessive resources
单选题The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? （）AGRANT select ON dept TO ALL_ USER;BGRANT select ON dept TO ALL;CGRANT QUERY ON dept TO ALL_USERSDGRANT select ON dept TO PUBLIC;
多选题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？（）AOracle Managed Files are used for this instance.BThe USER_DATA tablespace is managed using FET$/UET$ tables.CThe COMPATIBLE initialization parameter must be 9.0.0 or higher.DSpace within segments in the USER_DATA tablespace is managed with freelists.
多选题Which of the following cannot be used as input to the SQL Tuning Advisor？（）AA single SQL statement provided by a userBAn existing SQL Tuning Set （STS）CA preprocessed Database Replay workloadDA schema nameESQL statement identified in EM as using excessive resources
多选题Examine the SQL statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFComposite index on ORDER_ID and ORDER_DATE