OCA Oracle Database 10g Administrator I-1Z0-042 & II-1Z0-043 Set 3

Which of the following could be found in the alert log?


Options are :

  • Evidence of a brute force attack against the listener
  • Tablespace creation events
  • External procedure executions
  • None of the above

Answer : Tablespace creation events

The following initialization parameters are set on your database instance:
DB_NAME=LNX1 SQL_TRACE=FALSE BACKGROUND_DUMP_DEST=/data1/admin/lnx1/bdump USER_DUMP_DEST=/data1/admin/lnx1/udump TRACEFILE_IDENTIFIER='prod'
An archiver (ARCH) process encounters an error situation. Its process ID is 32123. Which of the following is true?


Options are :

  • The trace file /data1/admin/lnx1/bdump/lnx1_arch_32123.trc will be created
  • The trace file /data1/admin/lnx1/bdump/arch_lnx1_32123_prod.trc will be created.
  • The trace file /data1/admin/lnx1/udump/arch_lnx1_32123.trc will be created.
  • The trace file /data1/admin/lnx1/bdump/lnx1_arch_32123_prod.trc will be created.
  • No trace file will be created.

Answer : The trace file /data1/admin/lnx1/bdump/arch_lnx1_32123_prod.trc will be created.

ASMM cannot be started on your instance. What might be the reason?


Options are :

  • The shared pool is sized larger than the database buffer cache size.
  • An invalid sizing parameter is specified.
  • The DB_KEEP_CACHE_SIZE parameter is not expressed as a power of 2.
  • The STATISTICS_LEVEL parameter is set to BASIC.
  • The ASMM option is not installed.

Answer : The STATISTICS_LEVEL parameter is set to BASIC.

1Z0-516 Oracle EBS R12.1 General Ledger Essentials Exam Set 3

Dirty blocks in the database buffer cache are tracked by which component?


Options are :

  • Dirty block list
  • Dirty list
  • Write list
  • Block list
  • LRU list

Answer : Write list

The following parameters are set in your instance:
SGA_TARGET=3G
HASH_AREA_SIZE=100M
SORT_AREA_SIZE=100M
WORKAREA_SIZE_POLICY=AUTO
PGA_AGGREGATE_TARGET=600M
A user session executes a SQL statement that performs a large sort operation. What can be determined from these settings? 


Options are :

  • The *_AREA_SIZE parameters will be ignored.
  • The operation will be allocated a minimum of 100MB.
  • The *_AREA_SIZE parameters will not be ignored.
  • The operation will be allocated 100MB.

Answer : The *_AREA_SIZE parameters will be ignored.

What is the process to recover a control file?


Options are :

  • Start up nomount, restore control file, start up mount the database, recover the database, and open the database.
  • Start up database, restore control file, start up mount the database, recover the database, and open the database.
  • Start up force, restore control file, start up the database, recover the database, and open the database.
  • Start up mount, restore control file, start up the database, recover the database, and open the database.

Answer : Start up nomount, restore control file, start up mount the database, recover the database, and open the database.

1Z1-574 Oracle IT Architecture Essentials Practice Exam Set 2

When recovering a control file without the recovery catalog, what special step must be performed to identify the target database? 


Options are :

  • None of the above
  • You must STARTUP MOUNT the database because the control file is missing.
  • You must CONNECT TARGET / to the target database within RMAN.
  • You must CONNECT TARGET database name to the target database within RMAN

Answer : You must CONNECT TARGET / to the target database within RMAN.

You notice that a lot of disk space is being used up on one of your mount points. Upon investigating, you find that SQL tracing is turned on for the instance. You issue an ALTER SYSTEM statement to turn it off. In an SPFILE environment, how can you determine if it was turned on at startup or if it was turned on using an ALTER SYSTEM statement? Select the best answer.


Options are :

  • System log
  • User process trace file
  • Background process trace file
  • init.ora file
  • Alert log

Answer : Alert log

