wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

DBMS QUIZ

Total questions: 85

Worksheet time: 53mins

Name
Class
Date
1.

The data model which describes how the data is actually stored is

a)

internal model

b)

external model

c)

logical model

d)

none of these

2.

Data about data is normally termed as

a)

directory

b)

data bank

c)

meta data

d)

none of the above

3.

The database administrator is, in effect, the coordinator between them ____ and the ____

a)

(A) Database, users

b)

(B) Application program; database

c)

(C) DBMS; database

d)

(D) Application programs; users

4.

Where will we find the referential integrity command?

a)

(A) Table

b)

(B) Tools

c)

(C) Format

d)

(D) None of these

5.

Which of the following component of a computer system is the most important to a database management system?

a)

(A) High speed, large capacity disk

b)

(B) High resolution video display

c)

(C) Mouse

d)

(D) Printer

6.

In a relational schema, each tuple is divided into fields called

a)

(A) Domains

b)

(B) Queries

c)

(C) Relations

d)

(D) None of these

7.

An indexing operation

a)

(A) Establishes an index for a file

b)

(B) Sorts a file using two keys

c)

(C) Sorts a file using a single key

d)

(D) Both (b) and (c)

8.

The modify operation is likely to be done after

a)

(A) Insert

b)

(B) Delete

c)

(C) Look-up

d)

(D) None of these

9.

The method of file organization in which data records in a file are arranged in a specified order according to key field is known as the

a)

(A) Sequential access method

b)

(B) Queuing method

c)

(C) Predetermined method

d)

(D) Direct access method

10.

External database is

a)

(A) Database created using DBMS package

b)

(B) Database created in MS-Word

c)

(C) Database created in EXCEL

d)

(D) All of the above

11.

ROLLBACK in a database is ____ statement.

a)

(A) DDL

b)

(B) DML

c)

(C) DCL

d)

(D) TCL

12.

The logical data structure with a one-to-many relationship is a

a)

(A) Tree

b)

(B) Chain

c)

(C) Network

d)

(D) All of these

13.

The following are components of a database except _____

a)

(A) reports

b)

(B) indexes

c)

(C) metadata

d)

(D) user data

14.

The smallest logical data entity is called a data item or data

a)

(A) Field

b)

(B) Collection

c)

(C) Base

d)

(D) Bank

15.

E.F. Codd represented _____ rules that a database must obey if it has to be considered truly relational.

a)

(A) 6

b)

(B) 8

c)

(C) 10

d)

(D) 12

16.

The distinguishable parts of a record are called

a)

(A) Fields

b)

(B) Files

c)

(C) Data

d)

(D) All of these

17.

The command to convert a numeric number to characters is

a)

(A) STR ()

b)

(B) CHR ()

c)

(C) ASC ()

d)

(D) All of these

18.

What is not true about a view?

a)

a. It is a definition of a restricted portion of the database

b)

b. It is a security mechanism

c)

c. It is always updatable like any other table

d)

d. All are true

19.

In a relational database a referential integrity constraint can be specified with the help of

a)

a. primary key

b)

b. foreign key

c)

c. secondary key

d)

d. none of the above

20.

4NF is designed to cope with

a)

a. Transitive dependency

b)

b. Join dependency

c)

c. Multi valued dependency

d)

d. None of these

21.

Which command is used to add a column to an existing table?

a)

a. Create

b)

b. Update

c)

c.Alter

d)

d. None of these

22.

Rollback of transactions is normally used to

a)

a. recover from transaction failure

b)

b. update the transaction

c)

c. retrieve old records

d)

d. repeat a transaction

23.

In the architecture of the Database System, external level is the

a)

Physical level

b)

Logical level

c)

Conceptual level

d)

View level

24.

In Hierarchical Model records are organized as

a)

Graph

b)

List

c)

Links

d)

Tree

25.

In an ER diagram, attributes are represented by?

a)

Rectangle

b)

Square

c)

Ellipse

d)

Triangle

26.

A logical Schema

a)

is the entire database.

b)

is a standard way of organizing the information into accessible parts.

