1. A _____ is a type of an intentional computer and network threat.
Answer
Correct Answer:
Backdoor
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
V$ASM_FILE
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
All mentioned
Note: This Question is unanswered, help us to find answer for this one
4. Which file allows a no default parameter file to be used to configure the Instance?
Answer
Correct Answer:
SPFILE & PFILE
Note: This Question is unanswered, help us to find answer for this one
5. Which DBA System Privilege used for the operations authorized for drops a table in any schema?
Answer
Correct Answer:
DROP ANY TABLE
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
7. A database that uses Automatic Storage Management (ASM) usually has a non-default SPFILE?
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
8. Abbreviate the term CSS?
Answer
Correct Answer:
Cluster Synchonization Services
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
Flashback Drop
Note: This Question is unanswered, help us to find answer for this one
10. Which statements about Automatic Storage Management (ASM) are true?
Answer
Correct Answer:
ASM provides mirroring on file by file basis & ASM provides automatic load balancing across all ASM disks
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
A partition of a logical unit number (LUN) & A network-attached file
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
Oracle Migration Assistant
Note: This Question is unanswered, help us to find answer for this one
13. Which User System Privilege used for this operation authorized to connect to the database?
Answer
Correct Answer:
CREATE SESSION
Note: This Question is unanswered, help us to find answer for this one
14. You analyze a schema object (table, index, or cluster) to?
Answer
Correct Answer:
None of these
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
Both REQUIRED_MIRROR_FREE_MB & USABLE_FILE_MB
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
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
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
All mentioned
Note: This Question is unanswered, help us to find answer for this one
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
Answer
Correct Answer:
DB_CREATE_ONLINE_LOG_DEST_n
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
This command would result in an error because the disk group is not empty
Note: This Question is unanswered, help us to find answer for this one
