Download Oracle Database 11g: Administration I.1z0-052.Pass4Sure.2018-12-27.167q.tqb

Vendor: Oracle
Exam Code: 1z0-052
Exam Name: Oracle Database 11g: Administration I
Date: Dec 27, 2018
File Size: 6 MB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
You executed the following command to create a password file in the database server:
$ orapwd file = orapworcl entries = 5 ignorecase=N 
Which statement describes the purpose of the above password file? 
  1. It records usernames and passwords of users when granted the DBA role
  2. It contains usernames and passwords of users for whom auditing is enabled
  3. It is used by Oracle to authenticate users for remote database administrator
  4. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups
Correct answer: C
Question 2
SQL> CREATE BIGFILE TABLESPACE MRKT 
2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING 
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; 
Tablespace created. 
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT; 
Database altered. 
Which two statements are true regarding the MRKT tablespace? (Choose two.)
  1. No more data files can be added to the tablespace.
  2. Segment space is managed by free lists in the tablespace.
  3. A user created without being assigned a default tablespace uses this tablespace. 
  4. The tablespace can be dropped with the current setting with segments present in it.
Correct answer: AC
Question 3
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? 
Exhibit:
  
  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
Correct answer: A
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!