单选题You want to create a temporary table while executing a procedure in a form. Which statement is true?（）A You cannot create a table form within Forms. B You must use the FORMS_DDL built-in to create the table. C You must use the DBMS_DYNAMIC_DDL package 

第1题：

Which are SRW package procedure or function could you use to create and then drop a temporary table in the sales report?（）

• A、SRW.BREAK 
• B、SRW.SET_ALTER 
• C、SRW.REFERENCE 
• D、SRW.DO_SQL 
• E、SRW.RUN_REPORT
• F、SRW.SET_FIELD

第2题：

While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（） 

• A、A primary key must have been created.
• B、A mapping table must have been created.
• C、An overflow tablespace must have been specified.
• D、The PCTTHRESHOLD option must have been specified.

第3题：

You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）

• A、 You must enable the block change tracking feature.
• B、 You must have enable the flashback feature.
• C、 You must use the OMF in your database.
• D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

第4题：

You created the DEPT table by using the following command：   CREATE TABLE scott.dept   （deptno NUMBER（3），   dname VARCHAR2（15），   loc VARCHAR2（15） ）   STORAGE （INITIAL 100K NEXT 50K  MAXEXTENTS 10 PCTINCREASE 5  FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）

• A、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.
• B、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.
• C、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.
• D、 You cannot shrink the SCOTT.EMP table.

第5题：

You are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?（）

• A、Before parameter form. 
• B、After parameter form. 
• C、Before report. 
• D、After report.

第6题：

You need to ensure the Order Control team is able to track the number of orders that reach the production department. What should you do?（）

• A、Create a new Time dimension based on the Holiday table. Use derived columns for the month and the year.
• B、Create a Server Time dimension. Within this dimension， enable the time periods year， month， and date. Select the Additional Manufacturing calendar option.
• C、Create a new Time dimension based on the date values within the ProductOrderStatus table. Flag those days on which no orders were received as Holiday.
• D、Create a new Time dimension based on a data source view named query. Derive the data for this data source view from unique dates within the ProductOrderStatus table. Use a subquery to identify the holidays and derived columns for the month and the year.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?（）

• A、Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORY
• B、Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table
• C、Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table
• D、Set binlog_format=MIXED with the – replicate-ignore-temp-table option
• E、Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table

第14题：

You want to create a role to meet these requirements：  1：The role is to be protected from unauthorized usage.  2：The password of the role is not to be embedded in the application source code or stored in a table.  Which method would you use to restrict enabling of such roles（）

• A、Create the role with global authentication.
• B、Create the role with external authentication.
• C、Create the role as a secure application role.
• D、Create the role as a password-protected role.
• E、Create a role and use Fine-Grained Access Control （FGAC） to secure the role.

第15题：

While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）

• A、 A primary key must have been created.
• B、 A mapping table must have been created.
• C、 An overflow tablespace must have been specified.
• D、 The PCTTHRESHOLD option must have been specified.

第16题：

Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）

• A、FORMS_DDL 
• B、DO_SQL 
• C、FORM_SUCCESS 
• D、FORM_NOT_SUCCESS
• E、DBMS.ERROR_CODE

第17题：

You work in a company which 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. The DB1 database contains the following stored procedure. (Line numbers are useded for reference only.)  01 CREATE PROCEDURE Sales.Procedure1  02 AS  03 IF OBJECT_ID('Service.Table') IS NOT NULL  04 DROP TABLE Service.Table;  06 CREATE TABLE Service.Table (  07 Id int PRIMARY KEY CLUSTERED,  08 Name varchar(100);  09 );  11 ...  12  GOThe following exception is raised when a user tries to invoke Procedure1, "Msg 262, Level 14, State 1, Procedure Procedure1, Line 5 CREATE TABLE permission denied in database 'DB1'." You should grant the user access to execute Procedure1, you must assign only the required permissions.  What action should you do perform?（）  

• A、Between lines 01 and 02, you should insert the WITH EXECUTE AS 'dbo' clause. 
• B、Between lines 01 and 02, you should insert the EXECUTE AS USER = 'dbo' statement. 
• C、You should give the user the ALTER permission on the Service schema 
• D、You should give the CREATE TABLE permission and permit the user to drop the Service.Table table. 

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：