Free Printable GEM of DBMS

Worksheets

GEM of DBMS

Total questions: 60

Worksheet time: 53mins

Name

Class

Date

In relational data model, the total number of rows can be identified as ______________________ .

Cardinality

Degree

Attribute

Entity

Identify the total number of attributes in a relational data model.

Tuple

Entity

Degree

Cardinality

Identify the candidate key.

If related data exists in more than one table, they can be joined by using the Primary Key link to the same key in the other table. Identify this key.

Foreign Key

Primary Key

Candidate Key

Composite Key

Choose the CORRECT symbol of SELECT in the Relational Algebra

$\pi$

$\cap$

$\sigma$

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

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

A row in a database.

Record

Field

Entity

Table

A column in a database.

Field

Record

Entity

Validation

10.

A unique identifying field.

Primary Key

Integer

Verification

Boolean

11.

What language does the Relational Model use?

Java

Python

SQL

C++

12.

How many records are in this database?

13.

What is the primary key in this database?

Emp_Id

Last Name

Gender

Title

14.

Recognize the following that hold a single value attribute

Address

Reference

Subject_taken

15.

Based on the table given, identify the relation name.

AccoundID

Car Loan

Account

Balance

16.

What is E-R model used for?

To extract content from the database

To design and visualize database

To create a graphical user interface

17.

Which of the following relational algebra operations do not require the participating tables to be union-compatible?

unioin

intersection

difference

cartesian product

18.

The rule that a value of a foreign key must appear as a value of some specific table is called as

Referential constraint

Index

Integrity constraint

Domain constraint

19.

Minimal Superkeys are called

Primary key

Foreign key

Candidate key

Attribute keys

20.

Which of the following is not a restriction for a table to be a relation?

The cells of the table must contain a single value.

All of the entries in any column must be of the same kind.

The columns must be ordered.

No two rows in a table may be identical.

21.

v_num is Null

v_num is NOT Null

compilation error

runtime error

22.

Which error occurs while the program is running and cannot be detected by the PL/SQL compiler?

Syntax error

Runtime error

Both A & B

None of the above

23.

Which keyword is used instead of the assignment operator to initialize variables?

NOT NULL

DEFAULT

%TYPE

%ROWTYPE

24.

________ does not correlate with an oracle error, instead, user_define

exceptions usually enforce business rules in situations

in which an oracle error would not necessarily occur

Predefined Exception

Internal Exception

User defined Exception

None of the above

25.

Which choice shows what I will see on the screen after the following block is executed?

-1

VALUE_ERROR

-1

TOO_MANY_ROWS

NO ERROR

26.

Which SQL function is used to count the number of rows in a SQL query?

COUNT()

NUMBER()

SUM()

COUNT(*)

27.

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?

SELECT * FROM Persons WHERE FirstName=’a’

SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

SELECT * FROM Persons WHERE FirstName=’%a%’

28.

What does the ALTER TABLE clause do?

The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

The SQL ALTER TABLE clause is used to insert data into database table

THE SQL ALTER TABLE deletes data from database table

The SQL ALTER TABLE clause is used to delete a database table

29.

Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70

30.

Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.

SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition IN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition BETWEEN (‘sunny’, ‘cloudy’);

31.

What will be the degree and cardinality of the cartesian product of two tables if the degree of first table is 3 and second table is 5. The cardinality of first table is 10 and cardinality of second table is 6.

Degree 15, Cardinality 16

Degree 8 Cardinality 16

Degree 8 Cardinality 60

Degree 15 cardinality 60

32.

Which query is incorrect?

SELECT * FROM EMP WHERE CITY IN ('MUMBAI','DELHI','CHENNAI');

SELECT * FROM EMP WHERE CITY NOT IN ('MUMBAI','DELHI','CHENNAI');

SELECT * FROM EMP GROUP BY DEPT;

ALL THE ABOVE

33.

Which database level is closest to the users?

External

Internal

Physical

Conceptual

34.

Who developed the E-R model?

Codd

Chen

Date

Bachman

35.

E-R model uses which symbol for Weak entity

Rectangle

Diamond

Double rectangle

Dotted line

36.

What relationship is a mother to child

one to one

many to many

