Oracle Database MCQ

Test your knowledge with important Oracle Database MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more Oracle Database MCQs on Bissoy. Bissoy App

• Which of the following is not a restriction for a table to be a relation?
  ক

  The cells of the table must contain a single value

  খ

  All of the entries in any column must be of the same kind

  গ

  The columns must be ordered

  ঘ

  No two rows in a table may be identical
• When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
  ক

  Transitive Dependency

  খ

  Insertion Anomaly

  গ

  Referential Integrity Constraint

  ঘ

  Normal Form
• The wildcard in a WHERE clause is useful when?
  ক

  An exact match is necessary in a SELECT statement

  খ

  An exact match is not possible in a SELECT statement

  গ

  An exact match is necessary in a CREATE statement

  ঘ

  An exact match is not possible in a CREATE statement
• Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
  ক

  Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row

  খ

  Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column

  গ

  Three rows have the values Brown, NULL, and Blue in the same column

  ঘ

  One row has the value “He is interested in a Silver Porsche from the years 1978-1988” in a column
• Business Intelligence (BI) reporting systems cannot do which of the following operations?
  ক

  Filter data

  খ

  Group data

  গ

  Modify data

  ঘ

  Both filter and group data
• A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?
  ক

  Push

  খ

  Pull

  গ

  RFM

  ঘ

  OLAP
• Which of the following is not one of the three ways to classify an action assertion?
  ক

  Condition

  খ

  Integrity Control

  গ

  Authorization

  ঘ

  Enabler
• Use of a supertype/subtype relationship is necessary when which of the following exists?
  ক

  An instance of a subtype participates in a relationship that is unique to that subtype

  খ

  An instance of a subtype participates in a relationship that is the same as the other subtypes

  গ

  Attributes apply to all of the instances of an entity type

  ঘ

  No attributes apply to any of the instances of an entity type
• A supertype/subtype hierarchy is which of the following?
  ক

  Each subtype has only one attribute

  খ

  Each supertype has only one attribute

  গ

  Each subtype has only one supertype

  ঘ

  Each supertype has only one subtype
• Which of the following statements concerning business rules is true?
  ক

  It should be complex.

  খ

  It should not be convertible to computer code.

  গ

  It may include restrictions.

  ঘ

  All of the Mentioned
• Which of the following is not a component of a data warehouse?
  ক

  Data metadata

  খ

  Data extraction/cleaning/preparation programs

  গ

  Data warehouse data

  ঘ

  None of the Mentioned