Oracle Database 11g Essentials

Document Sample
Oracle Database 11g Essentials Powered By Docstoc
					 Oracle •1Z0-514
Oracle Database 11g Essentials

                  Click the link below to buy full version as Low as $39


              Questions & Answers: 07
                                         Question: 1
The DBA of your database informs you that the Oracle instance has started.

A. Users can access the data in the database.
B. Only the SGA has been allocated for the database.
C. Only the Background and user Processes are running.
D. Memory areas have been allocated and background processes have been stared.

                                            Answer: D

                                        Question: 2
You issue the following command as a DBA:
What would be the outcome of the above command?

A. It causes the instance to abort.
B. It waits for all sessions to disconnect.
C. It rolls back the current transactions and disconnects all sessions.
D. It waits for the current transaction in each session to complete before disconnecting the sessions.

                                            Answer: B

                                        Question: 3
Which mode of database shutdown requires an instance recovery at the time of the database startup?


                                            Answer: A                                                            Page 2
                                       Question: 4
You want to Increase the number of SQL statements that are cached in memory. Which memory
structure size should be increased?

A. Large pool
B. Shared pool
C. Buffer Cache
D. Program Global Area

                                           Answer: B

                                       Question: 5
Your database instance in running.db01 is a net service name. You issue a connection request using the
following command:
SQL> CONNECT scottItigerdb01
Which component receives the request and establishes the appropriate connection?

A. listener
B. user process
C. service name
D. server process

                                           Answer: A

                                       Question: 6
Which two options describe the features of simple views? (Choose two.)
A. hide data complexity
B. improve data storage
C. provide additional level of security
D. speed up query and data manipulation language (DML) operations

                                         Answer: A, C                                                         Page 3
                                       Question: 7
Choose three areas for which Oracle Database 11 g Release 2 and Enterprise Manager offer tools that
can recommended solutions on optimal implementation.

A. Indexes
B. Compression
C. Data recovery
D. Data block size
E. CPU usage
F. Availability

                                       Answer: A, B, E                                                        Page 4
 Oracle •1Z0-514
Oracle Database 11g Essentials

             Click the link below to buy full version as Low as $39


   Oracle latest tests
   1Z0-899            1Z0-219
   1Z0-875            1Z0-562
   1Z0-557            1Z0-561
   1Z0-852            1Z0-543
   1Z0-058            1Z0-532
   1Z0-897            1Z0-895
   1Z0-889            1Z0-884
   1Z0-880            1Z0-879
   1Z0-877            1Z0-876
   1Z0-873            1Z0-872                               Page 5

Shared By: