File Info
| Exam | Oracle Database 11g: Administration I |
| Number | 1z0-052 |
| File Name | Oracle.1z0-052.PracticeTest.2019-02-05.166q.tqb |
| Size | 6 MB |
| Posted | Feb 05, 2019 |
| Download | Oracle.1z0-052.PracticeTest.2019-02-05.166q.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
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
