Automatic Storage Management MCQs
Automatic Storage Management MCQs
Answer these 10+ Automatic Storage Management MCQs and assess your grip on the subject of Automatic Storage Management.
Scroll below and get started!
1: In your Automatic Storage Management (ASM) instance, one of the nonempty disk groups,DGROUP1, is no longer required and you want this disk group to be removed.You execute the following command to achieve this objective. (DROP DISKGROUP dgroup1 EXCLUDING CONTENTS;). What would be the result of this command?
A. The command would result in the contents being moved to the parent disk group and dropping of the disk group
B. This command would result in an error because the disk group is not empty
C. The command would result in the disk group being marked as INVALID because it cannot be dropped
D. The command would drop the disk group, ignoring the EXCLUDING CONTENTS option
2: In Creating ASM Files Using a Default Disk Group Specification Which initialization Parameter Specifies the default disk group location in which to create? 1) Redo log files. 2) Control files
A. DB_RECOVERY_FILE_DEST
B. DB_CREATE_FILE_DEST
C. CONTROL_FILES
D. DB_CREATE_ONLINE_LOG_DEST_n
3: The CREATE SCHEMA statement is useful if you want to guarantee the creation of several tables, views, and grants in one operation it can include?
A. GRANT
B. CREATE VIEW
C. All mentioned
D. CREATE TABLE
4: You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective?
A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0 & Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0
B. Set the ASM compatibility attribute for the ASM disk group to 11.1.0
C. Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0
D. Set the ASM compatibility attribute for the ASM disk group to 11.1.0 & Set the COMPATIBLE initialization parameter for the database instance to 11.1.0
E. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0
F. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0
5: The V$ASM_DISKGROUP view contains columns that help you manage capacity which indicates the amount of free space, adjusted for mirroring, that is available for new files?
A. Both REQUIRED_MIRROR_FREE_MB & USABLE_FILE_MB
B. USABLE_FILE_MB
C. REQUIRED_MIRROR_FREE_MB
D. None of these
6: You analyze a schema object (table, index, or cluster) to?
A. Does not verify the validity of its storage format
B. None of these
C. UnIdentify migrated and chained rows of a table or cluster
D. No need to Collect and manage statistics for it
7: Which User System Privilege used for this operation authorized to connect to the database?
A. CREATE SEQUENCE
B. CREATE SESSION
C. CREATE VIEW
D. CREATE TABLE
8: In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?
A. Oracle Migration Assistant
B. Conventional Oracle Export and Import
C. Oracle Data Pump Export and Import
D. Recovery Manager (RMAN)
9: The disks in a disk group are referred to as ASM disks, On Windows operating systems, an ASM disk is always a partition, on all other platforms, an ASM disk can be?
A. A network-attached file
B. None of these
C. A partition of a logical unit number (LUN) & A network-attached file
D. A partition of a logical unit number (LUN)
10: Which statements about Automatic Storage Management (ASM) are true?
A. ASM provides mirroring on file by file basis & ASM provides automatic load balancing across all ASM disks
B. ASM provides automatic load balancing across all ASM disks
C. ASM can be used to store trace files, alert log files, and the server parameter file (SPFILE)
D. ASM provides mirroring on file by file basis
E. ASM supports the Oracle database and operating system files
F. ASM supports the Oracle database and operating system files & ASM can be used to store trace files, alert log files, and the server parameter file (SPFILE)
11: On Tuesday, a junior DBA dropped an important application user account, whose schema has important tables. You are asked to recover all the objects in the schema. On investigation, you find that the user account was dropped at 11:00 a.m. and Sunday's backup is the most recent backup. Which flashback feature would you use?
A. Flashback Drop
B. Flashback Table
C. Flashback Transaction Query
D. Flashback Version Query
E. Flashback Database
12: Abbreviate the term CSS?
A. Command Synchronization Statement
B. Command Synchronization Services
C. Cluster Synchonization Services
D. Cluster Synchronization Statement
13: A database that uses Automatic Storage Management (ASM) usually has a non-default SPFILE?
A. True
B. False
14: ASM does not discover a disk that contains an operating system partition table, even if the disk is in an ASM_DISKSTRING search path and ASM has read/write permission on the disk?
A. False
B. True
15: Which DBA System Privilege used for the operations authorized for drops a table in any schema?
A. CREATE USER
B. DROP ANY TABLE
C. DROP USER
D. BACKUP ANY TABLE
16: Which file allows a no default parameter file to be used to configure the Instance?
A. PFILE
B. SPFILE & PFILE
C. None of these
D. Spfile
17: You can delete all rows of a table or all rows in a group of clustered tables so that the table (or cluster) still exists, but is completely empty?
A. Use the DROP and CREATE statements
B. All mentioned
C. Use the TRUNCATE statement
D. Use the DELETE statement
18: In Viewing Information About Automatic Storage Management which view in an ASM instance, contains one row for every ASM file in every disk group mounted by the ASM instance, In a DB instance, contains no rows?
A. V$ASM_FILE
B. V$ASM_DISK_STAT
C. V$ASM_DISKGROUP_STAT
D. V$ASM_DISK
19: A _____ is a type of an intentional computer and network threat.
A. Latch
B. Proxy server.
C. Backdoor
List of Automatic Storage Mana...
Available in:
Automatic Storage Management MCQs
