网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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” 相关考题
考题
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
考题
Click the Exhibit button.A network administrator receives complaints that the application voicecube is timing out after being idle for 30 minutes.Referring to the exhibit, what is a resolution?()
A. [edit] user@host# set applications application voicecube inactivity-timeout neverB. [edit] user@host# set applications application voicecube inactivity-timeout 2C. [edit] user@host# set applications application voicecube destination-port 5060D. [edit] user@host# set security policies from-zone trust to-zone trust policy intrazone then timeout never
考题
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this？（）A、Use the Database Resource Manager.B、Set the limits in the profiles used by users.C、Modify the SESSIONS initialization parameter.D、Set the warning threshold for the Current Logons Count metric.
考题
You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?（）A、Set metric thresholdB、Implement Database Resource ManagerC、Enable resumable timeout for user sessionsD、Add directives to Automatic Database Diagnostic Monitor (ADDM)
考题
The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective？（）A、set the SESSIONS to 1 in the parameter fileB、grant SINGLE SESSION privilege to all of the usersC、set the SESSIONS_PER_USER to 1 in the users’ profileD、grant RESTRICTED SESSION privilege to all of the database usersE、create a role with SINGLE SESSION privilege and assign the role to the users
考题
In the exhibit， you decided to change myHosts addresses. [edit security policies] user@host# show from-zone Private to-zone External { policy MyTraffic { match { source-address myHosts； destination-address ExtServers；application [ junos-ftp junos-bgp ]； } then { permit { tunnel { ipsec-vpn vpnTunnel； } } } } } policy-rematch； What will happen to the new sessions matching the policy and in-progress sessions that hadalready matched the policy？（）A、New sessions will be evaluated. In-progress sessions will be re-evaluated.B、New sessions will be evaluated. All in-progress sessions will continue.C、New sessions will be evaluated. All in-progress sessions will be dropped.D、New sessions will halt until all in-progress sessions are re-evaluated. In-progress sessions will be re-evaluated and possibly dropped.
考题
In the configuration shown in the exhibit， you decided to eliminate the junos-ftp applicationfrom the match condition of the policy MyTraffic. [edit security policies] user@hostl# show from-zone Private to-zone External { policy MyTraffic { match { source-address myHosts； destination-address ExtServers； application [ junos-ftp junos-bgp ]； } then { permit { tunnel { ipsec-vpn vpnTunnel； } } } } } policy-rematch； What will happen to the existing FTP and BGP sessions？（）A、The existing FTP and BGP sessions will continue.B、The existing FTP and BGP sessions will be re-evaluated and only FTP sessions will be dropped.C、The existing FTP and BGP sessions will be re-evaluated and all sessions will be dropped.D、The existing FTP sessions will continue and only the existing BGP sessions will be dropped.
考题
You performed an incomplete recovery on your Oracle Database 10g database using the following command： SQL RECOVER DATABASE 2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE； In which situation would the above recovery be required？（）A、 A user table was lost at the specified time.B、 A redo log file was lost at the specified time.C、 The backup control file is on a faster disk than the current one.D、 The current control file has a different path compared with the intended time of recovery.E、 The current control file does not match the physical structure of the database at the intended time of recovery.
考题
You executed the following commands： SQL ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）； Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）A、 The statistics are stored in the pending statistics table in the data dictionary.B、 The statistics are treated as the current statistics by the optimizer for all sessions.C、 The statistics are treated as the current statistics by the optimizer for the current sessions only.D、 The statistics are temporary and used by the optimizer for all sessions until this session terminates.
考题
在SQL*PLUS中，显示执行时长的命令是（）A、set time onB、set timing onC、set longD、set timelong onE、set sqlprompt
考题
You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL DROP PROFILE app_user； Which statement describes the result（）A、The command produces an error.B、The profile is dropped and current user sessions use the DEFAULT profile immediately.C、The profile is dropped and only the subsequent user sessions use the DEFAULT profile.D、The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.
考题
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 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.
考题
单选题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 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 performed an incomplete recovery on your Oracle Database 10g database using the following command： SQL RECOVER DATABASE 2 UNTIL TIME ’2004/x7f08/x7f05：12：10：03’ 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be required？（）A
A user table was lost at the specified time.B
A redo log file was lost at the specified time.C
The backup control file is on a faster disk than the current one.D
The current control file has a different path compared with the intended time of recovery.E
The current control file does not match the physical structure of the database at the intended time of recovery.
考题
单选题You executed the following commands： SQL ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）； Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）A
The statistics are stored in the pending statistics table in the data dictionary.B
The statistics are treated as the current statistics by the optimizer for all sessions.C
The statistics are treated as the current statistics by the optimizer for the current sessions only.D
The statistics are temporary and used by the optimizer for all sessions until this session terminates.
考题
单选题You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task？（）A
Set metric thresholdB
Implement Database Resource ManagerC
Enable resumable timeout for user sessionsD
Add directives to Automatic Database Diagnostic Monitor （ADDM）
考题
单选题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.
考题
单选题All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions： SQL UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated. SQL DELETE FROM persons WHERE exp=’Y’； 3 rows deleted. The SYS user opens a new session after HR executed the above commands. Which sessions can seethe effect of the UPDATE and DELETE commands （）A
all sessions of the HR user onlyB
all sessions of the HR user and the SYS userC
the session of the HR user that executed the commandsD
all the sessions for which the database users have access privilege to the PERSONS table
考题
单选题In the configuration shown in the exhibit， you decided to eliminate the junos-ftp applicationfrom the match condition of the policy MyTraffic. [edit security policies] user@hostl# show from-zone Private to-zone External { policy MyTraffic { match { source-address myHosts； destination-address ExtServers； application [ junos-ftp junos-bgp ]； } then { permit { tunnel { ipsec-vpn vpnTunnel； } } } } } policy-rematch； What will happen to the existing FTP and BGP sessions？（）A
The existing FTP and BGP sessions will continue.B
The existing FTP and BGP sessions will be re-evaluated and only FTP sessions will be dropped.C
The existing FTP and BGP sessions will be re-evaluated and all sessions will be dropped.D
The existing FTP sessions will continue and only the existing BGP sessions will be dropped.
考题
单选题Your company runs Terminal Services on a server named Server2. You need to prevent new sessions on the Terminal Server without affecting current user sessions. Which command should you run？（）A
Change logon /disableB
Change user /execute disableC
Tskill /server：Server2 /AD
Taskkill /S Server2 /fi MODULES eq TermSrv
考题
单选题You performed an incomplete recovery on your Oracle Database 10g database using the following command： SQL RECOVER DATABASE 2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE； In which situation would the above recovery be required？（）A
A user table was lost at the specified time.B
A redo log file was lost at the specified time.C
The backup control file is on a faster disk than the current one.D
The current control file has a different path compared with the intended time of recovery.E
The current control file does not match the physical structure of the database at the intended time of recovery.
考题
单选题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
考题
单选题You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL DROP PROFILE app_user； Which statement describes the result（）A
The command produces an error.B
The profile is dropped and current user sessions use the DEFAULT profile immediately.C
The profile is dropped and only the subsequent user sessions use the DEFAULT profile.D
The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.
考题
单选题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.
考题
多选题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
考题
单选题All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL DELETE FROM persons WHERE exp=’Y’；3 rows deleted. The SYS user opens a new session after HR executed the above commands. Which sessions can see theeffect of the UPDATE and DELETE commands（）A
All sessions of the HR user onlyB
All sessions of the HR user and the SYS userC
The session of the HR user that executed the commandsD
All the sessions for which the database users have access privilege to the PERSONS table
热门标签
最新试卷