Thursday, June 7, 2012

Exam Oracle 10g Administration2




1.Which underlying database technology is used by flashback table, and Flashback version query to recovery data?
            A. Redo logs
            B. Rollback segments
            C. Undo data
            D. Archive logs
Ans: c

2. What action does  the Flashback Drop process perform?
            A. Back up table only
            B. Back up table and indexes only
            C. Back up table and referential constraints only
            D. Back up table and dependent objects
Ans: d

3. One method of dropping objects and bypassing the Recycle bin is to perform which command?
            A. DROP USER user CASCADE
            B. DROP TABLE
            C. DROP TABLE INCLUDING CONTENTS
            D. DROP USER user
Ans:a

4. Which command is responsible for removing the objects in multiple users from the recycle bin?
            A. PURGE RECYCLEBIN
            B. PURGE TABLESPACE user
            C. PURGE DBA_RECYCLEBIN
            D. PURGE TABLE user
Ans: c

5. What is the naming convention of a Recycle Bin object?
            A. BIN$globalUID$version
            B. BIN$global$UIDversion
            C. BIN$globalUIDversion
            D. BINglobalUIDversion
Ans:a

6. What two methods can be used to view the Recycle Bin
            A. Run the SHOW RECYCLEBIN command.
            B. Query the view DBA_RECYCLEBIN.
            C.Query the view V$RECYCLEBIN
            D. Query the view RECYCLEBIN.
Ans: ad

7. What view can be used to query diagnostic information about transactional changes in the database?
            A. FLASHBACK_TRANSACTION_QUERY
            B. DBA_TRANSACTION_QUERY
            C. V$TRANSACTION_QUERY
            D. V$FLASHBACK_TRANSACTION_QUERY
Ans: a

8.Which pseudocolumn do you use to identify a unique row in a Flashback Version Query?
            A. VERSIONS_XID
            B. BVERSIONS_OPERATION
            C. VERSIONS_ENDTIME
            D. VERSION_STARTTIME
Ans: a

9. How can you protect the amount of time you can query information from the Flashback Transaction Query?
            A. Add UNDO GUARANTEE to the UNDO tablespace.
            B. Add RETENTION GUARANTEE to the UNDO tablespace.
            C. Add RETENTION GUARANTEE to the Recycle Bin logical storage container.
            D. Add UNDO GUARANTEE to the Recycle Bin logical storage container.
Ans: b

10. Which of  the following are type of problems that the ADDM will consider?(Choose all the apply)
            A. Database configuration issues
            B. Concurrency issues
            C. CPU bottlenecks
            D. Suboptimal use of Oracle by an application
            E. All of the above
Ans: e

11. The statistical data needed for ADDM to accurately diagnose problems is stroed in which of the following areas?
            A. Automatic Workload Repository(AWR)
            B. Data dictionary
            C. ADDM repository
            D. PERFSTAT table
            E. None of the above
Ans:a

12. The AWR  resides in which tablespace?
            A. SYSTEM.
            B. TOOLS
            C. SYSAUX
            D. AWR
            E. None of the above
Ans: c

13. Which view shows the current AWR settings?
            A. DBA_AWR_SETTINGS
            B. DBA_AWR_CONFIG
            C. DBA_HIST_WR_CONTROL
            D. DBA_HIST_WR_SETTINGS
            E. DBA_REPOSITORY
Ans: c

14. Extents in an ASM file are allocated in units of which size?
            A. 100KB
            B. 10MB
            C. 1MB
            D. 64KB
Ans:c

15. Which initialization parameter in an ASM instance specifies the disk group to be automatically mounted at instance startup?
            A. ASM_DISKMOUNT
            B. ASM_DISKGROUP
            C. ASM_DISKSTRING
            D. ASM_MOUNTGROUP
Ans: b

16. Which of the following command options is not valid for  an ASM instance?
            A. STARTUP OPEN
            B. STARTUP NOMUNT
            C. STARTUP MOUNT
            D. STARTUP OPEN RESTRICT
            E. SHUTDOWN ABORT
Ans: a

17. To prevent connections to an ASM instance, you can use which of the following commands?
            A. ALTER SYSTEM ENABLE RESTRICTED SESSION
            B. SHUTDOWN IMMEDIATE
            C. ALTER SYSTEM DISABLE CONNECTIONS
            D. ALTER DATABASE ENABLE RESTRICTED SESSION
Ans: a

18. Which an ASM instance receives a SHUTDOWN NORMAL command, what command does it pass on to all database instances that rely on the ASM instance’s disk grougs?
            A. TRANSACTIONAL
            B. IMMEDIATE
            C. ABORT
            D. NORMAL
            E. None of the above
Ans: d

19. When creating a disk group, what keyword must be specified if you need to reuse a disk that has previously been used as part of another disk group?
            A. NOFORCE
            B. REUSE
            C. USE
            D. FORCE
            E. INCLUDING CONTENTS
Ans: d

20. Which type of database file is spread across all disks in a disk group?
            A. All types of files are spread across all disks in the disk group
            B. Datafiles
            C. Redo log files
            D. Archived redo log files
            E. Control files
Ans: a

No comments:

Post a Comment