c)

describes how data actually stores on the disc

d)

options 1 & 3

27.

In an ER diagram, Entity types are represented by

a)

rectangle

b)

ellipse

c)

diamond box

d)

circle

28.

A relational database developer refers to a record as

a)

Criteria

b)

a relation

c)

a tuple

d)

an attribute

29.

An advantage of DBMS approach is

a)

data is dependent on programs

b)

data redundancy increases

c)

data can be integrated and can be accessed by multiple programs

d)

none of the above

30.

Which of the following are the properties of entities?

a)

Groups

b)

Tables

c)

Attributes

d)

Switchboards

31.

In ER diagram relationship type is represented by

a)

Ellipse

b)

Dashed Ellipse

c)

Rectangle

d)

Diamond

32.

What database level is closest to the user

a)

External

b)

Internal

c)

Physical

d)

Conceptual

33.

Enter Your Email id

4 lines
34.

Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?

a)

DML(Data Manipulation Language)

b)

Query

c)

Relational Schema

d)

DDL(Data Definition Language)

35.

The given Query can also be replaced with_______:

SELECT name, course_id FROM instructor, teaches WHERE instructor_ID= teaches_ID;

a)

Select name,course_id from teaches,instructor where instructor_id=course_id;

b)

Select name, course_id from instructor natural join teaches;

c)

Select name, course_id from instructor;

d)

Select course_id from instructor join teaches;

36.

Which one of the following given statements possibly contains the error?

a)

select * from emp where empid = 10003;

b)

select empid from emp where empid = 10006;

c)

select empid from emp;

d)

select empid where empid = 1009 and Lastname = 'GELLER';

37.

A Database Management System is a type of _________software.

a)

It is a type of system software

b)

It is a kind of application software

c)

It is a kind of general software

d)

Both A and C

38.

The term "FAT" is stands for_____

a)

File Allocation Tree

b)

File Allocation Table

c)

File Allocation Graph

d)

All of the above

39.

Which one of the following refers to the "data about data"?

a)

Directory

b)

Sub Data

c)

Warehouse

d)

Meta Data

40.

Which of the following refers to the level of data abstraction that describes exactly how the data actually stored?

a)

Conceptual Level

b)

Physical Level

c)

File Level

d)

Logical Level

41.

To which of the following the term "DBA" referred?

a)

Data Bank Administrator

b)

Database Administrator

c)

Data Administrator

d)

None of the above

42.

In general, a file is basically a collection of all related______.

a)

Rows & Columns

b)

Fields

c)

Database

d)

Records

43.

The term "Data" refers to:

a)

The electronic representation of the information( or data)

b)

Basic information

c)

Row Facts and figures

d)

Both A and C

44.

RAID stand for _________

a)

Redundant Arrays of Idempotent Data

b)

Redundant Arrays of Independent Disks

c)

Redundant Arrays of Independent Data

d)

Redundant Arrays of Isolated Disks

45.

The files with variable length records make use of (a)   structure for storage.

46.

To preserve the integrity and consistency of data, the database system must ensure

a)

Atomicity

b)

Isolation

c)

Durability

d)

Consistency

e)

All of the above

47.

Consider the following action:

TRANSACTION.....

Commit;

ROLLBACK;

What does Rollback do?

a)

Undoes the transactions before commit

b)

Clears all transactions

c)

Redoes the transactions before commit

d)

No action

48.

If a schedule S can be transformed into a schedule S' by a series of swaps of non-conflicting instructions, we say that S and S' are

a)

Conflict serializable

b)

Conflict equivalent

c)

View serializable

d)

Serializable

49.

Consider the two transactions T1 and T2 and four schedules S1, S2, S3, S4 of T1 and T2 as given below

S1: R1(X); R2(X); R2(Y); W1(X); W1(Y); W2(Y)

S2: R1(X); R2(X); R2(Y); W1(X); W2(Y); W1(Y)

Here R1(X) denotes read operation on X by the transaction T1 and W1(X) denotes write operation on X by the transaction T1.

Which of the schedules(s) are conflicts serializable?

