Tag: databases

Questions Related to databases

Calc Key of Calc Records is similar to ----- of RDBMS
technology databases

  1. Primary Key

  2. Alternate Key

  3. Foreign Key

  4. None

Show answer
Correct Option: A

Set defines a ------ relationship between record types
technology databases

  1. Physical

  2. Logical

  3. Both

  4. None

Show answer
Correct Option: B

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

  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

Show answer
Correct Option: A

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

  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

Show answer
Correct Option: B

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

  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

Show answer
Correct Option: C

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

  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

Show answer
Correct Option: D

A Transaction ends
technology databases

  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

Show answer
Correct Option: C

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

  1. Error

  2. NULL

  3. AXA US

  4. AXAUS

Show answer
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
technology databases

  1. 1

  2. 0

  3. 3

  4. 4

  5. None of the above

Show answer
Correct Option: D

The Data Manipulation Language statements are
technology databases

  1. INSERT

  2. UPDATE

  3. SELECT

  4. All of the above

Show answer
Correct Option: D