单选题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

题目
单选题
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’

相似考题

1.A real-time operating system.（RTOS）is an operating system intended to serve（ ）application process data as it comes in,typically without buffering delays.A key（ ）of a RTOS is the level of its consistency concerning the amount of time it takes to accept and complete an application’s task;the variability is jitter.A hard real-time operating system has（ ）jitter than a soft real-time operating system.The chief design goal is not high throughput,but rather a guarantee of a soft or hard performance category.A RTOS has an advanced algorithm for scheduling.（请作答此空）flexibility enables a wider,computer-system orchestration of process priorities,but a real-time OS is more frequently dedicated to a narrow set of applications.Key factors in a real-time OS are minimal（ ）latency and minimal thread switching latency.A.Scheduler B.Programming C.Network D.User

2. You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name. Which statement is true?（）A、The ORACLE_BASE base parameter is not set.B、The installation is being performed by the root user.C、The operating system group that is specified should have the root user as its member.D、The operating system group that is specified must have permission to write to the inventory directory

3. You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）A、to enable operating system authentication for a remote clientB、to restrict the scope of administration to identical operating systemsC、to allow the start up and shut down of the database from a remote clientD、to enable the administration of the operating system from a remote clientE、to disable the administration of the operating system from a remote client

4. The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE  REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0  You have a local operating system user SKD. You create a database user OPS$SKD， and then  assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege.  What would youachieve by the above process（）A、The database user OPS$SKD will be able to administer the database.B、The authentication detail for the database user OPS$SKD is recorded in the password file.C、The local operating system user SKD will be able to access the database instance without specifying the username and password.D、The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.

更多“单选题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”相关问题

  • 第1题：

    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.

    正确答案:D

  • 第2题：

    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.

    正确答案:A

  • 第3题：

    You executed the following query in your database：  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output？（）

    • A、the time when the last flashback operation in your database was performed
    • B、the time when the first flashback operation in your database was performed
    • C、a list of flashback operations performed in your database using SCN and time
    • D、the approximate time and the lowest system change number （SCN） to which you can flash back your database

    正确答案:D

  • 第4题：

    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’

    正确答案:C

  • 第5题：

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

    正确答案:B

  • 第6题：

    Your company is planning to deploy Windows 7 to all client computers.   You have the following requirements：   Test an application to detect potential compatibility issues caused by User Account Control （UAC）. Monitor an application’s operating system use.   You need to select the appropriate method to detect application compatibility issues.   What should you do？（）

    • A、Use the Standard User Analyzer tool.
    • B、Use the Standard User Analyzer Wizard.
    • C、Use the standalone Setup Analysis Tool.
    • D、Use the Setup Analysis Tool in a virtual environment.

    正确答案:A

  • 第7题：

    单选题
    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’


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    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 users

    B

    by implementing Fine-Grained Auditing （FGA）

    C

    by granting a secure application role to the users

    D

    by implementing the Database Resource Manager plan


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer （OUI） prompts you to enter the path of the inventory directory and also prompts you to specify an operating systemgroup name.  Which statement is true in this case（）
    A

    The ORACLE_BASE parameter is not set.

    B

    The installation is being performed by the root user.

    C

    The operating system group that will be specified should have root user as its member.

    D

    The installation is being performed without the Create Starter Database option selected.

    E

    The operating system group that will be specified must have permission to write to the inventory directory


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    You executed the following query in your database：  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output？（）
    A

    the time when the last flashback operation in your database was performed

    B

    the time when the first flashback operation in your database was performed

    C

    a list of flashback operations performed in your database using SCN and time

    D

    the approximate time and the lowest system change number （SCN） to which you can flash back your database


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege.  What would you achieve by the above process（）
    A

    The database user OPS$SKD will be able to administer the database.

    B

    The authentication detail for the database user OPS$SKD is recorded in the password file.

    C

    The local operating system user SKD will be able to access the database instance without specifying theusername and password.

    D

    The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    Your company is planning to deploy Windows 7 to all client computers.   You have the following requirements：   Test an application to detect potential compatibility issues caused by User Account Control （UAC）. Monitor an application’s operating system use.   You need to select the appropriate method to detect application compatibility issues.   What should you do？（）
    A

    Use the Standard User Analyzer tool.

    B

    Use the Standard User Analyzer Wizard.

    C

    Use the standalone Setup Analysis Tool.

    D

    Use the Setup Analysis Tool in a virtual environment.


    正确答案： C
    解析： 暂无解析

  • 第13题：

    The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege.  What would you achieve by the above process（）

    • A、The database user OPS$SKD will be able to administer the database.
    • B、The authentication detail for the database user OPS$SKD is recorded in the password file.
    • C、The local operating system user SKD will be able to access the database instance without specifying theusername and password.
    • D、The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.

    正确答案:C

  • 第14题：

    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 users
    • B、by implementing Fine-Grained Auditing （FGA）
    • C、by granting a secure application role to the users
    • D、by implementing the Database Resource Manager plan

    正确答案:A

  • 第15题：

    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

    正确答案:B,D

  • 第16题：

    You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer （OUI） prompts you to enter the path of the inventory directory and also prompts you to specify an operating systemgroup name.  Which statement is true in this case（）

    • A、The ORACLE_BASE parameter is not set.
    • B、The installation is being performed by the root user.
    • C、The operating system group that will be specified should have root user as its member.
    • D、The installation is being performed without the "Create Starter Database" option selected.
    • E、The operating system group that will be specified must have permission to write to the inventory directory

    正确答案:E

  • 第17题：

    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.

    正确答案:A

  • 第18题：

    单选题
    In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）
    A

    flash back the database

    B

    perform point-in-time recovery

    C

    perform a full database recovery

    D

    drop and re-create the tablespace

    E

    use Recovery Manager （RMAN） to recover the database


    正确答案： C
    解析： 暂无解析

  • 第19题：

    单选题
    You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）
    A

    to enable operating system authentication for a remote client

    B

    to restrict the scope of administration to identical operating systems

    C

    to allow the start up and shut down of the database from a remote client

    D

    to enable the administration of the operating system from a remote client

    E

    to disable the administration of the operating system from a remote client


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    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 environment

    D

     The database local time zone will be set for the database using the operating system environment variable.


    正确答案： A
    解析： 暂无解析

  • 第22题：

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


    正确答案： E,D
    解析： 暂无解析

  • 第23题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE  REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0  You have a local operating system user SKD. You create a database user OPS$SKD， and then  assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege.  What would youachieve by the above process（）
    A

    The database user OPS$SKD will be able to administer the database.

    B

    The authentication detail for the database user OPS$SKD is recorded in the password file.

    C

    The local operating system user SKD will be able to access the database instance without specifying the username and password.

    D

    The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.


    正确答案： B
    解析： 暂无解析

相关内容