单选题On which of the following database objects may the SELECT privilege be controlled?（）A SequenceB SchemaC GroupD View

第1题：

Derek has created a view in the products.nsf database. Derek wants the markup column in the view to display the selling price of the cost. He wants this value to display in currency. Which one of the following should derekl do? （）

• A、 use the @currenty in thr column formula in the view  
• B、 Select currency on the numbers tab in the view properties box 
• C、 Select currency on the numbers tab in the column properties box 
• D、 Select currency on the numbers tab in the field properties box 

第2题：

tommy has created a sales view in his sales.nsf database. Tommy wants negative numbers in the sales number column in the view parenthesis. which one of the following should tommy do?（）

• A、select the parenthesis when negative value in the view properties box 
• B、select the parenthesis when negative value in the column properties box 
• C、use the @function @negative to set this in the column formula in the view 
• D、use a formula to format the value in the field on the form that will be displaying in the view

第3题：

On which of the following database objects may the SELECT privilege be controlled?（）

• A、Sequence
• B、Schema
• C、Group
• D、View

第4题：

Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?（）

• A、View
• B、Alias
• C、Table
• D、Package

第5题：

The HR user creates a view with this command：  SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp；  Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user.  Which statement is true in this scenario？（）

• A、HR can grant the privilege to JIM but without GRANT OPTION.
• B、HR can grant the privilege to JIM because HR is the owner of the view.
• C、SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.
• D、HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.

第6题：

A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL> connect smith/smith  Connected.  SQL> SELECT * FROM v$session；  SELECT * FROM v$session *  ERROR at line 1：  ORA-00942： table or view does not exist  Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）

• A、granting SELECT privilege to SMITH on V$SESSION
• B、granting SELECT privilege to SMITH on V_$SESSION
• C、asking the user SMITH to run the catalog.sql script
• D、granting SELECT privilege to SMITH on V$FIXED_TABLES
• E、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
• F、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

An Alias can be an alternate name for which DB2 object?（）

• A、Sequence
• B、Trigger
• C、Schema
• D、View

第14题：

Which of the following database objects is considered executable using SQL?（）

• A、View
• B、Table
• C、Routine
• D、Package

第15题：

Which of the following database objects can be used to raise an error if a table is updated?（）

• A、Package
• B、Trigger
• C、Stored Procedure
• D、Informational Constraint

第16题：

A number of applications issue the following SQL statement:SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptnoA database administrator wishes to store this query within the database. Which of the following database objects can be used to accomplish this?（）

• A、Alias
• B、View
• C、Schema
• D、Trigger

第17题：

Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?（）

• A、Materialized views 
• B、Indexes 
• C、Index-organized tables 
• D、Hash clusters

第18题：

You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（） 

• A、V$DATABASE 
• B、DBA_TABLES 
• C、SYSAUD$ 
• D、EMP

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：