网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
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)
考题
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
考题
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
考题
Theclientconnectedtothedatabaseturnsoffhisorhermachinewithoutexitingfromaconnectiontothedatabase.Whichtypeoffailureisthis?()
A.mediaB.instanceC.statementD.userprocess
考题
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.
考题
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 6B、4， 5， and 6C、3， 4， and 5D、1， 2， and 6
考题
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（））；
考题
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 menusB、Through SSH from a TCP/IP connection on the serverC、Through WebSM which is connected to a system Ethernet portD、By connecting through a web browser to an HMC Ethernet port
考题
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
考题
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.
考题
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、ARCnB、CKPTC、DBWnD、LGWRE、PMONF、SMON
考题
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)
考题
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 5B、1，3，and 6C、4，5，and 6D、3，4，and 5E、1，2，and 6
考题
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 fileB、password fileC、listener controller fileD、control file and password file
考题
单选题Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?（）A
REVOKE ACCESS ON DATABASE FROM USER bobB
REVOKE CONNECT ON DATABASE FROM USER tomC
REVOKE tom FROM ACCESS ON DATABASE BY USER bobD
REVOKE tom FROM CONNECT ON DATABASE BY USER bob
考题
单选题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
ARCnB
CKPTC
DBWnD
LGWRE
PMONF
SMON
考题
单选题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.
考题
单选题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
考题
单选题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 6B
4， 5， and 6C
3， 4， and 5D
1， 2， and 6
考题
单选题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
考题
单选题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)
考题
单选题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
考题
单选题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.
考题
单选题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 fileB
password fileC
listener controller fileD
control file and password file
考题
单选题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 5B
1，3，and 6C
4，5，and 6D
3，4，and 5E
1，2，and 6
考题
单选题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）
考题
单选题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（））；
考题
单选题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 menusB
Through SSH from a TCP/IP connection on the serverC
Through WebSM which is connected to a system Ethernet portD
By connecting through a web browser to an HMC Ethernet port
热门标签
最新试卷
