EnsurepassQUESTION 181 Which three descriptions are correct about the effects of the TRUNCATE command on a table? (Choose three.)   A.      The corresponding indexes for the table are also truncated. B.      Delete triggers on the table are fired during the execution of the TRUNCATE command. C.      The child table is truncated when the TRUNCATE command is applied on the parent table. D.      Read more [...]
EnsurepassQUESTION 171 A database user SMITH tries to query the V$SESSION view and fails to access it as follows:     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.      Read more [...]
EnsurepassQUESTION 161 All the database users are presently connected to the database instance and working. The HR user has opened 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 the effect of the UPDATE and DELETE Read more [...]
EnsurepassQUESTION 151 You are working on a database that must be functioning 24 hours a day, 7 days a week. The database is configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups? (Choose two.)   A.      You can perform consistent backups only. B.      You can perform a complete database backup without shutting down the database instance. C.      You can back up data files Read more [...]
EnsurepassQUESTION 141 View the Exhibit and examine the output of the query. What do you infer from this?     A.      The SGA_TARGET is a static parameter. B.      The instance is started, but the database is not yet open. C.      The server parameter file (SPFILE) was used to start the instance. D.      The SGA_TARGET parameter does not have any effect on the database instance until Read more [...]
EnsurepassQUESTION 131 Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)   A.      Recover from failures in the RAC environment. B.      Diagnose and repair a data file corruption online. C.      Diagnose and repair a data file corruption offline. D.      Diagnose and repair failures on a standby database.   Answer: AD     Read more [...]
EnsurepassQUESTION 121 Note the following functionalities of various background processes:   1.       Record the checkpoint information in data file headers. 2.       Perform recovery at instance startup. 3.       Cleanup unused temporary segments. 4.       Free the resources used by a user process when it fails. 5.       Dynamically register Read more [...]
EnsurepassQUESTION 111 Identify two situations in which the block header grows in a data block. (Choose two.)   A.      When row directories need more row entries. B.      When there is row migration in the data block. C.      When there is an increase in the PCTFREE value for the data block. D.      When more transaction slots are required than are initially configured.   Answer: Read more [...]
EnsurepassQUESTION 101 Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressed mode for an installation?   A.      Run the root.sh script. B.      Create the oraInst.loc file. C.      Create the tnsnames.ora file. D.      Run the oraInstRoot.sh script.   Answer: B     QUESTION 102 You are working on an instance Read more [...]
EnsurepassQUESTION 91 Which two statements are true regarding undo tablespaces? (Choose two.)   A.      The database can have more than one undo tablespace. B.      The UNDO_TABLESPACE parameter is valid in both automatic and manual undo management. C.      Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions. D.      An Read more [...]
EnsurepassQUESTION 81 You used the IMMEDIATE option to shutdown your database instance. Consider the steps that will be performed later when you open the database:   1.       SGA is allocated. 2.       Control file is read. 3.       Redo log files are read. 4.       Instance recovery is started. 5.       Background processes are started. Read more [...]
EnsurepassQUESTION 71 Which two statements are true regarding listeners? (Choose two.)   A.      Listeners use only the TCP/IP protocol. B.      Multiple listener processes can run simultaneously on a host. C.      Multiple database instances can be registered with a single listener. D.      The listener-related errors can be traced only at the administrative level. E.       Read more [...]