Oracle Database 11g Essentials (1Z0-514) Free Practice Test

Question 1

Which three statements are true regarding an Oracle instance? (Choose three)

A. One instance is associated with only one database.

B. A database instance is created based on the information in the SPFILE file.

C. One instance can be associated with multiple databases.

D. A database instance is created based on the information in the control file.

E. Only one database instance can run on one computer.

F. Multiple database instances can run on one computer.

Correct Answer: A,B,F

Question 2

Your database instance is running. A user, SCOTT, starts a SQL*Plus session, and issues the following query;
SQL>SELECT *
FROM sales:
Which process would retrieve the result from the database and return it to the client program?

A. Checkpoint process (CKPT)

B. server process

C. Process Monitor (PMON)

D. user process

E. System Monitor (SMON)

Correct Answer: D

Question 3

You want to Increase the number of SQL statements that are cached in memory. Which memory structure size should be increased?

A. Shared pool

B. Large pool

C. Buffer Cache

D. Program Global Area

Correct Answer: A

Question 4

There are two listeners, LISTENER1 and LISTENER2, and one service name ORCL available for your database.The database is running and currently only LISTENERI has been started. You issue the following command:
$lsnrctl start listener2
What would be the outcome?

A. It would start the second listener and terminate all the current sessions.

B. It would give an error because multiple listeners can run simultaneously only if there are multiple net service names.

C. It would start the second listener without affecting the current sessions.

D. It would give an error because multiple listeners cannot run simultaneously.

Correct Answer: C

Question 5

Which statement is true regarding accessing the Enterprise Manager Database Control?

A. It can be accessed only it the Net service names have been configured in the server tnsnames.ora file.

B. It can be accessed Irrespective of whether the database instance shut down or running.

C. It can be accessed through a Web browser or command line.

D. It can beaccessed only it thedefault preset port number1158 is available.

Correct Answer: B

Question 6

Which two statements are true regarding Oracle Net? (Choose two.)

A. It must reside on both the client and database server for traditional client/server applications.

B. It must reside on both the web server and database server for web-based applications.

C. It must reside only on the client for traditional client/server applications.

D. It must reside only on the database server for web-based applications.

Correct Answer: A,B

Question 7

Which statement is true regarding Automatic Memory Management?

A. You need to specify the total memory size, which is dynamically sizedfor SGA and PGA components but cannot be exchanged between the SGA and PGA.

B. You need to specify the total memory size, which is dynamically sized forSGA and PGA components and can beexchanged between the SGA and PGA.

C. You need to specify only the SGA memory size.

D. You need to specify the SGA and PGA memory sizes separately.

Correct Answer: B

Welcome to TestSimulate

Oracle Database 11g Essentials (1Z0-514) Free Practice Test