Oracle认证考试
Which SQL statement accepts user input for the columns to be displayed, the table name, and the WHERE condition?（）A、SELECT &1, "&2" FROM &3 WHERE last_name = '&4';B、SELECT &1, '&2' FROM &3 WHERE '&last_name = '&4'';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 the WHERE condition?（）
- A、SELECT &1, "&2" FROM &3 WHERE last_name = '&4';
- B、SELECT &1, '&2' FROM &3 WHERE '&last_name = '&4'';
- C、SELECT &1, &2 FROM &3 WHERE last_name = '&4';
- D、SELECT &1, '&2' FROM EMP WHERE last_name = '&4';
相似问题和答案
第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
第2题：
A.
B.
C.
D.
第3题：
You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）
A. The tuned plan is not added to the SQL plan baseline.
B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
第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题：
You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）
- A、A text copy of the control file.
- B、A binary copy of the control file.
- C、A file containing a SQL statement which will re-create the database.
- D、A file containing a SQL statement which will re-create the control file.
正确答案:D
第6题：
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
第7题：
A. Bind Variable Peeking
B. SQL Plan Baselines
C. Adaptive Cursor Sharing
D. Bind variable used in a SQL statement
E. Literals in a SQL statement
第8题：
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;
第9题：
Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?（）
- A、Bind Variable Peeking
- B、SQL Plan Baselines
- C、Adaptive Cursor Sharing
- D、Bind variable used in a SQL statement
- E、Literals in a SQL statement
正确答案:A,C,E
第10题：
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