[Free] 2018(Jan) EnsurePass Pass4sure Oracle 1z0-052 Dumps with VCE and PDF 31-40

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-052
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-052.html

Oracle Database 11g: Administration I

Question No: 31 – (Topic 1)

Examine the following steps performed on a database instance:

  1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION

  2. The SKD user creates a table

  3. The SKD user grants the CREATE TABLE system privilege to the HR user

  4. The HR user creates a table

  5. The DBA revokes the CREATE TABLE system privilege from SKD Which statement is true after step 5 is performed?

    1. The table created by SKD is not accessible and SKD cannot create new tables

    2. The tables created by SKD and HR remain, but both cannot create new tables

    3. The table created by HR remains and HR still has the CREATE TABLE system privilege

    4. The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users

Answer: C

Question No: 32 – (Topic 1)

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.

What would you do to recover the data file?

  1. Take the USERS tablespace offline and re-create the lost data file

  2. Shutdown the instance, restore the data file from the last consistent backup and restart the database instance

  3. Shutdown the instance, restores all the database files from the last consistent backup and restart the database instance

  4. Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the last consistent backup and make the tablespace online

Answer: C

Question No: 33 – (Topic 1)

For which database operation would you need the database to be in the MOUNT state?

  1. Renaming the control files

  2. Re-creating the control files

  3. Dropping a user in your database

  4. Dropping a tablespace in your database

  5. Configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

Answer: E

Question No: 34 – (Topic 1)

In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?

  1. When the data file of the undo tablespace is autoextensible

  2. When there are more than one undo tablespace available in the database

  3. When the undo tablespace is of a fixed size and retention guarantee is not enabled

  4. When the undo tablespace is autoextensible and retention guarantee is not enabled

Answer: C

Question No: 35 – (Topic 1)

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:

SQLgt; GRANT MGR_ROLE TO SKD WITH ADMIN OPTION;

Which statement is true about the user SKD after he/she is granted this role? Exhibit:

Ensurepass 2018 PDF and VCE

  1. The user SKD can grant only the MGR_ROLE role to other users, but not the privileges in it

  2. The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor

  3. The user SKD can grant the privileges in the MGR_ROLE role to other users but not with ADMIN OPTION

  4. The user SKD can grant the privileges in the MGR_ROLE role to other users, but cannot revoke privileges from them

    Answer: A

    Question No: 36 – (Topic 1)

    Which statements listed below describe the data dictionary views?

    1. These are stored in the SYSTEM tablespace

    2. These are the based on the virtual tables

    3. These are owned by the SYS user

    4. These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBLILITY parameter is set to TRUE

    5. The V$FIXED_TABLE view can be queried to list the names of these views

      1. 1 and 3

      2. 2,3 and 5

      3. 1,2, and 5

D. 2,3,4 and 5

Answer: A

Question No: 37 – (Topic 1)

User A executes the following command to drop a large table in your database: SQLgt; DROP TABLE trans;

While the drop table operation is in progress; user B executes the following command on the same table;

SQLgt; DELETE FROM trans WHERE tr_type=#39;SL#39;;

Which statement is true regarding the DELETE command?

  1. It fails to delete the records because the records are locked in the SHARE mode

  2. It deletes the rows successfully because the table is locked in the SHARE mod

  3. It fails to delete the records because the table is locked in EXCLUSIVE mode

  4. It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode

Answer: C

Question No: 38 – (Topic 1)

You want to check the details of few errors that users have reported. You search for the

alert log file and execute few commands to find the location of the alert log file. View the Exhibit and check the commands executed.

Ensurepass 2018 PDF and VCE

What is the location of the alert_orcl.log file?

  1. ORACLE_HOME/dbs

  2. ORACEL_HOME/rdbms

  3. /u01/app/oracle/admin/orcl/adump

  4. /u01/app/oracle/flash_recovery_area

  5. ORACLE_BASE/diag/rdbms/orcl/alert

  6. ORACLE_BASE/diag/rdbms/orcl/orcl/trace

Answer: F

Question No: 39 – (Topic 1)

What can you achieve by implementing reverse key index?

  1. Reverse the bytes of each column indexed including the row ID

  2. Store a bitmap for each key value instead of a list of row IDs in the leaf node

  3. Prevent contention on the highest leaf block when using sequences to generate keys

  4. Remove repeated key values from the index to fit more index entries in a given amount of disk space

Answer: C

Question No: 40 – (Topic 1)

The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects.

Which statement is true in this scenario?

  1. The statistics collection continues until all objects are processed.

  2. The job is terminated and the statistics collected are restored to a time before the job started.

  3. This produces an error and the statistics collected are locked until the next time that the maintenance window is opened.

  4. The job is terminated and the statistics for the remaining objects are collected the next time that the maintenance window is opened.

Answer: D

100% Ensurepass Free Download!
Download Free Demo:1z0-052 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-052 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.