Download Oracle.1z0-052.PracticeTest.2019-02-05.166q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-052 |
| Exam Name: | Oracle Database 11g: Administration I |
| Date: | Feb 05, 2019 |
| File Size: | 6 MB |
| Downloads: | 2 |
Demo Questions
Question 1
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 2
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
Question 3
After performing a clean shut down of the database instance for maintenance, you mount the database and then execute a command to open the database:
SQL> ALTER DATABASE OPEN;
Which two statements are true? (Choose two.)
- The online redo log files and online data files are opened.
- All the online data files headers are checked for consistency.
- Instance recovery is performed before opening the database.
- The path and existence of all the log file members are checked.
Correct answer: AB
