You are maintaining ...

单项选择题You are maintaining your Oracle10g database in the UNIX environment. An application requires one of the user sessions to exist in the operating system local time zone. You decide to set the time zone for a session using the operating system environment variable. Which command will you issue？（）

A. setenv ORA_SDTZ ’DB_TZ’
B. setenv ORA_SDTZ ’+10：00’
C. setenv ORA_SDTZ ’OS-TZ’
D. setenv ORA_SDTZ ’Europe/London’

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题You are specifying French case-insensitive sorts by using the NSL_SORT parameter for the user session of the user， Scott. Which value will you set for the NLS_SORT parameter？（）

A. FRENCH_AI
B. FRENCH_CI
C. AI_FRENCH
D. CI_FRENCH

点击查看答案

2.单项选择题 You created the ORDERS table in your database by using the following code：
SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）；
Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）；
SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）；
SQL> COMMIT；
Next， you issued the following statement to change the time zone for the database：
SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’；
What will be the result of executing the above statement？（）

A. The statement will fail.
B. The statement will be executed successfully， and the new time zone will be set for the database.
C. The statement will be executed successfully， but the new time zone will be set for the current session.
D.The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.

点击查看答案

3.单项选择题Which statement must you issue to an already-running Automatic Storage Management （ASM） instance to prevent database instances from connecting to the ASM instance？（）

A. ALTER SYSTEM KILL SESSION
B. ALTER SYSTEM DISCONNECT SESSION
C. ALTER SYSTEM QUIESCE RESTRICTED
D. ALTER SYSTEM ENABLE RESTRICTED SESSION

点击查看答案

4.单项选择题Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（）

A. If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.
B. If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.
C. If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.
D. If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.

点击查看答案

5.单项选择题You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）

A. INSTANCE_TYPE
B. DB_UNIQUE_NAME
C. ASM_DISKSTRING
D. ASM_POWER_LIMIT

点击查看答案

6.单项选择题Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage. Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（）

A. You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.
B. You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.
C. You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.
D. You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.

点击查看答案

7.单项选择题 You execute the following command to start an Automatic Storage Management （ASM） instance： SQL>STARTUP；
In which of the following modes will the ASM instance start？（）

A. OPEN
B. MOUNT
C. NORMAL
D. NOMOUNT

点击查看答案

8.单项选择题You are migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage？（）

A. BACKUP AS BACKUPSET
B. BACKUP AS COPY
C. BACKUP AS COMPRESSED BACKUPSET
D. BACKUP INCREMENTAL LEVEL n CUMULATIVE

点击查看答案

9.单项选择题 You have configured the ASM instance for the PROD database of iPod Corporation. You have specified the following parameter values in the initialization parameter file：
DB_CREATE_FILE_DEST=’devices/grp1/P’
DB_CREATE_ONLINE_LOG_DEST_1=’devices/d_grp2/Q’
DB_CREATE_ONLINE_LOG_DEST_2=’devices/d_grp3/R’
BACKGROUND_DUMP_DEST=’devices/d_grp1/S’
You have added a new redo log group that contains two redo log members. Where are the redo log members stored？（）

A. Both the members will be stored in the ’devices/grp1/P’ directory.
B. Both the members will be stored in the ’devices/d_grp2/Q’ directory.
C. Both the members will be stored in the ’devices/d_grp3/R’ directory.
D. One member will be stored in the ’devices/d_grp2/Q’ directory and the other in the ’devices/d_grp3/R’ directory.

点击查看答案

10.单项选择题During tablespace creation， which filename format is NOT used for creating datafiles associated with a tablespace？（）

A. incomplete names
B. incomplete names with templates
C. alias with template names
D. numeric names

点击查看答案