Your instance does not have a value set for the PGA_AGGREGATE_TARGET initialization parameter. The server has 8GB of memory and the SGA is using 4GB. Which of the following statements is true regarding APMM for this instance?


Options are :

  • It will not be enabled.
  • It will always use the *_AREA_SIZE parameters.
  • It will dynamically allocate unused SGA memory.
  • It will use the default size of 800MB.
  • It will use the default size of 10MB.

Answer : It will use the default size of 800MB.

1Z0-520 Oracle EBS R12.1 Purchasing Essentials Practice Test Set 8

You need to secure your listener. Which of the following is not a recommended security measure?


Options are :

  • Configure listener on a non-standard port.
  • Apply patches.
  • Remove unnecessary external procedure services.
  • Enable Listener logging.
  • Block SQL*NET traffic on firewalls.

Answer : Configure listener on a non-standard port.

What command is responsible for automating the backup of control files?


Options are :

  • CONFIGURE CONTROLFILE AUTOBACKUP ON
  • ALTER DATABASE CONTROLFILE AUTOBACKUP ON
  • ENABLE CONTROLFILE AUTOBACKUP
  • ALTER SYSTEM CONTROLFILE AUTOBACKUP ON

Answer : CONFIGURE CONTROLFILE AUTOBACKUP ON

While performing routine management tasks on your database, you discover a high concentration of ORA-01169 messages in the listener log. What might be the cause?


Options are :

  • The database is down.
  • Mismatched parentheses in the listener.ora file.
  • A brute force password attack has been attempted.
  • Valid node checking has denied connection requests based on their host addresses.
  • Invalid setting in the sqlnet.ora file.
  • None

Answer : A brute force password attack has been attempted.

1Z0-497 Oracle Database 12c Essentials Certification Exam Set 2

Your junior DBA accidentally deleted the alert log file. How do you ensure that Oracle will continue to function? Choose the best answer.


Options are :

  • Create a new alert log file using EM Database Control.
  • Restore the most recent backup.
  • Create a new alert log file using the ALTER SYSTEM statement.
  • Do nothing.
  • Shut down the instance. A new file will be created on startup.

Answer : Do nothing.

After you restore the control file, what must you do before you execute the RECOVER command to apply archive logs?


Options are :

  • The database must be restored with the RESTORE command.
  • The database must be reconnected with the CONNECT TARGET database name command.
  • The database must open for use with ALTER DATABASE OPEN command.
  • The database must be started in MOUNT mode.

Answer : The database must be started in MOUNT mode.

You execute a Java stored procedure consisting of a single SQL statement using a large hash-join operation and a large sort operation. Which memory structure will have the most impact on your performance?


Options are :

  • SQL work area
  • Private SQL area
  • Java pool
  • Shared pool
  • Shared SQL area

Answer : SQL work area

Oracle 1Z0-516 EBS R12 General Essential Practice Exam Set 10

Which allocation unit is the smallest?


Options are :

  • Datafile
  • Segment
  • Data block
  • Extent

Answer : Data block

Oracle 1Z0-207 Billing & Revenue Mgmt Pricing Practice Exam Set 4

Which of the following is not a valid Oracle10g datatype?


Options are :

  • timestamp with local timezone
  • urowid
  • blob
  • binary

Answer : binary

You want to gather information about users connected via Shared Server connections. Which of the following is the view that contains this information?


Options are :

  • V$SESS_STATS
  • V$QUEUE
  • None of the above
  • V$USERS
  • V$CIRCUIT

Answer : V$CIRCUIT

Which statement on views is true?


Options are :

  • A view cannot be created with the same name and columns as the base table.
  • Inserts into a view are not allowed.
  • Privileges on a view can be different from those on the base table.
  • A view can only be on one base table, although that base table can be joined to itself.

Answer : Privileges on a view can be different from those on the base table.

1Z0-982 Oracle Enterprise Planning and Budgeting Cloud Test Set 1

Dispatchers have all the following characteristics except:


