READ Free Dumps For Oracle- 1z0-052

Question ID 21874	Examine the commands executed in a DBA session: 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.)
Option A	No more data files can be added to the tablespace.
Option B	Segment space is managed by free lists in the tablespace.
Option C	A user created without being assigned a default tablespace uses this tablespace.
Option D	The tablespace can be dropped with the current setting with segments present in it.
Correct Answer	A,C

Explanation

Question ID 21875	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.)
Option A	The online redo log files and online data files are opened
Option B	All the online data files headers are checked for consistency
Option C	Instance recovery is performed before opening the database
Option D	The path and existence of all the log file members are checked
Correct Answer	A,B

Explanation

Previous-Page 1 2... 7 8 9 10 11 12 13 14 15 Next-Page

Send email to admin@getfreedumps for new dumps request!!!