itgle.com

单选题The client connected to the database turns off his or her machine without exiting from a connection to the database. Which type of failure is this？（）A mediaB instanceC statementD user process

题目
单选题
The client connected to the database turns off his or her machine without exiting from a connection to the database. Which type of failure is this？（）
A

media

B

instance

C

statement

D

user process

相似考题

1.Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL> SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?（）A. User processB. Server processC. System Monitor (SMON)D. Process Monitor (PMON)E. Checkpoint process (CKPT)

2.You want to restrict access to a role based on the client machine from which the user is accessing the network.Which two role restrictions accomplish this goal? ()A. user nameB. password lengthC. certificateD. Host Checker

3.Theclientconnectedtothedatabaseturnsoffhisorhermachinewithoutexitingfromaconnectiontothedatabase.Whichtypeoffailureisthis?()A.mediaB.instanceC.statementD.userprocess

4.An employee cannot access the company database. You check the connection variables:What is a valid explanation for why one of the users is unable to connect to the database?()A.Bob has max_user_connections set to zero, which blocks all his connectionsB.Joe has exceeded the max_user_connections global limitC.All users are blocked because max_user_connections is accumulated over the host account informationD.Kay is already connected elsewhere and attempting to log in againE.Connect_timeout is too small to allow a connection to occur

