Home › Quizzes › Application Development and Tuning for Oracle Databases

Application Development and Tuning for Oracle Databases

This test contains basic questions related to development and tuning of Oracle database. This set is useful for academic students and GATE aspirants.

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following statements is an incorrect statement about SQL trace facility in the Oracle database?

  1. Physical reads and logical reads
  2. Number of rows processed
  3. Commit and rollback of SQL statements
  4. Providing event data
  5. Generate the error information
Question 2 Multiple Choice (Single Answer)

Which of the following components contains a specific type of database object in 'Datafiles' in the Oracle database?

  1. Segment
  2. Extent
  3. Data block
  4. Tablespace
  5. Control File
Question 3 Multiple Choice (Single Answer)

Which of the following statements is an incorrect statement about loading XML data using SQL*Loader in the Oracle database?

  1. It supports XML type tables.
  2. The loading is independent of the underlying storage.
  3. The data can be loaded in LOBs.
  4. SQL*Loader uses direct path loading in case of inheritance of data.
  5. This method uses both conventional and direct-path methods.
Question 4 Multiple Choice (Single Answer)

Which of the following options is correct about Rollback segments in the Oracle database?

  1. These are used to track undo information for the database.
  2. These are used to copy the redo log files to extend the amount of redo information.
  3. These define the rollback commands.
  4. These segments determine the status of the server.
  5. These are used to check the database connectivity.
Question 5 Multiple Choice (Single Answer)

Which of the following is an incorrect statement regarding the creation of additional tablespaces in the Oracle database?

  1. To keep all the application data in a separate tablespace
  2. To enable backup of the database
  3. To maintain the database
  4. To distribute the data across multiple tablespaces
  5. To undo the database
Question 6 Multiple Choice (Single Answer)

Which of the following statements is an incorrect statement about TEMP components of Tablespaces in the Oracle database?

  1. It stores temporary data.
  2. It sorts the workspace.
  3. Every database should have a temporary tablespace.
  4. It is used to undo the tablespace used by the database.
  5. TEMP tablespace is specified as the default temporary tablespace.
Question 7 Multiple Choice (Single Answer)

Which of the following components of Tablespaces contains the data dictionary?

  1. SYSAUX
  2. SYSTEM
  3. TEMP
  4. UNDOTBS1
  5. USERS
Question 8 Multiple Choice (Single Answer)

Which of the following Tablespace statuses is used to perform maintenance on its datafiles in the Oracle database?

  1. Offline
  2. Read only
  3. Read Write
  4. Read
  5. Maintenance of datafiles is not possible by any tablespace status
Question 9 Multiple Choice (Single Answer)

Which of the following statements is an incorrect statement about the Database Storage Structure in the Oracle database?

  1. The preconfigured database has basic database structure.
  2. The database structure can be expanded.
  3. One can create additional redo log groups to expand the redo log capacity in the database.
  4. Oracle provides all the alerts related to the database storage while modification.
  5. The changes in the database storage do not change the data dictionary and the control file.
Question 10 Multiple Choice (Single Answer)

Which of the following statements is a false statement about Oracle database management?

  1. Oracle automatically enables auto-tuning of the database.
  2. The user can start the database without immediately managing undo.
  3. 'Undo the database' enables users to view or recover data to a previous point in time.
  4. Undo operation for the database can be used for the rollback operation.
  5. Undo operation provides read consistency of the database.
Question 11 Multiple Choice (Single Answer)

Which of the following statements is a correct statement about Undo Advisor in the Oracle database?

  1. It is used to advise on the undo tablespace size.
  2. It is used to undo the tablespace.
  3. It is used to undo the database.
  4. It is used to check the database connection.
  5. It is used to manage the database.
Question 12 Multiple Choice (Single Answer)

Which of the following statements is a correct statement about dropping a Tablespace in the Oracle database?

  1. The dropped tablespace can be rolled back.
  2. The objects and data in it will no longer be available after a tablespace has been dropped.
  3. The objects of the dropped tablespaces will be available to the users.
  4. These objects of the dropped tablespaces can be recovered.
  5. The tablespaces cannot be dropped.
Question 13 Multiple Choice (Single Answer)

Which of the following statements is an incorrect statement about Initialisation Parameter File in the Oracle database?

  1. This file is used by the database server.
  2. This file determines the runtime resources for the database.
  3. These files are actively monitored by the database.
  4. Thee files uses the initialisation parameters to check the database compatibility.
  5. These files cannot be set or modified while the database is running.
Question 14 Multiple Choice (Single Answer)

Which of the following options is not present in Application Tracing Utilities in the Oracle database?

  1. Output
  2. Session
  3. Client ID
  4. Service
  5. Trace
Question 15 Multiple Choice (Single Answer)

Which of the following statements is/are correct about the Back up files in the Oracle database?

  1. These files are technically not database files.
  2. These files are used by the database server initially at start-up.
  3. These files are created when a failure occurs which causes the loss of data.
  4. The files are monitored by the database.
  5. Both (1) and (3)
← Back to Quizzes