Which SQL Statement creates a new empty datafile in place of an old on – McqOptions

MCQOPTIONS

1.	Which SQL Statement creates a new empty datafile in place of an old one-useful to re-create a datafile that was lost with no backup?
A.	ALTER DATABASE...CREATE DATAFILE
B.	CREATE DATABASE
C.	ALTER TABLESPACE...ADD TEMPFILE
D.	CREATE TEMPORARY TABLESPACE
Answer» B. CREATE DATABASE

Discussion

No Comment Found

Related MCQs

The value of which is the minimum size of the increments added to the file when it extends?
Which DBMS_STORAGE_MAP package procedure enables you to build the mapping information for the database object identified by object name, owner, and type?
Your database is running in the ARCHIVELOG mode. You placed a tablespace tbs_1, offline with the immediate option. Which statement is correct in this scenario?
You executed the STARTUP MOUNT command to start your database, for which database Operation do you need to start the database in the MOUNT state?
The DROP DATABASE statement deletes all control files and all other database files listed in the control file, to use the DROP DATABASE statement successfully, which conditions must apply?
What are the implications if your test database is running in a NOARCHIVELOG mode?
Which SQL Statement creates a new empty datafile in place of an old one-useful to re-create a datafile that was lost with no backup?
In mapping structure what describes the link between an element and the next elements in the I/O mapping stack?
What is used by Oracle during Table and Index creation and for sorting?
Which statement we used for manually increasing or decreasing the size of a datafile?