116、
116.Your database is in shutdown state. What will happend if you issue next command: SQL> startup A. instance will started B. instance started and DB is mounted C. instance started, DB opened and finally mounted D. instance started, DB mounted and finally opened
Answer: D
117、
117.Which two statements are true about standard database auditing? (Choose two.) A. DDL statements can be audited. B. Statements that refer to standalone procedure can be audited. C. Operations by the users logged on as SYSDBA cannot be audited. D. Only one audit record is ever created for a session per audited statement even though it is executed more than once.
Answer: AB
118、View Exhibit to examine the current memory allocation and parameter settings, respectively.
Why are advisors not available for the shared pool and the buffer cache? A. because the DB_CACHE_ADVICE parameter is set to OFF B. because Automatic Memory Management (AMM) is disabled for the database instance C. because Automatic Shared Memory Management (ASMM) is enabled for the database instance D. because the values for the DB_CACHE_SIZE and SHARED_POOL_SIZE parameters were not set initially
Answer: C
119、
119.You receive complaints from users regarding the high waiting time for their transactions. On investigation, you find that some users are not committing their transactions though they are not performing any activity for a long time. As a result, SQL statements need to wait for rowlevel locks. Which two actions could you take to prevent this locking problem in the future? (Choose two.) A. Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users. B. Use Database Resource Manager to automatically log out sessions that block others and are idle C. Set the limit in the profile of blocking users to control the number of blocks to be accessed in a session. D. Decrease the maximum number of interested transaction list (ITL) slots for the segments on which the
Answer: AB
120、
120.A database user SMITH tries to query the V$SESSION view and fails to access it as follows: SQL> connect smith/smith Connected. SQL> SELECT * FROM v$session; SELECT * FROM v$session * ERROR at line 1: ORA-00942: table or view does not exist Which are the two possible solutions to enable SMITH to query the data in V$SESSION? (Choose two.) A. granting SELECT privilege to SMITH on V$SESSION B. granting SELECT privilege to SMITH on V_$SESSION C. asking the user SMITH to run the catalog.sql script D. granting SELECT privilege to SMITH on V$FIXED_TABLES E. setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE F. creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
Answer: BF
