use the ALTER SYSTEM command to change the time zone
use the ALTER SESSION command to change the time zone
use the ALTER DATABASE command to change the time zone
set the value for the operating system variable ORA_SDTZ on the client machine
set the value for the operating system variable ORA_SDTZ on the database server machine
第1题:
A. TIMESTAMP
B. DATE
C. TIMESTAMP WITH TIME ZONE
D. TIMESTAMP WITH LOCAL TIME ZONE
E. DATETIME
第2题:
Two new servers are purchased and need to be installed to allow sharing of a single external hard drive enclosure. One server is configured as a local file server, and the other as a database server for a different network. The onsite technician notices that when both servers are running at the same time, they each receive SCSI errors. When they are running individually, no errors are reported. Which of the following is the BEST source of information to use for troubleshooting this problem?()
第3题:
You work as the IT professional in an international company which is named wiikigo. You are experienced in implementing and administering a network operating system. You are specialized in configuring IP addressing and services, configuring name resolution and network access and so on. You are in charge of a domain controller that runs windows server 2008 and the DNS server role. The dns server hosts an active directory-integrated zone for your domain. You need to provide a user with the ability to manage records in the zone. But the user must not so what action should you perform?()
A.The user permissions on the zone should be granted.
B.The user permissions on the DNS zone should be granted.
C.The user should be added to the DNSUpdateProxy Global security group.
D.The user should be added to the DNSAdmins domain local security group.
第4题:
For the V$SESSION_LONGOPS view, you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database, who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time, but you still do not want to terminate them with an error message. Which method would you follow to achieve this?()
第5题:
Your task is to provision the Junos security platform to permit transit packets from the Private zone to the External zone by using an IPsec VPN and log information at the time of session close.Which configuration meets this requirement?()
第6题:
A user states that all their incoming mail is showing that it is behind three hours. All other users have the correct time. Which of the following should the technician check?()
第7题:
Which operational mode command can be used to synchronize the local system time with an NTP server?()
第8题:
A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error
B. A user belonging to DSS_QUERIES can log in to a new session but the session will be queued
C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management .
D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management, I/O waits, and latch or enqueue contention
第9题:
Which of the following datatypes store time-zone information in the database?()
第10题:
Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement: SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’; What will be the result of issuing the above statement?()