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

How can you change the comment assigned to the columns in a table?


Options are :

  • Use the COMMENT ON COLUMN statement.
  • Use the RENAME statement.
  • Use the ALTER TABLE MODIFY COLUMN statement.
  • Use the COMMENT ON TABLE statement.

Answer : Use the COMMENT ON COLUMN statement.

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

What is the process that notifies the listener after a database connection is established?


Options are :

  • LGWR
  • DBWR
  • SMON
  • PMON

Answer : PMON

Which of the following is not a step in the processing of a Shared Server request?


Options are :

  • The dispatcher picks up completed requests from its response queue.
  • Shared servers pass information back to the client process.
  • Dispatchers place information in a request queue.
  • Users pass requests to a dispatcher.
  • None of the above.

Answer : Shared servers pass information back to the client process.

In which of the following files would you find the Shared Server configuration parameters?


Options are :

  • init.ora
  • sqlnet.ora
  • mts.ora
  • tnsnames.ora
  • listener.ora

Answer : init.ora

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

Which is a valid tablespace extent management specification?


Options are :

  • Local
  • Automatic
  • Manual
  • Temporary

Answer : Local

Which of the following is a component of Shared Server?


Options are :

  • Shared user processes
  • Dispatcher processes
  • Checkpoint processes
  • Dedicated server processes

Answer : Dispatcher processes

When configured in Shared Server mode, which of the following is contained in the PGA?


Options are :

  • Sort information
  • User session data
  • Stack space
  • Cursor state
  • None of the above

Answer : Stack space

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

All the following are reasons to configure the server using Shared Server except:


Options are :

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

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

Which of the following is true about Shared Server?


Options are :

  • The database cannot be stopped when connected via Shared Server.
  • It is recommended that index rebuilds be performed when connected via Shared Server.
  • Dedicated connections cannot be made when Shared Server is configured.
  • The database can be started when connected via Shared Server.

Answer : The database cannot be stopped when connected via Shared Server.

What can tablespaces be used for?


Options are :

  • To move data from one database to another
  • All of the above
  • To organize tables and indexes into manageable groupings
  • To make sure that data stored in the tablespace does not change

Answer : All of the above

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

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions