Download Oracle.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 |
| Downloads: | 1 |
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
