Docstoc

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

                   http://www.examcertify.com/1Z0-514.html




              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:
SQL> SHUTDOWN
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?

A. ABORT
B. NORMAL
C. IMMEDIATE
D. TRANSACTIONAL


                                            Answer: A




http://www.examcertify.com/1Z0-514.html                                                            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


http://www.examcertify.com/1Z0-514.html                                                         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




http://www.examcertify.com/1Z0-514.html                                                        Page 4
 Oracle •1Z0-514
Oracle Database 11g Essentials




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

             http://www.examcertify.com/1Z0-514.html


   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




http://www.examcertify.com/1Z0-514.html                               Page 5

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:13
posted:5/2/2012
language:
pages:5