a)

S1 and S2

b)

S2 only

c)

S1 only

d)

Neither S1 nor S2

50.

For the given schedule, which is the equivalent serial schedule?


a)

T1 - T2 - T3

b)

T1 - T3 - T2

c)

T2 - T1 - T3

d)

T3 - T1 - T2

51.

The column ‘C’ has to be indexed. What is the content of the bitmap index?

A B C

a1 b1 c2

a1 b1 c2

a2 b4 c1

a3 b2 c3

4 lines
52.

Identify the options which are true for Immediate-modification scheme

a)

Allows updates of an uncommitted transaction to be made to the buffer, or the disk itself, before the transaction commits.

b)

Update log record must be written after a database item is written

c)

Output of updated blocks to disk storage can take place at any time before or after transaction commit

d)

Performs updates to buffer/disk only at the time of transaction commit

53.

Consider the state of the transactions in the diagram and the statements given below:

A. T1 can be ignored.

B. T2 and T3 redone

C. T4 undone

D. T4 redone

Mark the correct group of statements from the options below

a)

A, B, D

b)

A, B, C

c)

Only A and B but not C

d)

Only B and C but not A

54.

Identify the incorrect statement based on checkpoint

a)

All updates are stopped while doing checkpoint

b)

Continue scanning backwards till a record <Ti start> is found for every transaction Ti in L

c)

Scan backwards from end of log to find the most recent <checkpoint L> record

d)

Scan from starting of log to find the most recent <checkpoint L> record

55.

What is the effect of the UNDO operation corresponding to a log record

< Ti; Y; S; K >

where Ti is the transaction, and S and K are the old and new values respectively of a data location

a)

No change to Y

b)

Writes the value S to Y

c)

Writes the value K to Y

d)

Sets Y to 0

56.

Based on the figure above, identify the number of tuples that will be returned by the following relational algebra query : σ \sigma\ Type = 'Saving' (Account)

a)

2

b)

3

c)

6

d)

0

57.

Choose the CORRECT symbol of SELECT in the Relational Algebra

a)

x

b)

π\pi

c)

∩\cap

d)

σ\sigma

58.

Identify the CORRECT output for table (Student Difference Lecturer) or (Student - Lecturer) in table above

a)
b)
c)
d)
59.

Write the CORRECT relational algebra expression base on the figure above

a)

π\pi managerID, managerName ( σ\sigma workExprience = 5) (MANAGER)

b)

σ\sigma managerID, managerName ( π\pi workExprience = 5) (MANAGER)

c)

undefined managerID, managerName (undefined workExprience > 5) (MANAGER)

d)

undefined managerID, managerName (undefined workExprience > 5) (MANAGER)

60.

Write the relational algebra to list student's number and student'a name whose age is 20 years old or state in Terengganu.

a)

π\pi StudentID, Name ( σ\sigma Age=20 AND State = "Terengganu" (STUDENT)

b)

undefined StudentID, Name (undefined Age=20 OR State = "Terengganu" (STUDENT)

c)

σ\sigma StudentID, Name ( π\pi Age=20 AND State = "Terengganu" (STUDENT)

d)

undefined StudentID, Name (undefined Age=20 OR State = "Terengganu" (STUDENT)

61.

Base on the table given, identify output that will be produced when, σ Salary > 3000 ˅ City = ‘Batu Pahat’ (WORKER).

a)
b)
c)
d)
62.

Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.

a)

Relational

b)

Structural

c)

Procedural

d)

Fundamental

63.

Is equivalent to

a)
b)
c)
d)
64.

Sailors (sid, name, rating, age)

Boats (bid, name, color)

Reserves (sid, bid, day)

List names of boats.

a)

π ( Boats)

b)

σ name(Boats)

c)

πname ( Boats)

d)

σ (Boats)

65.

Which of the following are relational algebra operators?

a)
b)
c)
d)
e)
66.

Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.

a)

Relational

b)

Structural

c)

Procedural

d)

Fundamental

67.

Which of the following is used to denote the selection operation in relational algebra?

