0

databases Online Quiz - 110

Description: databases Online Quiz - 110
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. The complexity and size of the SQL standard means that most databases DO NOT implement the entire standard.

  2. The simplicity and size of the SQL standard means that most databases DO implement the entire standard.

  3. The simplicity and size of the SQL standard means that most databases DO NOT implement the entire standard.

  4. The complexity and size of the SQL standard means that most databases DO implement the entire standard.


Correct Option: A
  1. Logically

  2. Physically

  3. Both of the above

  4. None of the above


Correct Option: C
  1. Record Number

  2. Page Number

  3. Area Name

  4. Page Name

  5. Area Code

  6. Record Name


Correct Option: A,B,E

Which of the following record type is the fastest

  1. Via Set

  2. Direct

  3. Calc

  4. Index Sequential


Correct Option: B

How many areas are associted with an Index Sequential Record

  1. 1

  2. 2

  3. 3

  4. 4


Correct Option: B

Index Sequential Records can be stored in the same area as being used by Calc Records

  1. True

  2. False


Correct Option: B
  1. Primary Key

  2. Alternate Key

  3. Foreign Key

  4. None


Correct Option: A

In a set ORDER is defined as LAST. When we insert a new member record occurence, this record will become.

  1. last member of the set

  2. first member of the set

  3. will be inserted after the current location in the set

  4. will be inserted before the current location in the set


Correct Option: A
  1. last member of the set

  2. first member of the set

  3. will be inserted after the current member in the set

  4. will be inserted before the current member in the set


Correct Option: B

In a set ORDER is defined as NEXT. When we insert a new member record occurence, this record will become.

  1. last member of the set

  2. first member of the set

  3. will be inserted after the current member in the set

  4. will be inserted before the current member in the set


Correct Option: C
  1. last member of the set

  2. first member of the set

  3. will be inserted after the current member in the set

  4. will be inserted before the current member in the set


Correct Option: D

A Transaction ends

  1. Only when it is Committed

  2. Only when it is Rolled back

  3. When it is Committed or Rolled back

  4. None of the above


Correct Option: C

What is the Result of the following 'AXA'||NULL||'US' ?

  1. Error

  2. NULL

  3. AXA US

  4. AXAUS


Correct Option: D

Use these data for the following Questions EMPNO ENAME SAL E100 John 3250 E200 Praveen 2000 E300 Mahesh E400 Prasanth 5500 E500 Vikram 6650 Select count (sal) from Emp will retrieve

  1. 1

  2. 0

  3. 3

  4. 4

  5. None of the above


Correct Option: D

The Data Manipulation Language statements are

  1. INSERT

  2. UPDATE

  3. SELECT

  4. All of the above


Correct Option: D
  1. VARCHAR2

  2. RECORD

  3. BOOLEAN

  4. RAW


Correct Option: B
- Hide questions