Managing Data-files And Temp-files MCQs
Managing Data-files And Temp-files MCQs
These Managing Data-files And Temp-files multiple-choice questions and their answers will help you strengthen your grip on the subject of Managing Data-files And Temp-files. You can prepare for an upcoming exam or job interview with these Managing Data-files And Temp-files MCQs.
So scroll down and start answering.
1: Which statement we used for you can manually increase or decrease the size of a datafile?
A. ALTER TABLESPACE
B. ALTER DATABASE
C. CREATE DATABASE
D. CREATE TABLESPACE
2: In mapping structure which describes the link between an element and the next elements in the I/O mapping stack?
A. File Mapping
B. Elements Mapping
C. File System Extents Mapping
D. Subelements Mapping
3: In mapping structure describes the link between an element and the next elements in the I/O mapping stack?
A. File Mapping
B. Elements Mapping
C. File System Extents Mapping
D. Subelements Mapping
4: Which two statements are true about the roles in the Oracle database?
A. A role can be granted to itself
B. Roles can be granted to other roles
C. A role can contain both system and object privileges
D. Roles can be granted to other roles And A role can contain both system and object privileges
5: Which is Used by Oracle during Table and Index creation and for sorting?
A. Schemas
B. Indexes
C. Temporary Segments
D. Tables
6: 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?
A. The operation would fail if tbs_1 were the default tablespace for the database
B. The operation would fail if tbs_1 were a read/write tablespace
C. The operation would fail if tbs_1 were a read-only tablespace
D. If the above operation were successful, media recovery would be required to bring the Tablespace online
7: You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task?
A. REMAP_SCHEMA
B. Schemas
C. FULL
D. REMAP_DATAFILES
8: The DBMS_STORAGE_MAP package procedure enables you to build the mapping information for the database object identified by object name, owner, and type?
A. MAP_FILE
B. MAP_OBJECT
C. MAP_ALL
D. MAP_ELEMENT
9: An Oracle Instance consists of Processes and Memory Structures, Processes can be subdivided as follows?
A. Server
B. Background
C. User
D. All
10: Which can you use Recovery Manager (RMAN) to perform incremental backup?
A. Whole database
B. Data Files
C. All
D. Tablespaces
11: Which SQL Statement creates a new empty datafiles in place of an old one--useful to re-create a datafiles that was lost with no backup?
A. ALTER TABLESPACE...ADD TEMPFILE
B. REATE TEMPORARY TABLESPACE
C. ALTER DATABASE...CREATE DATAFILE
D. CREATE DATABASE
12: In oracle, dates have the format ____.
A. DD-MON-YYYY
B. MON-DD-YYYY
C. YYYY-MON-DD
D. None of these
List of Managing Data-files An...
Available in:
Managing Data-files And Temp-files MCQs