a)

Pi

b)

Sigma

c)

Lambda

d)

Omega

68.

For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigma.

a)

Predicates, relation

b)

Relation, Predicates

c)

Operation, Predicates

d)

Relation, Operation

69.

The ___________ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.

a)

Union

b)

Set Difference

c)

Division

d)

Intersection

70.

Which is a join condition contains an equality operator:

a)

Equi Join

b)

Cartesian

c)

Natural

d)

Left

71.

In precedence of set operators, the expression is evaluated from

a)

Left to Right

b)

Right to Left

c)

From user specification

d)

Left & Right both in parallel

72.

Find the ID, name, dept name, salary for instructors whose salary is greater than $80,000

a)

{t | t ε instructor ∧ t[salary] > 80000}

b)

Э t ∈ r (Q(t))

c)

{t | Э s ε instructor (t[ID] = s[ID]∧ s[salary] > 80000)}

d)

None of these

73.

A query in the tuple relational calculus is expressed as:

a)

{t | P() | t}

b)

{P(t) | t }

c)

{t | P(t)}

d)

All of these

74.

Which of the following symbol is used in the place of except?

a)

^

b)

v

c)

¬

d)

*

75.

“Find all students who have taken all courses offered in the Biology department.” The expressions that matches this sentence is :

a)

Э t ε r (Q(t))

b)

∀ t ε r (Q(t))

c)

¬ t ε r (Q(t))

d)

~ t ε r (Q(t))

76.

Which of the following is the comparison operator in tuple relational calculus

a)

⇒

b)

=

c)

ε

d)

All of these

77.

An expression in the domain relational calculus is of the form

a)

{P(x1, x2, . . . , xn) | < x1, x2, . . . , xn >}

b)

{x1, x2, . . . , xn | < x1, x2, . . . , xn >}

c)

{x1, x2, . . . , xn | x1, x2, . . . , xn}

d)

{< x1, x2, . . . , xn > | P(x1, x2, . . . , xn)}

78.

In domain relational calculus “there exist” can be expressed as

a)

(P1(x))

b)

(P1(x)) Э x

c)

V x (P1(x))

d)

Э x (P1(x))

79.

A set of possible data values is called

a)

Attribute

b)

Degree

c)

Tuple

d)

Domain

80.

When we want to display records with attributes from many relations then we use:

a)

SELECT operation

b)

PROJECT operation

c)

JOIN operation

d)

PERFORM operation

81.

Relational Calculus describes about

a)

'How' to evaluate a query

b)

'What' is to be retrieved

c)

'When' to evaluate a query

d)

'Not' to evaluate a query

82.

SELECT operator works _____ wise whereas PROJECT operator works _______ wise.

a)

Row, Column

b)

Column, Row

c)

Row, Row

d)

Column, Column

83.

In order to perform Union operation on two relations, both operand and relations must be

a)

Union compatible

b)

Set compatible

c)

Difference compatible

d)

User compatible

84.

Relational Calculus is of ______ types

a)

2

b)

3

c)

4

d)

5

85.

QBE stands for

a)

Query By Example

b)

Query By Entity

c)

Question By Example

d)

Question By Entity

Similar Resources on Wayground

Piggy Update Wave 3 :)

81 questions

Piggy Update Wave 3 :)

quiz

Worksheet

•

KG - Professional Dev...

01-Developer 1-85

83 questions

01-Developer 1-85

quiz

Worksheet

•

Professional Development

5/23 - IT Bridge Final Review

84 questions

5/23 - IT Bridge Final Review

quiz

Worksheet

•

Professional Development

Security+ Part 2 - Architecture and Design

80 questions

Security+ Part 2 - Architecture and Design

quiz

Worksheet

•

Professional Development

1-80

80 questions

1-80

quiz

Worksheet

•

Professional Development

DATA PROCESSING THIRD TERM EXAM

85 questions

DATA PROCESSING THIRD TERM EXAM

quiz

Worksheet

•

Professional Development

CONTENTS

83 questions

CONTENTS

quiz

Worksheet

•

Professional Development