多选题

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

正确答案

答案解析

略

相似试题

Which of the following dynamic view would you query to identify the online CURRENT redo log group？（）
单选题查看答案
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）
单选题查看答案
As a result of a media failure， the current online redo log group is corrupted. The database crashes， as the current online group is inaccessible. Which type of incomplete recovery are you most likely to perform？（）
单选题查看答案
Which view will you use to view information regarding the jobs that are currently running in a database？（）
单选题查看答案
View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities：SQL> SELECT substr（component， 0， 10） COMP， current_size CS， user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0；What do you infer from this（）
单选题查看答案
You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）
多选题查看答案
You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）
多选题查看答案
The NLS_SORT parameter sets the default sort method for which of the following operations？（）
多选题查看答案
Which two statements are true about the duplexing of the backups taken by RMAN？（）
多选题查看答案
The warning and critical threshold values have been set to 85% and 97%， respectively， for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to be 50 % and critical threshold to be 53% in Database Control. Which statement is true？（）
单选题查看答案

语音搜题

拍照搜题

打赏

Oracle认证

正确答案

答案解析