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

what does SQL Lack

  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

Schema consists of - sections?

  1. 2

  2. 4

  3. 6

  4. 8


Correct Option: B

Database Key is a combination of

  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

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

  1. Primary Key

  2. Alternate Key

  3. Foreign Key

  4. None


Correct Option: A

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

  1. Physical

  2. Logical

  3. Both

  4. None


Correct Option: B

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

In a set ORDER is defined as PRIOR. 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: 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
  1. INSERT

  2. UPDATE

  3. SELECT

  4. All of the above


Correct Option: D

Declare a number := 5; b number := null; c number := 10; Begin if a > b AND a < c then a := c * a; end if; End; What will be the value of 'a' after execution?

  1. 50

  2. NULL

  3. 5

  4. None of the above


Correct Option: C

AI Explanation

To determine the value of 'a' after execution, let's go through the code step by step:

  1. Declare the variables:

    • a = 5
    • b = null
    • c = 10
  2. Evaluate the condition: a &gt; b AND a &lt; c

Since a is not null and satisfies both conditions (5 &gt; null and 5 &lt; 10), the condition evaluates to true.

  1. Execute the code within the if statement: a := c * a

Update the value of a to 10 * 5 = 50.

Therefore, the value of 'a' after execution will be 50.

The correct answer is A) 50.

Find the ODD Datatype out

  1. VARCHAR2

  2. RECORD

  3. BOOLEAN

  4. RAW


Correct Option: B
- Hide questions