Question 1

what does SQL Lack

technology databases

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

Answer

Correct Option: A

Question 2

Schema describes the Database?

technology databases

Logically
Physically
Both of the above
None of the above

Answer

Correct Option: C

Question 3

Schema consists of - sections?

technology databases

2
4
6
8

Answer

Correct Option: B

Question 4

Database Key is a combination of

technology databases

Record Number
Page Number
Area Name
Page Name
Area Code
Record Name

Answer

Correct Option: A,B,E

Question 5

How many record types are there in DMS

technology databases

1
2
4
6

Answer

Correct Option: C

Question 6

Which of the following record type is the fastest

technology databases

Via Set
Direct
Calc
Index Sequential

Answer

Correct Option: B

Question 7

How many areas are associted with an Index Sequential Record

technology databases

1
2
3
4

Answer

Correct Option: B

Question 8

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

technology databases

True
False

Answer

Correct Option: B

Question 9

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

technology databases

Primary Key
Alternate Key
Foreign Key
None

Answer

Correct Option: A

Question 10

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

technology databases

Physical
Logical
Both
None

Answer

Correct Option: B

Question 11

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

technology databases

last member of the set
first member of the set
will be inserted after the current location in the set
will be inserted before the current location in the set

Answer

Correct Option: A

Question 12

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

technology databases

last member of the set
first member of the set
will be inserted after the current member in the set
will be inserted before the current member in the set

Answer

Correct Option: B

Question 13

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

technology databases

last member of the set
first member of the set
will be inserted after the current member in the set
will be inserted before the current member in the set

Answer

Correct Option: C

Question 14

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

technology databases

last member of the set
first member of the set
will be inserted after the current member in the set
will be inserted before the current member in the set

Answer

Correct Option: D

Question 15

A Transaction ends

technology databases

Only when it is Committed
Only when it is Rolled back
When it is Committed or Rolled back
None of the above

Answer

Correct Option: C

Question 16

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

technology databases

Error
NULL
AXA US
AXAUS

Answer

Correct Option: D

Question 17

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
0
3
4
None of the above

Answer

Correct Option: D

Question 18

The Data Manipulation Language statements are

technology databases

INSERT
UPDATE
SELECT
All of the above

Answer

Correct Option: D

Question 19

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

50
NULL
5
None of the above

Answer

Correct Option: C

Question 20

Find the ODD Datatype out

technology databases

VARCHAR2
RECORD
BOOLEAN
RAW

Answer

Correct Option: B

Description: databases Online Quiz - 110
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 110

Find more quizzes from top tags