OCA Oracle 12C Administration (1Z0-062) Practice Test Set 1

What portion of the tnsnames.ora file specifies the name or IP address of the server where the listener process is listening?


Options are :

  • SERVER
  • CONNECT_DATA
  • HOST
  • SERVICE_NAME

Answer : HOST

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

Connection Manager provides which of the following?


Options are :

  • All of the above
  • Cross-protocol connectivity
  • Multiplexing
  • Network access control

Answer : All of the above

All of the following are reasons to configure the server using Shared Server except which one?


Options are :

  • Overall memory utilization is reduced.
  • The system is predominantly used for small transactions with many users.
  • The system is predominantly used for decision support with large result sets returned.
  • The number of idle connections on the server is reduced

Answer : The system is predominantly used for decision support with large result sets returned.

How would you add more space to a tablespace? 


Options are :

  • NOne
  • ALTER DATAFILE RESIZE
  • ALTER TABLESPACE ADD DATAFILE SIZE
  • ALTER DATAFILE RESIZE

Answer : ALTER TABLESPACE ADD DATAFILE SIZE

Oracle 12c SQL Certified Associate 1Z0-071 Real Exam 2019 Set 2

A client receives the following error message:
"ORA-12154 TNS:could not resolve the connect identifier specified"
Which of the following could be possible causes of the error? 


Options are :

  • NOne
  • The listener is not configured to listen for this service.
  • The listener is not running on the Oracle server.
  • The user entered an invalid net service name.

Answer : The user entered an invalid net service name.

Two transactions occur at the wall clock times in the following table. What happens at 10:05?


Options are :

  • Neither session is updating the same column, so no waiting or deadlock will occur.
  • A deadlock will occur, and both sessions will hang unless one of the users cancels their statement or the DBA kills one of the sessions
  • A deadlock will occur, and Oracle will cancel one of the statements.
  • Session 1 will wait for session 2 to commit or roll back.
  • Session 2 will wait for session 1 to commit or roll back.

Answer : A deadlock will occur, and Oracle will cancel one of the statements.

Guaranteed undo retention can be specified for which of the following objects?


Options are :

  • A table
  • A transaction
  • The database
  • The instance
  • A tablespace

Answer : A tablespace

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

A client wants to connect to the database service dbprod.com located on the dbprod.com server through a nondefault port (1522) using Oracle Easy Connect. Which of the following connect strings are the choices for the client to use?


Options are :

Answer : CONNECT scott/[email protected]:1522

Which of the following lock modes permits concurrent queries on a table but prohibits updates to the locked table?


Options are :

  • ROW SHARE
  • SHARE ROW EXCLUSIVE
  • All of the above
  • ROW EXCLUSIVE

Answer : SHARE ROW EXCLUSIVE

When dynamic service registration is used, you will not see the service listed in which of the following files where it would normally be located?


Options are :

  • sqlnet.ora
  • None of the above
  • listener.ora
  • tnsnames.ora

Answer : listener.ora

1Z0-521 Oracle E-Business Suite R12.1Oracle Order Managment Set 1

Which statements regarding Database Resident Connection Pooling (DRCP) are true? 


Options are :

  • None of the above
  • When using the Oracle Net Easy Connect method, it is not possible to utilize DRCP.
  • When a DRCP pooled server connection is made by an application, it is equivalent to a dedicated server connection.
  • When a database has DRCP enabled, all connections default to a pooled connection unless DEDICATED server is explicitly specified in the connect string.

Answer : When a DRCP pooled server connection is made by an application, it is equivalent to a dedicated server connection.

Which of the following files must be present on the Oracle server to start a nondefault Oracle listener?


Options are :

  • sqlnet.ora
  • tnsnames.ora
  • lsnrctl.ora
  • listener.ora

Answer : listener.ora

Changes made with an UPDATE statement in a transaction are permanent in the database and visible to other users after what occurs?


Options are :

  • You issue a SAVEPOINT statement
  • A checkpoint occurs.
  • DBWR flushes the changes to disk
  • You issue a COMMIT statement.

Answer : You issue a COMMIT statement.

1Z0-238 R12 Oracle Install,Patch & Maintain Oracle APP Test Set 5

If all extents in an undo segment fill up, which of the following occurs next?


Options are :

  • A new extent is allocated in the undo segment if all existing extents still contain active transaction data.
  • A new undo segment is created, and the transaction that filled up the undo segment is moved in its entirety to another undo segment.
  • Other transactions using the segment are moved to another existing segment with enough free space.
  • The transaction that filled up the undo segment spills over to another undo segment.

Answer : A new extent is allocated in the undo segment if all existing extents still contain active transaction data.

If the tablespace is offline, which statements should be executed to make the USERS tablespace read-only?


Options are :

  • ALTER TABLESPACE USERS TEMPORARY
  • None
  • ALTER TABLESPACE USERS READ ONLY
  • ALTER DATABASE MAKE TABLESPACE USERS READ ONLY

Answer : ALTER TABLESPACE USERS READ ONLY

Select the statement that is not true regarding undo tablespaces.


Options are :

  • Undo tablespaces will not be created if they are not specified in the CREATE DATABASE command.
  • Two undo tablespaces can be active if a new undo tablespace was specified and the old one contains pending transactions.
  • UNDO_MANAGEMENT cannot be changed dynamically while the instance is running.
  • You can switch from one undo tablespace to another while the database is online.

