Oracle Review 1

Front 1

You are using Automatic Shared Memory Management (ASMM). Which initialization parameters are manually tuned, leaving the memory available for the automatically tuned parameters? (Choose all that apply.)

Back 1

LOG_BUFFER

DB_nk_CACHE_SIZE

DB_KEEP_CACHE_SIZE

DB_RECYCLE_CACHE_SIZE

Front 2

After changing some parameters in your initialization parameter file, you start the database in the NOMOUNT state using the following command: SQL> STARTUP NOMOUNT;After this, you want to enable redo archiving, so you issue the following statement to mount the database: SQL> ALTER DATABASE MOUNT;The database fails to mount. Which condition could be the reason for the failure?

Back 2

The control file in the database cannot be accessed.

Front 3

You are using an SPFILE to start the database. The maximum number of users in your database has been set to 150. Because the number of users has already reached the maximum limit, you are not able to create more users. Which statement should you issue to increase the maximum number of users the DBA can create in this database without affecting users who are currently connected to the database?

Back 3

ALTER SYSTEM SET LICENSE_MAX_USERS=200;

Front 4

You issue the following statement: ALTER SYSTEM SET UNDO_TABLESPACE='UNDOTEMP' SCOPE=SPFILE;Which statement about the result of executing this statement is true?

Back 4

The change will be persistent across instance shutdown and startup.

Front 5

While starting your database, you receive an error stating that the database cannot identify one of the online redo log files in it. At which stage will you receive this error?

Back 5

when the database changes from the MOUNT state to the OPEN state

Front 6

You are using an SPFILE to start the database. Which two initialization parameters are static and cannot be modified without shutting down the instance? (Choose two.)

Back 6

LOG_BUFFER

DB_BLOCK_SIZE

Front 7

Which view will you query to display the PFILE information currently in effect for a database that was started by using the initialization parameter file?

Back 7

V$PARAMETER

Front 8

You have created a listener by using Database Control. After configuring the listener for your database, you started a new SQL*Plus session and attempted to connect to the database using the credentials of user scott with a password of tiger.Enter user-name: scott/tiger@11gWhile executing the command, you received the following error message: ORA-12154: TNS:could not resolve the connect identifier specified.

Back 8

The connect identifier supplied does not exist in the tnsnames.ora file.

Front 9

You have created a listener by using Database Control and configured a listener named LSR2. Later, you issued the following command: SQLPLUS scott/tiger@11gWhile executing this command, you received the following error message: ORA-12541: TNS:no listener.

Back 9

A listener does not exist in the Oracle database.

Front 10

You want to know the uptime duration of your default listener. Which command-line command can you use to determine the uptime duration of the default listener?

Back 10

lsnrctl status

Front 11

Your database server is running in shared server mode. Which component is a component of the Program Global Area (PGA) when the database is in shared server mode?

Back 11

stack space

Front 12

You are running your Oracle 11g database in shared server mode. You notice that a particular user session is allocating a large portion of the SGA. You want to restrict the amount of User Global Area (UGA) memory the session can allocate.

Back 12

Modify the user's profile to set the PRIVATE_SGA resource limit.

Front 13

You are a database administrator in your company working on the ADMIN database. There are 25 users in the office who must access this database by using the TCP/IP protocol. You must configure the database so that these users can access the database from their local computers. You are using Database Control to configure the naming methods. Configuring which naming method would involve the least administrative overhead in this scenario?

Back 13

Easy Connect naming method

Front 14

Which statement represents a characteristic of connection pooling in a shared server configuration?

Back 14

Idle connections can be reused and allow a larger number of users.