• databases Online Quiz - 134
Back
0

databases Online Quiz - 134

Description: databases Online Quiz - 134
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

You are managing constraints on a table in Oracle. Which of the following choices correctly identifies the limitations on check constraints?
technology databases

  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.

Show answer
Correct Option: B

The transaction control that prevents more than one user from updating data in a table is which of the following?
technology databases

  1. lock

  2. commit

  3. rollback

  4. savepoint

Show answer
Correct Option: A

You are using SQL operations in Oracle. All of the following DATE functions return a DATE datatype except one. Which one is it?
technology databases

  1. NEW_TIME

  2. LAST_DAY

  3. ADD_MONTHS

  4. MONTHS_BETWEEN

Show answer
Correct Option: D

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

technology databases

  1. +

  2. *

  3. /

  4. _

Show answer
Correct Option: B

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

technology databases

  1. LENGTH

  2. CONCAT

  3. INSTR

  4. NULLIF

Show answer
Correct Option: B

Which datatype stores data outside Oracle Database?
technology databases

  1. UROWID

  2. BLOB

  3. NCLOB

  4. BFILE

Show answer
Correct Option: D

Which of the following statements are true?
technology databases

  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.

Show answer
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?

technology databases

  1. 1

  2. 2

  3. 3

  4. There is no minimum.

Show answer
Correct Option: B

What is ASM?
technology databases

  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

Show answer
Correct Option: C

The daemon that is required to enable synchronization between ASM and its client database instances is
technology databases

  1. CRS

  2. CSS

  3. ocsssd

  4. ocsd.bin

Show answer
Correct Option: B

File types not supported by ASM is:

technology databases

  1. trace files

  2. cross paltform transportable datafiles

  3. change tracking file

  4. temporary files

Show answer
Correct Option: A

In ASM, Mirroring is done at ___________ level.
technology databases

  1. tablespace

  2. data blocks

  3. file

  4. extents

Show answer
Correct Option: D

ASM divides files into ______ extents.

technology databases

  1. 1MB

  2. 10MB

  3. 100KB

  4. 10KB

Show answer
Correct Option: A

What is Oracle data guard?
technology databases

  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.

Show answer
Correct Option: D

A Data Guard configuration contains one production database which is _____________
technology databases

  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 .

Show answer
Correct Option: C

The three dataguard services are:
technology databases

  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

Show answer
Correct Option: A

The Command line interface for Data Guard is ________________
technology databases

  1. DGMGRL

  2. DGCMD

  3. DGBKR

  4. DGGRL

Show answer
Correct Option: A

The Protection modes available in Data guard are:

technology databases

  1. Protection,availability,performance

  2. Protection,availability,scalability

  3. Maximum Protection,maximum availability,maximum performance

  4. Maximum Protection,maximum availability,maximum scalability

Show answer
Correct Option: C

Which component in the SGA has the dictionary cache?

technology databases

  1. Buffer cache

  2. Library cache

  3. Shared pool

  4. Program Global Area

Show answer
Correct Option: C

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

technology databases

  1. One

  2. Two

  3. Three

  4. None

Show answer
Correct Option: A
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
961 Quizzes
19148 Questions
 history
1088 Quizzes
13125 Questions
 physics
537 Quizzes
11445 Questions
 biology
1026 Quizzes
11462 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
432 Quizzes
8610 Questions
 maths
438 Quizzes
7860 Questions
 softskills
0 Quizzes
7131 Questions