• databases Online Quiz - 110
Back
0

databases Online Quiz - 110

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

what does SQL Lack

technology databases

  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.

Show answer
Correct Option: A

Schema describes the Database?
technology databases

  1. Logically

  2. Physically

  3. Both of the above

  4. None of the above

Show answer
Correct Option: C

Schema consists of - sections?

technology databases

  1. 2

  2. 4

  3. 6

  4. 8

Show answer
Correct Option: B

Database Key is a combination of

technology databases

  1. Record Number

  2. Page Number

  3. Area Name

  4. Page Name

  5. Area Code

  6. Record Name

Show answer
Correct Option: A,B,E

How many record types are there in DMS
technology databases

  1. 1

  2. 2

  3. 4

  4. 6

Show answer
Correct Option: C

Which of the following record type is the fastest
technology databases

  1. Via Set

  2. Direct

  3. Calc

  4. Index Sequential

Show answer
Correct Option: B

How many areas are associted with an Index Sequential Record
technology databases

  1. 1

  2. 2

  3. 3

  4. 4

Show answer
Correct Option: B

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

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

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?

technology databases

  1. 50

  2. NULL

  3. 5

  4. None of the above

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

technology databases

  1. VARCHAR2

  2. RECORD

  3. BOOLEAN

  4. RAW

Show answer
Correct Option: B
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
961 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions