Database Management Systems

 

1

The files used for speedy disk search by providing the specialized structures of data are classified as

 

 

a.       indexes

b.      glossaries

 

c.       content specification

d.      listing documents

2

The master list of an indexed file

 

a.       is sorted in ascending order

b.      contains only a list of keys and record numbers

 

c.       has a number assigned to each record

d.      None of these

3

DBMS manages the interaction between __________ and database

 

a.       Users

b.      Clients

 

c.       End Users

d.      Stakeholders

4

Which of the following is not involved in DBMS?

 

a)      End Users

b)      Data

 

c)      Application Request

d)     HTML

5

What is the full form of DBA

 

a)      Database Access

b)      Database Administrator

 

c)      Database Authority

d)     None of the these

6

The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in

 

a.       a tree file

b.      a binary file

 

c.       a hashed file

d.      a object file

7

Which term used to refer to a row in a table?

 

 

a)      attribute

b)      tuple

 

c)      field

d)     instance

8

Which database level is closest to the users?

 

a)      External

b)      Internal

 

c)      Physical

d)     Conceptual

9

The physical location of a record is determined by a mathematical formula that transforms a file key into a record location is :

 

 

a)      B tree File

b)      Hashed File

 

c)      Sequential File

d)     None of these

10

In an ER model, which one is described in the database for storing its data?

 

a)      entity

b)      attribute

 

c)      relationship

d)     notation

11

If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.

 

a)      delete

b)      update

 

c)      Sort Key

d)     index

12

What is the degree of a table of 50 rows and 5 columns

 

a)      50

b)      5

 

c)      250

d)     None of these

13

In the relational modes, cardinality is termed as:

 

a)      Number of tuples

b)      Number of attributes

 

c)      Number of tables

d)     Number of constraints

14

Which one of the following is not an indexing technique ?

 

a)      Primary index

b)      Secondary index

 

c)      Multilevel index

d)     Sequential index.

15

The full form of ER Diagram is

 

a)      Entity -Relationship Diagram

b)      Entity Relation Diagram

 

c)      Entity Rotation Diagram

d)     None of these

16

An indexing operation

 

a)      sorts a file using a single key

b)      sorts file using two keys

 

c)      establishes an index for a file

d)     both (b) and (c)

17

…………… clause is an additional filter that is applied to the result.

 

a)      Select

b)      Group-by

 

c)      Having

d)     Order by

18

_____ command is used for modifying an existing table

 

a)      CREATE

b)      ALTER

 

c)      DROP

d)     None of these

19

Which index is specified on the non-ordering fields of a file ?

 

a)       Primary

b)      Clustering

 

c)      Secondary

d)     None of these

20

……. command can be used to modify a column in a table

 

a)      alter

b)      update

 

c)      set

d)     create

21

DCL stands for ___________

 

a) Data Count Language

b) Data Control Language

 

c) Data Connection Language

d) None of these

22

____ command is used to give permission.

 

a) GRANT

b) ALTER

 

c) CREATE

d) None of these

23

Select operator (ϭ) works row wise where as project operator(Π) works

 

a) Row wise only

b) Column wise only

 

c) both Row wise only & Column wise only

d) None of these

24

A clustering index is defined on the fields which are of type

 

Non-key and ordering

Non-key and non-ordering

 

Key and ordering

Key and non-ordering

25

Which of the following is not a built in aggregate function in SQL?

 

a) avg

b) max

 

c) total

d) count

26

What values does the count(*) function ignore?

 

a) Repetitive values

b) Null values

 

c) Characters

d) Integers

27

The ________ clause is used to list the attributes desired in the result of a query

 

a) select

b) from

 

c) where

d) create

28

The ______ operator is used to compare a value to a list of literals values that have been specified

 

a) BETWEEN

b) ANY

 

c) IN

d) ALL

29

An organized logical sequence of records is called

 

a)      file

b)      organization

 

c)      scrubbing

d)      sequencing

30

A primary key cannot be ______

 

a) void

b) null

 

c) both void & null

d) None of these

31

Files are logically partitioned into storage units of fixed-length known as

 

a)      sector

b)      tracks

 

c)      segment

d)      blocks

32

Technique used in DBMS to store all related objects in mixed file is classified as

 

a)      ternary clustering

b)      secondary clustering

 

c)      physical clustering

d)      primary clustering

33

The term _______ is used to refer to a row

 

a)      Attribute

b)      Tuple

 

c)      Field

d)      Instance

34

Fields which are used to retrieve related records from other files are called

 

a)      secondary fields

b)      key fields

 

c)      primary fields

d)      connecting fields

35

A relational database consists of a collection of

 

a)      Tables

b)      Fields

 

c)      Records

d)      Keys

36

A top-to-bottom relationship among the items in a database is established by a

 

a)      Hierarchical schema

b)      Network schema

 

c)      Relational schema

d)      All of the mentioned

37

The file organization which allows us to read records that would satisfy the join condition by using one block read is

 

a)      Heap file organization

b)      Sequential file organization

 

c)      Clustering file organization

d)      Hash file organization

38

The restrictions placed on the data.

 

a)      Relation

b)      Attribute

 

c)      Parameter

d)      Constraint

39

A unit of storage that can store one or more records in a hash file organization is denoted as

 

a)      Buckets

b)      Disk pages

 

c)      Blocks

d)      Nodes

40

VDL stands for

 

a) Very small data language

b) View data language

 

c) View Definition Language

d) None of these

41

Every BCNF form is in

 

a)      1NF

b)      2NF

 

c)      3NF

d)      All of these

42

DDL stands for _______

 

a)      Data Definition Language

b)      Data Define Language

 

c)      Data Dictionary Language

d)      None of these

43

If every non-key attribute is functionally dependent on the primary key, then the relation will be in

 

a)      1NF

b)      2NF

 

c)      3NF

d)      4NF

44

Cartesian product in relational algebra is

 

a)      Unary operator

b)      Binary operator

 

c)      Ternary operator

d)      not defined

45

The database schema is written in

 

a) HLL

b) DML

 

c) DDL

d) DCL

46

A BCNF is:

 

a)      Lossless join and dependency preserving

b)      Lossless join   but not dependency preserving

 

c)      Not Lossless join but dependency preserving

d)      None of these

47

A property which ensures that each functional dependency is represented in some individual relation resulting after decomposition

 

a)      Lossless join

b)      Dependency preservation

 

c)      Both a and b

d)      None of these

48

In an E-R diagram attributes are represented by

 

a)      rectangle

b)      square

 

c)      ellipse

d)      triangle

49

Functional dependencies are a generalization of

 

a)      Key dependencies

b)      Relation dependencies

 

c)      Database dependencies

d)      None of these

50

The number of tuples of a relation is its

 

a)      Degree

b)      Intention

 

c)      Cardinality

d)      None of these

Post a Comment

0 Comments