media
instance
statement
user process
第1题:
A. user name
B. password length
C. certificate
D. Host Checker
第2题:
What is the new Oracle Shared Server?()
第3题:
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)
第4题:
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? ()
第5题:
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?()
第6题:
A.media
B.instance
C.statement
D.userprocess
第7题:
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()
第8题:
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
第9题:
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?()
第10题:
How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?()