Options are :

  • Dispatchers can be shared by many connections.
  • Each dispatcher has its own response queue.
  • A dispatcher can listen for multiple protocols.
  • More dispatchers can be added dynamically with the ALTER SYSTEM command.

Answer : A dispatcher can listen for multiple protocols.

When you are configuring Shared Server, which initialization parameter would you likely need to modify?


Options are :

  • DB_CACHE_SIZE
  • None of the above
  • BUFFER_SIZE
  • DB_BLOCK_BUFFERS
  • LARGE_POOL_SIZE

Answer : LARGE_POOL_SIZE

You want to gather performance and tuning-related information for the shared server processes. You should start by querying which of the following views?


Options are :

  • V$SESS_STATS
  • V$USERS
  • V$SHARED_SERVER_MONITOR
  • V$CIRCUIT

Answer : V$SHARED_SERVER_MONITOR

1Z0-517 Oracle EBS R12.1 Payables Essentials Practice Exam Set 3

Which of the statements is true regarding the table created with the following SQL statement?
CREATE TABLE autos
(vin VARCHAR2(64) primary key
,style VARCHAR2(15) default 'TUDOR'
,year char(4)
,make varchar2(12)
,model varchar2(30)
);


Options are :

  • There is no index on this table.
  • The column style can have a NULL value.
  • The column style will always have a value.
  • MAKE is a reserved word; the CREATE TABLE will fail.

Answer : The column style can have a NULL value.

The administrator wants to allow a user to connect via a dedicated connection into a database configured in Shared Server mode. Which of the following lines accomplishes this?


Options are :

  • (MULTITRHEADED=FALSE)
  • (CONNECT=DEDICATED)
  • (INSTANCE=DEDICATED)
  • None of the above
  • (SERVER=DEDICATED)

Answer : (SERVER=DEDICATED)

Which of the following is false about shared servers?


Options are :

  • Shared servers receive their requests directly from dispatchers.
  • Shared servers place completed requests on a dispatcher response queue.
  • The SHARED_SERVERS parameter configures the number of shared servers to start at instance startup.
  • Shared servers can process requests from many users.

Answer : Shared servers receive their requests directly from dispatchers.

OCA Oracle Database 11g Administrator Certified Associate Set 3

Which operation can you not do to a table that is created with the following SQL statement?
CREATE TABLE properties
("Location" NUMBER primary key
,value NUMBER(15)
,lot varchar2(12)
,constraint positive_value check
(value > 0)
);


Options are :

  • Insert a null into the value column.
  • None of the above.
  • Rename the primary key to properties.
  • Rename the index supporting primary key to properties.
  • Add a column named owner.

Answer : None of the above.

Which command can you execute to get details about the number of sessions connected via Shared Server?


Options are :

  • lsnrctl conn
  • lsnrctl services
  • lsnrctl sessions
  • lsnrctl status

Answer : lsnrctl services

How do you specify that a temporary table will be emptied at the end of a user's session?


Options are :

  • Create the temporary table with the ON COMMIT DELETE ROWS option.
  • Create the temporary table with the ON DISCONNECT PRESERVE ROWS option.
  • Create the temporary table with the ON DISCONNECT PURGE ROWS option.
  • Create the temporary table with the ON COMMIT PRESERVE ROWS option.

Answer : Create the temporary table with the ON COMMIT PRESERVE ROWS option.

Oracle 1Z0-516 EBS R12 General Essential Practice Exam Set 8

Which constraint-checking model is the default?


Options are :

  • Initially immediate and deferrable
  • Initially deferred and not immediately
  • Initially immediate and not deferrable
  • Initially deferrable and not immediate

Answer : Initially immediate and not deferrable

Which of the following is false about request queues?


Options are :

  • The shared server processes remove requests from the request queue.
  • They reside in the SGA.
  • Each dispatcher has its own request queue.
  • They are shared by all the dispatchers.

Answer : Each dispatcher has its own request queue.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions