File Info
| Exam | Oracle Database 11g: Administration I |
| Number | 1z0-052 |
| File Name | Oracle.1z0-052.Pass4Sure.2018-12-27.167q.tqb |
| Size | 6 MB |
| Posted | Dec 27, 2018 |
| Download | Oracle.1z0-052.Pass4Sure.2018-12-27.167q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
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?
- It records usernames and passwords of users when granted the DBA role
- It contains usernames and passwords of users for whom auditing is enabled
- It is used by Oracle to authenticate users for remote database administrator
- 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.)
- No more data files can be added to the tablespace.
- Segment space is managed by free lists in the tablespace.
- A user created without being assigned a default tablespace uses this tablespace.
- 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:
- The user SKD can grant only the MGR_ROLE role to other users, but not the privileges in it
- The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor
- The user SKD can grant the privileges in the MGR_ROLE role to other users but not with ADMIN OPTION
- The user SKD can grant the privileges in the MGR_ROLE role to other users, but cannot revoke privileges from them
Correct answer: A