Answer : Undo tablespaces will not be created if they are not specified in the CREATE DATABASE command.

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

Which is a requirement for using host naming?


Options are :

  • You must use tnsnames.ora on the client.
  • You must have a sqlnet.ora file present on the client
  • None of the above.
  • You must be using TCP/IP.
  • You must have an OID present.

Answer : You must be using TCP/IP.

he database is using automatic memory management. The standard block size for the database is 8KB. You need to create a tablespace with a block size of 16KB. Which initialization parameter should be set?


Options are :

  • DB_8K_CACHE_SIZE
  • B. DB_16K_CACHE_SIZE
  • C. DB_CACHE_SIZE
  • D. None of the above

Answer : B. DB_16K_CACHE_SIZE

Which data dictionary view can be queried to obtain information about the files that belong to locally managed temporary tablespaces?


Options are :

  • DBA_TABLESPACES
  • DBA_LOCAL_FILES
  • DBA_DATA_FILES
  • DBA_TEMP_FILES

Answer : DBA_TEMP_FILES

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

Undo information falls into all the following categories except for which one?


Options are :

  • Uncommitted undo information
  • Undo information required in case an instance crash requires a roll forward operation when the instance is restarted
  • Committed undo information required to satisfy the undo retention interval
  • Expired undo information that is no longer needed to support a running transaction

Answer : Undo information required in case an instance crash requires a roll forward operation when the instance is restarted

Which of the following commands returns an error if the transaction starts with SET TRANSACTION READ ONLY?


Options are :

  • None of the above
  • ALTER SYSTEM
  • ALTER USER
  • SET ROLE

Answer : None of the above

Which of the following commands returns control to the user immediately if a table is already locked by another user?


Options are :

  • LOCK TABLE HR.EMPLOYEES IN EXCLUSIVE MODE NOWAIT DEFERRED;
  • LOCK TABLE HR.EMPLOYEES IN SHARE MODE NOWAIT;
  • LOCK TABLE HR.EMPLOYEES IN SHARE MODE WAIT DISABLED;
  • LOCK TABLE HR.EMPLOYEES IN EXCLUSIVE MODE WAIT DEFERRED;

Answer : LOCK TABLE HR.EMPLOYEES IN SHARE MODE NOWAIT;

1Z0-330 Oracle Fusion Workforce Compensation Cloud Test Set 2

To resolve a lock conflict, which of the following methods can you use? Choose all that apply.


Options are :

  • The DBA can kill the session holding the lock
  • The user can either roll back or commit the transaction that is holding the lock.
  • Oracle automatically resolves the lock after a short but predefined period by killing the session that is requesting the lock.
  • Oracle automatically resolves the lock after a short but predefined time period by killing the session that is holding the lock.

Answer : The DBA can kill the session holding the lock

How would you drop a tablespace if the tablespace were not empty?


Options are :

  • Use DROP TABLESPACE INCLUDING CONTENTS.
  • Use ALTER DATABASE DROP CASCADE
  • Rename all the objects in the tablespace, and then drop the tablespace
  • Remove the data files belonging to the tablespace from the disk.

Answer : Use DROP TABLESPACE INCLUDING CONTENTS.

Which of the following is the correct way to start a listener called LISTENER?


Options are :

  • lsnrctl startup listener
  • netmgr start listener
  • lsnrctl start
  • netca start

Answer : lsnrctl start

1Z0-330 Oracle Fusion Workforce Compensation Cloud Test Set 6

Which component is configured at database startup and cannot be dynamically managed?


Options are :

  • None of the above
  • None of the Above
  • Java pool
  • Shared pool
  • Streams pool
  • Redo log buffer

Answer : Redo log buffer

1Z0-330 Oracle Fusion Workforce Compensation Cloud Test Set 4

Automatic segment space management on the tablespace causes which of the following table attributes in that tablespace to be ignored?


Options are :

  • PCTFREE and PCTUSED
  • NEXT and PCTINCREASE
  • BUFFERPOOL and FREEPOOL
  • The whole storage clause

Answer : PCTFREE and PCTUSED

You noticed that the current value of the UNDO_RETENTION parameter is 900 and is too low for some of your transactions. The database was created using DBCA. You issue the following statement:
ALTER SYSTEM SET UNDO_RETENTION=4800;
Which option is true?


Options are :

  • The value is changed only in memory, and the server parameter file needs to be updated for the change to persist across database shutdowns.
  • The change will be available to the instance only after a database cycle.
  • The value is changed in memory, and when the database restarts the next time, the new value will be preserved when using the spfile.
  • UNDO_RETENTION is a static parameter and, therefore, cannot be changed using ALTER SYSTEM.

Answer : The value is changed in memory, and when the database restarts the next time, the new value will be preserved when using the spfile.

Which component is not part of an Oracle instance?


Options are :

  • Control file
  • System global area
  • Process monitor
  • Shared pool
  • None

Answer : Control file

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

Choose two SGA structures that are required in every Oracle instance.


Options are :

  • Shared pool,Buffer cache
  • Java pool
  • Large pool

Answer : Shared pool,Buffer cache

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions