网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
多选题
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


参考答案

参考解析
解析: 暂无解析
更多 “多选题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? ()Ause the ALTER SYSTEM command to change the time zoneBuse the ALTER SESSION command to change the time zoneCuse the ALTER DATABASE command to change the time zoneDset the value for the operating system variable ORA_SDTZ on the client machineEset the value for the operating system variable ORA_SDTZ on the database server machine” 相关考题
考题 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.

考题 View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based on the output?() A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an errorB. A user belonging to DSS_QUERIES can log in to a new session but the session will be queuedC. 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

考题 Which of the following datatypes store time-zone information in the database?() A. TIMESTAMPB. DATEC. TIMESTAMP WITH TIME ZONED. TIMESTAMP WITH LOCAL TIME ZONEE. DATETIME

考题 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?()A、The system’s local time settingsB、The system’s O/S version and patch statusC、The system’s network configurationD、The mail server’s configuration

考题 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?()A、 the server vendor’s FAQ websiteB、 the SCSI controller vendor’s user manualC、 the drive enclosure vendor’s user manualD、 the network operating system vendor’s website

考题 Which operational mode command can be used to synchronize the local system time with an NTP server?()A、set ntp time 64.32.129.3B、set clock ntp 64.32.129.3C、set time 64.32.129.3D、set date ntp 64.32.129.3

考题 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?()A、[edit security policies from-zone Private to-zone External] user@host# show policy allowTransit { match { source-address PrivateHosts;destination-address ExtServers; application ExtApps; } then { permit { tunnel { ipsec-vpn VPN; } } log { session-init; } } }B、[edit security policies from-zone Private to-zone External] user@host# show policy allowTransit { match { source-address PrivateHosts; destination-address ExtServers; application ExtApps; } then { permit { tunnel { ipsec-vpn VPN; } } count { session-close; } } }C、[edit security policies from-zone Private to-zone External] user@host# showpolicy allowTransit { match { source-address PrivateHosts; destination-address ExtServers; application ExtApps; } then { permit { tunnel { ipsec-vpn VPN;} } log { session-close; } } }D、[edit security policies from-zone Private to-zone External] user@host# show policy allowTransit { match { source-address PrivateHosts; destination-address ExtServers; application ExtApps; } then { permit { tunnel { ipsec-vpn VPN; log; count session-close; } } } }

考题 Which of the following datatypes store time-zone information in the database?()A、TIMESTAMPB、DATEC、TIMESTAMP WITH TIME ZONED、TIMESTAMP WITH LOCAL TIME ZONEE、DATETIME

考题 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?()A、 Set the CPU time per call in the users profile.B、 Set the CPU time per session in the users profile.C、 Set the CPU levels for the user’s group using Resource Manager.D、 Set the TIMED_STATISTICS parameter to TRUE in the parameter file.

考题 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?()A、 The statement will be executed successfully, and a new time zone will be set for the database.B、 The statement will be executed successfully, but a new time zone will not be set for the database.C、 The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.D、 The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.

考题 You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD. The default format of which two data types would be affected by this setting? ()A、 DATEB、 TIMESTAMPC、 INTERVAL YEAR TO MONTHD、 INTERVAL DAY TO SECONDE、 TIMESTAMP WITH LOCAL TIME ZONE

考题 Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command? ()A、 osB、 localC、 -8:00D、 dbtimezone LiE、 Australia

考题 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.

考题 In your database instance, the user sessions are connected to the database server from the remotemachines. You want to achieve the following for these users:  1:The user account must be locked after four unsuccessful login attempts.PASSWORD_LOCK_TIME  2:The user must be prompted to change the password at regular intervals.PASSWORD_LIFE_TIME  3:The user may not have more than three simultaneous sessions.SESSIONS_PER_USER  4:The user session must automatically be logged off if more than 10 minutes elapsed time used.CONNECT_TIME  How would you accomplish the above()A、by assigning profiles for the usersB、by implementing Fine-Grained Auditing (FGA)C、by granting a secure application role to the usersD、by implementing the Database Resource Manager plan

考题 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 zoneB、 use the ALTER SESSION command to change the time zoneC、 use the ALTER DATABASE command to change the time zoneD、 set the value for the operating system variable ORA_SDTZ on the client machineE、 set the value for the operating system variable ORA_SDTZ on the database server machine

考题 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’

考题 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 environmentD、 The database local time zone will be set for the database using the operating system environment variable.

考题 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.

考题 多选题You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY/x7fMM/x7fDD. The default format of which two data types would be affected by this setting?()ADATEBTIMESTAMPCINTERVAL YEAR TO MONTHDINTERVAL DAY TO SECONDETIMESTAMP WITH LOCAL TIME ZONE

考题 多选题Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command? ()AosBlocalC-8:00Ddbtimezone LiEAustralia

考题 单选题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?()A  the server vendor’s FAQ websiteB  the SCSI controller vendor’s user manualC  the drive enclosure vendor’s user manualD  the network operating system vendor’s website

考题 多选题Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command?()A’os’BlocalC-8:00’Ddbtimezone LiE’Australia’

考题 单选题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?()A The system’s local time settingsB The system’s O/S version and patch statusC The system’s network configurationD The mail server’s configuration

考题 多选题You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD. The default format of which two data types would be affected by this setting? ()ADATEBTIMESTAMPCINTERVAL YEAR TO MONTHDINTERVAL DAY TO SECONDETIMESTAMP WITH LOCAL TIME ZONE

考题 单选题Which of the following datatypes store time-zone information in the database?()A TIMESTAMPB DATEC TIMESTAMP WITH TIME ZONED TIMESTAMP WITH LOCAL TIME ZONEE DATETIME

考题 单选题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 environmentD  The database local time zone will be set for the database using the operating system environment variable.

考题 多选题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? ()Ause the ALTER SYSTEM command to change the time zoneBuse the ALTER SESSION command to change the time zoneCuse the ALTER DATABASE command to change the time zoneDset the value for the operating system variable ORA_SDTZ on the client machineEset the value for the operating system variable ORA_SDTZ on the database server machine

考题 单选题Which of the following datatypes store time-zone information in the database?()A  TIMESTAMPB  DATEC  TIMESTAMP WITH TIME ZONED  TIMESTAMP WITH LOCAL TIME ZONEE  DATETIME