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 [...]
EnsurepassQUESTION 61 Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance. What would be your next step to improve performance?   A.      Run the SQL Access Advisor. B.      Run the memory Advisor for the SGA. C.      Run the memory Advisor for the Read more [...]
EnsurepassQUESTION 51 Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command:   LSNRCTL> STOP   What happens to the sessions that are presently connected to the database instance?   A.      The sessions are able to perform only queries B.      The sessions are not affected and continue to function normally C.      The sessions Read more [...]
EnsurepassQUESTION 41 SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command?   A.      One audit record is created for every successful DROP TABLE command executed in the session of SCOTT. B.      One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users. C.      One audit record is created for the whole session if Read more [...]
EnsurepassQUESTION 31 Which two statements are true about alerts? (Choose two.)   A.      Clearing an alert sends the alert to the alert history. B.      Response actions cannot be specified with server-generated alerts. C.      The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS view. D.      Server-generated alerts notify the problems that cannot be resolved automatically and Read more [...]
EnsurepassQUESTION 21 View the Exhibit and examine the privileges granted to the MGR_ROLE role.   The user SKD has been granted the CONNECT and RESOURCE roles only. The database administrator (DBA) grants MGR_ROLE to the user SKD by executing the command:   SQL> GRANT MGR_ROLE TO SKD WITH ADMIN OPTION;   Which statement is true about the user SKD after he/she is granted this role?     A.      The user SKD can grant only the MGR_ROLE Read more [...]
EnsurepassQUESTION 1 You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue? (Choose two.)   A.      Disable automatic checkpoint tuning. B.      Check the size of the redo log file size and increase the size if it is small. C.      Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor. D.      Read more [...]