The current time zon...

多项选择题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

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题 Exhibit，View the Exhibit and examine the Resource Manager settings for the groups at different levels. Which two effects would be the result of this setting？（）

A. The members of LOW_GROUP would get more priority than those of OTHER_GROUPS.
B. The members of SYS_GROUP would get most of the CPU allocation at level 1.
C. The members of LOW_GROUP would get most of the CPU allocation because it has CPU allocation at two different levels.
D. The members of LOW_GROUP would get no CPU allocation at level1 if the members of OTHER_GROUPS are using all the CPU at level 2.
E. The members of SYS_GROUP would get no CPU allocation at level 1 if the members of OTHER_GROUPS are using all the CPU at level 2.

点击查看答案

2.单项选择题You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）

A. You do not need to restore all the data files.
B. You do not need to open the database with the RESETLOGS operation
C. You do not need to perform a full backup after the RESETLOGS operation.
D. You do not need to recover all the data files to the same system change number （SCN）.

点击查看答案

3.单项选择题In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）

A. import the database from the last export
B. restore all the members in the group from the last backup
C. drop the lost member from the database and then add a new member to the group
D. restore all the database files from the backup and then perform a complete recovery
E. restore all the database files from the backup and then perform an incomplete recovery

点击查看答案

4.多项选择题You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario？（）

A. You must ensure that the SALES database is mounted or open.
B. You must restore a backup control file to perform a block media recovery.
C. You must take the tools01.dbf data file offline before you start a block media recovery.
D. You must put the database in NOARCHIVELOG mode to perform a block media recovery.
E. You can perform only a complete media recovery of individual blocks， point-in-time recovery of individual data blocks is not supported.

点击查看答案

5.单项选择题One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creating the control file and opening the database？（）

A. drop and re-create the read-only tablespaces
B. rename the read-only data files to their correct file names
C. change the tablespace status from read/write to read-only
D. re-create the read-only tablespace because it is automatically removed

点击查看答案

6.单项选择题You observe that a database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine that required size of the database buffer cache？（）

A. Memory Advisor
B. Segment Advisor
C. SQL Tuning Advisor
D. SQL Access Advisor
E. Automatic Database Diagnostic Monitor （ADDM）

点击查看答案