单选题Which substitution variable would you use if you want to reuse the variable without prompting the user each time?（）A &B ACCEPTC PROMPTD &&

第1题：

If you want to use the Java EE platform’s built-in type of authentication that uses a custom HTML page for authentication. Which two statements are true？（）

• A、Your deployment descriptor will need to contain this tag： CUSTOM.
• B、The related custom HTML login page must be named loginPage.html.
• C、When you use this type of authentication， SSL is turned on automatically.
• D、You must have a tag in your deployment descriptor that allows you to point to both a login HTML pageand an HTML page for handling any login errors.
• E、In the HTML related to authentication for this application， you must use predefined variable names fort he variables that store the user and password values.

第2题：

You want to migrate your application from the development environment to the production environment. While doing the task， you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective？（）

• A、owner
• B、touser
• C、include
• D、schemas
• E、fromuser
• F、transform
• G、remap_schema
• H、remap_datafile
• I、reuse_datafiles
• J、remap_tablespace

第3题：

In which scenario will you use the Flashback Transaction Query feature？（）

• A、 when you want to restore an important table that is dropped from the Recycle Bin
• B、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
• C、when you want to restore a dropped user’s schema
• D、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

第4题：

You want to set up the Oracle Database 10g installation to follow the French language， with France as the territory， and the date to be displayed in French for all users’ sessions. Which environmental variable would you set to achieve this objective？（）

• A、NLSLANG
• B、NLSLENGTHSEMANTICS
• C、NLSTERRITORY
• D、NLSLANGUAGE
• E、NLSCHARACTERSET
• F、NLSDATELANGUAGE
• G、NLSNCHARCHARACTERSET

第5题：

You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database.  Which option of IMPDP would you use to accomplish this task（）

• A、FULL
• B、SCHEMAS
• C、TRANSFORM
• D、REMAP_SCHEMA
• E、REMAP_TABLESPACE

第6题：

You issued the following command at the UNIX environment：   % setenv ORA_SDTZ ’OZ_TZ’   What will be the impact of issuing the above command？（）  

• A、 The operating system local time zone will be set for a user session using the operating system environment variable.
• B、 The database local time zone will be set for a user session using the operating system environment variable.
• C、 The operating system local time zone will be set for the database using the operating system environment
• D、 The database local time zone will be set for the database using the operating system environment variable.

第7题：

You create a Web site that is for members only. The Web site allows members to create lists of users that have access to information about member profiles. The name of the list is stored in the listName variable. The user name of the user to whom access is given is stored in the username variable. You need to enable members to manage their lists of users. Which code segment should you use? （）

• A、Roles.CreateRole(listName);User.InInRole(listName);
• B、Roles.CreateRole(listName);Roles.AddUserToRole(useName, listName);
• C、Roles.RoleExists(listName);Roles.AddUserToRole(useName, listName);
• D、Roles.RoleExists(listName);User.InInRole(listName);

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which substitution variable would you use if you want to reuse the variable without prompting the user each time? （）

• A、&
• B、ACCEPT
• C、PROMPT
• D、&&

第14题：

Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）

• A、 use DBMS_IJOB package
• B、 use Oracle Scheduler
• C、 use DBMS_JOB package
• D、 use Oracle Data Pump Export and Import

第15题：

You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）

• A、FULL
• B、SCHEMAS
• C、REMAP_SCHEMA
• D、REMAP_DATAFILES
• E、REMAP_TABLESPACE

第16题：

You want to move all objects of the APPS user in the test database to the DB_USER schema of the productiondatabase.  Which option of IMPDP would you use to accomplish this task（）

• A、FULL
• B、SCHEMAS
• C、TRANSFORM
• D、REMAP_SCHEMA
• E、REMAP_TABLESPACE

第17题：

The current time zone for one of the user sessions is set to the database local time zone. For one application， the user session requires the time zone to be set to the local operating system time zone without affecting other user sessions. Which two solutions could the user implement to achieve this objective？ （）

• A、 use the ALTER SYSTEM command to change the time zone
• B、 use the ALTER SESSION command to change the time zone
• C、 use the ALTER DATABASE command to change the time zone
• D、 set the value for the operating system variable ORA_SDTZ on the client machine
• E、 set the value for the operating system variable ORA_SDTZ on the database server machine

第18题：

You are the administrator of your company’s network. You purchase 75 new Windows 2000 Professional computers that will be shared by the users in Graphic organizational unit (OU). All the computers are configured identically. You want the users to be able to maintain their individual desktop settings regardless of which computer they use. You want to accomplish this with the least amount of administrative effort. What should you do? （）

• A、Configure each computer to join a workgroup.      Create a user account and a local profile for each user. 
• B、Configure each computer to join a workgroup.      Create a domain user account that uses roaming user profiles. 
• C、Configure each computer to join the domain.      Create a user account for each user on a domain controller. 
• D、Configure each computer to join the domain.      Create domain user accounts that use roaming user profiles.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：