Automatic Storage Management MCQ

1. A _____ is a type of an intentional computer and network threat.

2. 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?

3. 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?

4. Which file allows a no default parameter file to be used to configure the Instance?

5. Which DBA System Privilege used for the operations authorized for drops a table in any schema?

6. 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?

7. A database that uses Automatic Storage Management (ASM) usually has a non-default SPFILE?

8. Abbreviate the term CSS?

9. 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?

10. Which statements about Automatic Storage Management (ASM) are true?

11. 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?

12. 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?

13. Which User System Privilege used for this operation authorized to connect to the database?

14. You analyze a schema object (table, index, or cluster) to?

15. 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?

16. 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?

17. 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?

18. 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

19. 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?