Home › Quizzes › Introduction to Oracle Database

Introduction to Oracle Database

This test consists of questions related to Oracle database, which are useful for CS and gate aspirants.

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following is/are true statement(s) about the physical database structure of the Oracle database?

  1. The data of the logical database structures physically stores in the datafiles.
  2. The datafile can be associated with more than one database.
  3. The data in datafiles is stored in the memory cache of Oracle.
  4. All of the above
  5. Both (1) and (3)
Question 2 Multiple Choice (Single Answer)

Which of the following is/are false about the control files in Oracle database?

  1. Control files specify the physical structure of the database.
  2. A control file has information about the name of the database.
  3. A control file is responsible for identification of the database during database operation.
  4. A control file can be used for database recovery operation.
  5. None of the above
Question 3 Multiple Choice (Single Answer)

Which of the following is/are true about the logical database structures of the Oracle database?

  1. Tablespaces group related database structures together.
  2. Data files physically store the data of all logical structures in a tablespace.
  3. Each database is logically divided into one or more tablespaces.
  4. All of the above
  5. Both (1) and (2)
Question 4 Multiple Choice (Single Answer)

Which of the following is false about data segment in Oracle database?

  1. The data segment defines the logical structure of the database.
  2. Each partition has a data segment for a partitioned table in the database.
  3. Database segments are created when a SQL statement needs temporary database area to complete execution.
  4. Every table in the cluster stores its data in the cluster's data segment.
  5. None of the above
Question 5 Multiple Choice (Single Answer)

Which of the following is not a function related to Redo log files in Oracle database?

  1. These files can be used to record the changes made in the database.
  2. Oracle allows a multiplex redo log operation for Redo log files.
  3. Redo log file contains the information that is used only to recover the database from a system or media failure.
  4. Redo log file contains the information about the Time stamp of database creation.
  5. Every Oracle database can have set of two or more Redo log files.
Question 6 Multiple Choice (Single Answer)

Which of the following is/are true statement(s) about the schema objects in Oracle database?

  1. Schema objects define the logical structures of the database.
  2. There is a relationship between a tablespace and a schema.
  3. The schema objects contain structures like tables, views, and indexes.
  4. All of the above
  5. Both (1) and (3)
Question 7 Multiple Choice (Single Answer)

Which of the following is a false statement about the clusters in Oracle database?

  1. Clusters can affect application design.
  2. The data stored in a clustered table is accessed by SQL.
  3. Clustering is used to order the physical placement of tables on a disk drive.
  4. Cluster key determines the value of cluster key columns for a particular row.
  5. Cluster also improves retrieval performance of the database operation.
Question 8 Multiple Choice (Single Answer)

Which of the following is/are true statement(s) about Oracle database?

  1. Ordinary tables are stored with all rows in no particular order.
  2. In ordinary tables, rows of the table are stored in different segments.
  3. In partitioned tables, rows of the table are stored in one segment.
  4. All of the above
  5. Both (1) and (2)
Question 9 Multiple Choice (Single Answer)

Which of the following is a false statement about the Application architecture in Oracle database?

  1. In Application architecture, client application is also responsible for data processing.
  2. Oracle database provides better performance to its client applications.
  3. Oracle database provides better concurrency and data integrity.
  4. Client applications are not dependent on the physical location of the data.
  5. None of the above
Question 10 Multiple Choice (Single Answer)

Which of the following is/are false statement(s) about Oracle data types?

  1. Character string length is maximum 2000 bytes.
  2. There are no reference data types defined for Oracle database.
  3. The array data type is ordered type.
  4. long raw comes under the collection data types.
  5. Both (2) and (4)
Question 11 Multiple Choice (Single Answer)

Which of the following is/are the false statement(s)?

  1. System Global Area (SGA) has no direct access from the clients.
  2. System Global Area (SGA) is a called a shared memory segment.
  3. The dictionary cache in SGA caches Oracle own internal information.
  4. None of the above
  5. Both (1) and (3)
Question 12 Multiple Choice (Single Answer)

Which of the following is a false statement about the data flow in Oracle database?

  1. The log buffer is responsible for records all the changes made to the buffer cache.
  2. The log buffer is a part of SGA (System Global Area).
  3. The serve process makes an entry to log buffer to execute the SQL statements.
  4. The log buffer is not responsible to redo the changes in case of a recovery process.
  5. None of the above
Question 13 Multiple Choice (Single Answer)

Which of the following is/are true about log writer in the Oracle database server?

  1. It is used to store log records for recovery process.
  2. Log writer is responsible for writing the redo log buffer to the redo log files.
  3. The typical size of log writer is up to a few hundred kilobytes.
  4. All of the above
  5. Both (1) and (2)
Question 14 Multiple Choice (Single Answer)

Which of the following is/are true about the multitier architecture of Oracle database?

  1. Multitier Architecture contains one or more application servers.
  2. An application server acts as an interface between clients and multiple database servers.
  3. Multitier architecture enables application server to validate the credentials of a client, such as a web browser.
  4. All of the above
  5. Both (1) and (3)
Question 15 Multiple Choice (Single Answer)

Which of the following is false about Oracle instance in Oracle database server?

  1. Oracle instance is a major component in the Oracle database server.
  2. Oracle instance is a set of memory and process structures.
  3. It is responsible for translating SQL calls given by the client.
  4. Oracle instance may exist without being associated with an Oracle database.
  5. None of the above
← Back to Quizzes