1z0-052 DUMPS

Latest Oracle 1Z0-052 Real Exam Download 181-190

By on August 21, 2013
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 [...]

Continue Reading

1z0-052 DUMPS

Latest Oracle 1Z0-052 Real Exam Download 171-180

By on
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 [...]

Continue Reading

1z0-052 DUMPS

Latest Oracle 1Z0-052 Real Exam Download 161-170

By on
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 [...]

Continue Reading

1z0-052 DUMPS

Latest Oracle 1Z0-052 Real Exam Download 151-160

By on
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 [...]

Continue Reading

1z0-052 DUMPS

Latest Oracle 1Z0-052 Real Exam Download 141-150

By on
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 [...]

Continue Reading

1z0-052 DUMPS

Latest Oracle 1Z0-052 Real Exam Download 131-140

By on
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 [...]

Continue Reading

1z0-052 DUMPS

Latest Oracle 1Z0-052 Real Exam Download 121-130

By on
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 [...]

Continue Reading

1z0-052 DUMPS

Latest Oracle 1Z0-052 Real Exam Download 111-120

By on
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 [...]

Continue Reading

1z0-052 DUMPS

Latest Oracle 1Z0-052 Real Exam Download 101-110

By on
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 [...]

Continue Reading

1z0-052 DUMPS

Latest Oracle 1Z0-052 Real Exam Download 91-100

By on
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 [...]

Continue Reading