one to many

37.

What relationship is an actor to a film

one to one

many to many

one to many

38.

What relationship is a car to a car registration number?

one to one

many to many

one to many

39.

What you understand by data redundancy?

Assurance of the accuracy of data

Duplicate values in database

Security of Data

None of these

40.

A functional dependency is denoted by ….... symbol

→

41.

A functional dependency is a relationship between or among …….

Tables

Rows

Relations

Attributes

42.

There are two functional dependencies with the same set of attributes on the left side of the arrow: A→BC A→B This can be combined as

A→BC

A→B

B→C

None of the mentioned

43.

For a relation R(X, Y, Z, W) with primary key(X, Y) a functional dependency XY→Z is said to be ___________.

Full Dependency

Partial Dependency

Trivial Dependency

None of these

44.

If K → L then ___ → LM.

NONE

45.

There is a relationship AC →B, A →D, and D→B. Here A is alone capable of determining B, which means B is …....................dependent on AC

Partially

Fully

Medium

Short

46.

In a schema with attributes A, B, C, D and E following set of functional dependencies are given {A → B, A → C, CD → E, B → D, E → A} Which of the following functional dependencies is NOT implied by the above set?

CD → AC

BD → CD

BC → CD

AC → BC

47.

Find Closure set of Attribute for the following: R(A,B,C,D,E,F), FD: AB → C, BC → AD, D → E, CF → B, (AB)+=?

ABCDE

ABC

ABCDEF

48.

What is the Candidate Key for given FDs? FD : {EF→G ,F→IJ , EH→KL , K→M, L→N}

{GI}

{EFH}

{KL}

{IJ}

49.

Relation R has six attribute ABCDEF. F = { A → BC, B → CE, E → A, F → E} is a set of functional dependencies.How many candidate keys does the relation R have?

None of these

50.

Relation R has following attribute ABCDEF. F = { A → B, B → CE, E → A, F → E} is a set of functional dependencies. Which one is candidate key?

51.

For a given relation R has following attribute EFGHIJKLMN. What are prime attribute? FD : {EF→G ,F→IJ , EH→KL , K→M, L→N}

E,F,H

G,I

K,L

I,J

52.

Empdt1(empcode, name, street, city, state,pincode). For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in

1 NF only

2 NF and hence also in 1 NF

3NF and hence also in 2NF and 1NF

BCNF and hence also in 3NF, 2NF and 1NF View Answer

53.

Third Normal Form is ….........................

2NF and no transitive dependencies

2NF or no transitive dependencies

BCNF or no transitive dependencies

None of these

54.

In which normal form conversion of composite attribute to individual attribute happens,

First NF

Second NF

Third NF

None of these

55.

F = {CH → G, A → BC, B → CFH, E → A, F → EG} is a set of functional dependencies The relation R is

in 1NF, but not in 2NF.

in BCNF

in 3NF, but not in BCNF.

in 2NF, but not in 3NF.

56.

S1: Every table with two single-valued attributes is in 1NF, 2NF, 3NF and BCNF. S2: AB→C, D→E, E→C is a minimal cover for the set of functional dependencies AB→C, D→E, AB→E, E→C. Which one of the following is CORRECT?

Both S1 and S2 are FALSE.

S1 is FALSE and S2 is TRUE.

Both S1 and S2 are TRUE.

S1 is TRUE and S2 is FALSE.

57.

The table attached is an example of First Normal Form.

TRUE

FALSE

58.

A table is in 2NF if it is in 1NF and if

no column is not part of the primary key and is dependent on only a portion of the alternate key.

no column that is not a part of the primary key is dependent on only a portion of the primary key.

no column that is not a part of the primary key is dependent on only a portion of the foreign key.

no column that is not a part of the primary key is dependent on only a portion of the candidate key.

59.

Non-prime attributes cannot be transitively dependent, so the relation must have the ___ normal form.

First

Second

Third

Fourth

60.

THE ASSOCIATION OF 2 DIFFERENT ENTITIES ARE CALLED

DATA MODEL

RELATIONSHIP

ROW

ATTRIBUTE

100 %

GEM of DBMS

Total questions: 60

Worksheet time: 53mins

Similar Resources on Wayground