Q1. Which three statements are true about user account administration? (Choose three.)
A. A user's current session is not affected when the user's profile is changed.
B. Only users with the SYSDBA privilege can change the tablespace quota for other users.
C. A new user account can be created only by SYS or SYSTEM users.
D. A user's quota can be set for any permanent tablespace but not for the default temporary
tablespace.
E. A user requires only the CREATE SESSION privilege to change his or her own password.
Answer: A,D,E
Q2. Which three statements are true about Oracle Data Pump? (Choose three.)
A. Oracle Data Pump export and import operations can be performed to move data across
different database releases.
B. DBMS_DATAPUMP PL/SQL packages can be used independent of Data Pump clients.
C. A directory object must exist and a user performing an EXPDP or IMPDP operation must have
read and write permission on that directory object.
D. Oracle Data Pump export and import operations can be performed only by users with the
SYSDBA privilege.
E. Oracle Data Pump export operations invoked from the clients that are connected remotely by
using a connection string, create Data Pump files on the client file system.
Answer: A,B,C
Q3. Which three statements are true about Enterprise Manager Database Express? (Choose
three.)
A. It can be used to perform database backup operations.
B. It can use the HTTP protocol.
C. The same port number is used for multiple Database Express configurations on the same host.
D. It can use the HTTPS protocol.
E. It is available only when the database is open.
Answer: B,D,E
Q4. Examine the parameters:
Users complain that their sessions for certain transactions hang. You investigate and discover
that some users fail to complete their transactions, causing other transactions to wait on row-level
locks. Which two actions would you take to prevent this problem? (Choose two.)
A. Increase the maximum number of ITL slots for segments on which a blocking user performs a
transaction.
B. Decrease the SESSIONS_PER_USER limit in the profiles assigned to blocking users.
C. Set a limit in the proles of blocking users to control the number of data blocks that can be
accessed in a session.
D. Use Database Resource Manager to automatically kill the sessions that are idle and are
blocking other sessions.
E. Decrease the IDLE_TIME resource limit in the profiles assigned to blocking users.
剩余115页未读，继续阅读
资源评论
zld_001
- 粉丝: 2
- 资源: 14
