databases Online Quiz - 134

Description: databases Online Quiz - 134
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Values must be obtained from a lookup table.

  2. Values must be part of a fixed set defined by create or alter table.

  3. Values must include reserved words, such as SYSDATE and USER.

  4. The column cannot contain a NULL value.

Correct Option: B

Which operator will be evaluated first in the following SELECT statement?

  1. +

  2. *

  3. /

  4. _

Correct Option: B

Which function can return a non-NULL value if passed a NULL argument?



  3. INSTR


Correct Option: B
  1. Primary key constraints allow NULL values in the columns.

  2. Unique key constraints allow NULL values in the columns.

  3. Primary key constraints do not allow NULL values in the columns.

  4. A nonunique index cannot be used to enforce primary key constraints.

Correct Option: B,C

At a minimum, how many join conditions should be there to avoid a Cartesian join if there are three tables in the FROM clause?

  1. 1

  2. 2

  3. 3

  4. There is no minimum.

Correct Option: B
  1. an integrated file system only

  2. A mirroring technology only

  3. an integrated file system with a volume manager

  4. A Volume manager only

Correct Option: C

File types not supported by ASM is:

  1. trace files

  2. cross paltform transportable datafiles

  3. change tracking file

  4. temporary files

Correct Option: A
  1. tablespace

  2. data blocks

  3. file

  4. extents

Correct Option: D

ASM divides files into ______ extents.

  1. 1MB

  2. 10MB

  3. 100KB

  4. 10KB

Correct Option: A
  1. used for data refresh from Production env. to development env.

  2. used as security layer to protect data from unathorized access.

  3. An Oracle technology used for data protection through mirroring.

  4. It ensures high availability, data protection, and disaster recovery for enterprise data.

Correct Option: D
  1. a RAC database only

  2. a stand alone database only

  3. The primary database can be either a standalone database or a RAC.

  4. a physical standby database .

Correct Option: C
  1. redo transport service,log applyservice,Role transition

  2. log applyservice,Role transition,Failover service

  3. redo transport service,Role transition,Failover service

  4. redo transport service,log applyservice,Failover service

Correct Option: A

The Protection modes available in Data guard are:

  1. Protection,availability,performance

  2. Protection,availability,scalability

  3. Maximum Protection,maximum availability,maximum performance

  4. Maximum Protection,maximum availability,maximum scalability

Correct Option: C

Which component in the SGA has the dictionary cache?

  1. Buffer cache

  2. Library cache

  3. Shared pool

  4. Program Global Area

Correct Option: C

What is the minimum number of control files are required to start a database?

  1. One

  2. Two

  3. Three

  4. None

Correct Option: A
- Hide questions