参考答案和解析
正确答案： D
解析： 暂无解析
更多“单选题The client connected to the database turns off his or her machine without exiting from a connection to the database. Which type of failure is this？（）A mediaB instanceC statementD user process”相关问题

  • 第1题：

    What is the new Oracle Shared Server?（）

    • A、An improved version of multithreaded server configuration. 
    • B、A connection pooling configuration where several clients are connected to the same server process. 
    • C、Two more database servers, which share data by means of database links; the client software is unaware to which server it is connected. 
    • D、A configuration of Real Application Cluster where the client connection is routed to the least busy instance. 

    正确答案:A

  • 第2题：

    Users of your web application have requested that they should be able to set the duration of their sessions.So for example， one user might want a webapp to stay connected for an hour rather than the webapp’sdefault of fifteen minutes； another user might want to stay connected for a whole day. Furthermore， youhave a special login servlet that performs user authentication and retrieves the User object from the database. You want to augment this code to set up the user’s specified session duration. Which codesnippet in the login servlet will accomplish this goal？（）

    • A、User user = // retrieve the User object from the database session.setDurationInterval（user.getSessionDuration（））；
    • B、User user = // retrieve the User object from the database session.setMaxDuration（user.getSessionDuration（））；
    • C、User user = // retrieve the User object from the database session.setInactiveInterval（user.getSessionDuration（））；
    • D、User user=//retrieve the User object from the database session.setDuration（user.getSessionDuratio（））；
    • E、User user = // retrieve the User object from the database session.setMaxInactiveInterval（user.getSessionDuration（））；

    正确答案:E

  • 第3题：

    You want to restrict access to a role based on the client machine from which the user is accessing the network.Which two role restrictions accomplish this goal? （）

    • A、user name
    • B、password length
    • C、certificate
    • D、Host Checker

    正确答案:C,D

  • 第4题：

    While connected to the database，a user on a PC receives a fatal error and the machine reboots. Which background process cleans up the failed connection？（）

    • A、ARCn
    • B、CKPT
    • C、DBWn
    • D、LGWR
    • E、PMON
    • F、SMON

    正确答案:E

  • 第5题：

    Given below is a list of scenarios：  1）A user terminates his session abnormally.  2）The connection between the server and the client application terminates because of a network failure.  3）A schema is accidentally dropped.  4）The tablespace is accidentally dropped from the database.  5）The hard disk gets corrupted and the data files in the disk are lost.  6）The database instance abnormally shuts down because of power failure.  Which scenarios require DBA intervention to perform recovery（）

    • A、4 and 5
    • B、1，3，and 6
    • C、4，5，and 6
    • D、3，4，and 5
    • E、1，2，and 6

    正确答案:D

  • 第6题：

    单选题
    Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?（）
    A

    REVOKE ACCESS ON DATABASE FROM USER bob

    B

    REVOKE CONNECT ON DATABASE FROM USER tom

    C

    REVOKE tom FROM ACCESS ON DATABASE BY USER bob

    D

    REVOKE tom FROM CONNECT ON DATABASE BY USER bob


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

  • 第7题：

    单选题
    What is the new Oracle Shared Server?（）
    A

    An improved version of multithreaded server configuration. 

    B

    A connection pooling configuration where several clients are connected to the same server process. 

    C

    Two more database servers, which share data by means of database links; the client software is unaware to which server it is connected. 

    D

    A configuration of Real Application Cluster where the client connection is routed to the least busy instance. 


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

  • 第8题：

    单选题
    Given below is a list of scenarios： 1） A user terminates his session abnormally. 2） The connection between the server and the client application terminates because of a network failure. 3） A schema is accidentally dropped. 4） The tablespace is accidentally dropped from the database. 5） The hard disk gets corrupted and the data files in the disk are lost. 6） The database instance abnormally shuts down because of power failure.  Which scenarios require DBAintervention to perform recovery（）
    A

    1， 3， and 6

    B

    4， 5， and 6

    C

    3， 4， and 5

    D

    1， 2， and 6


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

  • 第9题：

    单选题
    Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）
    A

    User process

    B

    Server process

    C

    System Monitor (SMON)

    D

    Process Monitor (PMON)

    E

    Checkpoint process (CKPT)


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

  • 第10题：

    单选题
    How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）
    A

     Issue the grant command from the SYS user （or equivalent） of the target database.

    B

     Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.

    C

     Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.

    D

     Issue the grant command from RMAN when connected to the recovery catalog-owning schema.

    E

     Issue the grant command from RMAN when connected to the target database.


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

  • 第11题：

    单选题
    Given below is a list of scenarios：  1）A user terminates his session abnormally.  2）The connection between the server and the client application terminates because of a network failure.  3）A schema is accidentally dropped.  4）The tablespace is accidentally dropped from the database.  5）The hard disk gets corrupted and the data files in the disk are lost.  6）The database instance abnormally shuts down because of power failure.  Which scenarios require DBA intervention to perform recovery（）
    A

    4 and 5

    B

    1，3，and 6

    C

    4，5，and 6

    D

    3，4，and 5

    E

    1，2，and 6


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

  • 第12题：

    单选题
    Users of your web application have requested that they should be able to set the duration of their sessions.So for example， one user might want a webapp to stay connected for an hour rather than the webapp’sdefault of fifteen minutes； another user might want to stay connected for a whole day. Furthermore， youhave a special login servlet that performs user authentication and retrieves the User object from the database. You want to augment this code to set up the user’s specified session duration. Which codesnippet in the login servlet will accomplish this goal？（）
    A

    User user = // retrieve the User object from the database session.setDurationInterval（user.getSessionDuration（））；

    B

    User user = // retrieve the User object from the database session.setMaxDuration（user.getSessionDuration（））；

    C

    User user = // retrieve the User object from the database session.setInactiveInterval（user.getSessionDuration（））；

    D

    User user=//retrieve the User object from the database session.setDuration（user.getSessionDuratio（））；

    E

    User user = // retrieve the User object from the database session.setMaxInactiveInterval（user.getSessionDuration（））；


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

  • 第13题：

    Given below is a list of scenarios： 1） A user terminates his session abnormally. 2） The connection between the server and the client application terminates because of a network failure. 3） A schema is accidentally dropped. 4） The tablespace is accidentally dropped from the database. 5） The hard disk gets corrupted and the data files in the disk are lost. 6） The database instance abnormally shuts down because of power failure.  Which scenarios require DBAintervention to perform recovery（）

    • A、1， 3， and 6
    • B、4， 5， and 6
    • C、3， 4， and 5
    • D、1， 2， and 6

    正确答案:C

  • 第14题：

    Companycom purchased a p5 570 with no plans to partition. The customer plans to use the ASMI interface to power on and off the machine. How can ASMI be accessed without a HMC?（）

    • A、By typing diags and then going to the ASMI menus
    • B、Through SSH from a TCP/IP connection on the server
    • C、Through WebSM which is connected to a system Ethernet port
    • D、By connecting through a web browser to an HMC Ethernet port

    正确答案:D

  • 第15题：

    How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）  

    • A、 Issue the grant command from the SYS user （or equivalent） of the target database.
    • B、 Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.
    • C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
    • D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
    • E、 Issue the grant command from RMAN when connected to the target database.

    正确答案:D

  • 第16题：

    Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）

    • A、User process
    • B、Server process
    • C、System Monitor (SMON)
    • D、Process Monitor (PMON)
    • E、Checkpoint process (CKPT)

    正确答案:B

  • 第17题：

    You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）

    • A、control file
    • B、password file
    • C、listener controller file
    • D、control file and password file

    正确答案:B

  • 第18题：

    单选题
    While connected to the database，a user on a PC receives a fatal error and the machine reboots. Which background process cleans up the failed connection？（）
    A

    ARCn

    B

    CKPT

    C

    DBWn

    D

    LGWR

    E

    PMON

    F

    SMON


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

  • 第19题：

    单选题
    The client connected to the database turns off his or her machine without exiting from a connection to the database. Which type of failure is this？（）
    A

    media

    B

    instance

    C

    statement

    D

    user process


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

  • 第20题：

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

    B

    All sessions of the HR user and the SYS user

    C

    The session of the HR user that executed the commands

    D

    All the sessions for which the database users have access privilege to the PERSONS table


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

  • 第21题：

    单选题
    An employee cannot access the company database. You check the connection variables: What is a valid explanation for why one of the users is unable to connect to the database?（）
    A

    Bob has max_user_connections set to zero, which blocks all his connections

    B

    Joe has exceeded the max_user_connections global limit

    C

    All users are blocked because max_user_connections is accumulated over the host account information

    D

    Kay is already connected elsewhere and attempting to log in again

    E

    Connect_timeout is too small to allow a connection to occur


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

  • 第22题：

    单选题
    You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）
    A

    control file

    B

    password file

    C

    listener controller file

    D

    control file and password file


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

  • 第23题：

    单选题
    Your database interface is running. A user SCOTT starts a SQL *Plus session， and issues the following query：   SQL> SELECT * FROM sales；   Which process would retrieve the result from the database and return it to the client program？（）
    A

     User process

    B

     Server process

    C

     System Monitor （SMON）

    D

     Process Monitor （PMON）

    E

     Checkpoint process （CKPT）


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

  • 第24题：

    单选题
    Companycom purchased a p5 570 with no plans to partition. The customer plans to use the ASMI interface to power on and off the machine. How can ASMI be accessed without a HMC?（）
    A

    By typing diags and then going to the ASMI menus

    B

    Through SSH from a TCP/IP connection on the server

    C

    Through WebSM which is connected to a system Ethernet port

    D

    By connecting through a web browser to an HMC Ethernet port


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

相关内容