wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

RDBMS-Revision

Total questions: 90

Worksheet time: 45mins

Name
Class
Date
1.

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)

2.

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;

3.

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';

4.

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

a)

Directory

b)

Sub Data

c)

Warehouse

d)

Meta Data

5.

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

6.

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

a)

Rows & Columns

b)

Fields

c)

Database

d)

Records

7.

A database is an organized collection of _______________.

a)

a. data

b)

b. Attributes

c)

c. Record

d)

d. None of the above

8.

Which of the following is not a database programs?

a)

a. MySQL

b)

b. Oracle

c)

c. Writer

d)

d. OObase

9.

Duplication of data is called _________.

a)

a. Inconsistency

b)

b. Consistency

c)

c. Redundancy

d)

d. Foreign Key

10.

Data Integrity means that data is accurate and consistent in the database.(T/F)

a)

a. True

b)

b. False

11.

A database can have only one table.(T/F)

a)

a. True

b)

b. False

12.

Which of the following will help to maintain unique record in the table?

a)

a. Foreign Key

b)

b. Primary Key

c)

c. Composite Key

d)

d. Alternate Key

13.

Which of the following field of table “Book” can act as primary key?

a)

a. Book_number

b)

b. Subject

c)

c. price

d)

d. Author_name

14.

When primary key is made up of two or more columns then it is called __ primary key

a)

a. Mixed

b)

b. Reference

c)

c. Composite

d)

d. Compost

15.

Duplicate values can be entered in primary key.(T/F)

a)

a. True

b)

b. False

16.

A key which is referring to the primary key of another table is called _______

a)

a. Alternate Key

b)

b. Primary Key

c)

c. First Primary Key

d)

d. Foreign Key

17.

A field which is ______ for each and every record is called Primary key.

a. Common

b. Same

c. Unique

d. None of the above

a)

a. Common

b)

b. Same

c)

c. Unique

d)

d. None of the above

18.

Identify the Foreign Key from table “Sales”

Table Client:

ClientID (primary Key)

clientname

clientphone

Table : Sales

SalesID (Primary Key)

ClientID

Profit

a)

a. SalesID

b)

b. Profit

c)

c. Clientphone

d)

d. ClientID

19.

There can be multiple primary key in a table.(T/F)

a. True

b. False

a)

a. True

b)

b. False

20.

___________ represent a single record in a table.

a)

a. Tuples

b)

b. Attributes

c)

c. Relation

d)

d. All of the above

21.

Every row in a table has the same structure.(T/F)

a)

True

b)

False

22.

__________ are used to identify which type of data we are going to store in the database.

a)

a. Datatype

b)

b. Record

c)

c. Table

d)

d. Attributes

23.

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

a)

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

b)

SELECT * FROM Persons WHERE FirstName like 'Peter'

c)

SELECT * FROM Persons WHERE FirstName<>'Peter'

d)

SELECT * FROM Persons WHERE FirstName<>'Peter'

e)

SELECT * FROM Persons WHERE FirstName=='Peter'

24.
With SQL, how can you insert a new record into the "Persons" table?
a)
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')  
b)
INSERT ('Jimmy', 'Jackson') INTO Persons
c)
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
d)
INSERT VALUES ('Jimmy, Jackson') INTO Persons
e)
INSERT ('Jimmy', 'Jackson') VALUES into Persons
25.

Which one of the following sorts rows in SQL?

a)

SORT BY

b)

ALIGN BY

c)

ORDER BY

d)

GROUP BY

e)

SORT

26.

The DROP TABLE statement:

a)

deletes the table structure only.

b)

deletes the table structure along with the table data.

c)

works whether or not referential integrity constraints would be violated.

d)

is not an SQL statement.

e)

deletes the data only.

27.

The primary key of a table which is present in another table for referencing is known as (a)  

28.

An (a)   is the secondary candidate key that contains all the property of a candidate key but is an alternate option

29.

Which constraint(s) can be used to make sure that the column is not left empty?

a)

NOT NULL

b)

UNIQUE

c)

PRIMARY KEY

d)

ALL THE ABOVE

30.

Example of Processed data is

a)

Red

b)

The color of my car is red

c)

Car

d)

Color

31.

Choose all the DBMS software

a)

Oracle

b)

Mysql

c)

Excel

d)

Word

e)

Foxpro

32.

________________ and ______________ are the two types of Database

a)

Flat file and Relational file

b)

Flat file and Word file

c)

Relational file and Word file

d)

Word file and Excel file

33.

Choose all the statement true about flat file

a)

Can store data in a single Table

b)

Tables are inter-related

c)

Suitable to store small amount of data

d)

Can have duplicate values

e)

Can accidently delete an important data

34.

Choose all the statement true about Relational Database Management System

a)

Can store data in multiple tables that are inter-related

b)

Developed using 13 golden rules of E F Codd

c)

Avoids Duplicate Data

d)

Cannot run complex queries

e)

Better security and easy upgradation of the existing software is available.

35.

Dedicated computers that holds the data and the database software is called

a)

Server

b)

Client

c)

Front end

d)

None of the above

36.

A unique value that individually identifies each row in a RDBMS table is called

a)

Foreign Key

b)

Primary key

c)

Candidate key

d)

Composite key

37.

Primary key constraint applied on more than one column is called

a)

Primary key

b)

Candidate key

c)

Foreign Key

d)

Composite key

38.

Constraints on primary key are

a)

Cannot be left null and cannot have duplicate value

b)

Can be left null and cannot have duplicate value

c)

Cannot be left null and can have duplicate value

d)

Can be left null and can have duplicate value.

39.

A key that refers to the primary key of another table and used for table inter relationship is called

a)

Foreign key

b)

Primary key

c)

Candidate key

d)

Composite key

40.

Keys in an RDBMS table that can be used as primary key also but are not primary key are called

a)

Foreign key

b)

Primary key

c)

Candidate key

d)

Composite key

41.

Correct Syntax of 'SELECT' DML commands is

a)

SELECT * FROM <TABLE_NAME>

b)

SELECT FIELD1,FIELD2... FROM <TABLE_NAME> WHERE <CONDITION>

c)

SELECT FIELD1,FIELD2... FROM <TABLE_NAME>

d)

SELECT FIELD1,FIELD2... FROM <TABLE_NAME> WHERE <CONDITION> ORDER BY <FIELD_NAME> ASC/DESC

42.

Identify theDBMS software from the following

a)

Microsoft Word

b)

Microsoft Access

c)

Open Office Writer

d)

Open Office Spreadsheet

43.

In ------- model data is stored in multiple tables and the tables are linked using a common field.

a)

Relational

b)

flat file

c)

word

d)

presentation

44.

A foregin key is a unique value that identifies a row in a table.

a)

True

b)

false

45.

A table has a defined number of columns but can have any number of ,rows

a)

True

b)

False

46.

Each question that we ask about our ITEM is a field.

a)

True

b)

False

47.

____________KEY IS A SUBSET OF CANDIDATE KEY

a)

Foreign Key

b)

Alternate Key

c)

Super Key

d)

Composite Key

48.

A CANDIDATE KEY CAN NEVER BE (a)   OR EMPTY

49.

KEY CAN BE ________ ATTRIBUTE OR _____________ATTRIBUTE WHERE THE COMBINATION MAY ACT AS A KEY

(a)  

50.

__________ IS A CANDIDATE KEY THAT IS MOST APPROPRIATE TO BECOME THE MAIN KEY FOR ANY TABLE.

a)

Candidate Key

b)

Primary Key

c)

Composite Key

d)

Foreign Key

51.

CANDIDATE KEY WHICH ARE NOT SELECTED AS PRIMARY KEY ARE KNOWN AS ___________ OR __________

a)

FOREIGN KEY

b)

SECONDARY KEY

c)

ATTERNATIVE KEY

d)

PRIMARY KEY

52.

(a)   ATTRIBUTES ARE ATTRIBUTES OTHER THAN PRIMARY KEY ATTRIBUTE

53.

THE COMPOSITE KEY ARE NOT A KEY (a)   OR INDIVIDEALLY

54.

(a)   attributes are the attributes or fields of a table, other than candidate key attributes/fields in a table.

55.

........... is the process of minimizing redundancy from a relation or set of relations.

a)

Normalization

b)

Data redundancy

c)

Data consistency

d)

Schema

56.

.......... is the process of organizing the data in the database.

a)

Schema

b)

Normalization

c)

Instance

d)

Transaction

57.

................. form disallows the multi-valued attribute, composite attribute, and their combinations.

a)

1 NF

b)

2 NF

c)

3 NF

d)

4 NF

58.

.......... is used to reduce the data duplication.

a)

1 NF

b)

2 NF

c)

3 NF

d)

4 NF

59.

A ........... can be defined as a group of tasks.

a)

Transaction

b)

Normalization

c)

Schema

d)

Instance

60.

A .............. is a very small unit of a program and it may contain several low-level tasks.

a)

Attribute

b)

Table

c)

Normalization

d)

Transaction

61.

Atomicity, Consistency, Isolation, and Durability − commonly known as ........... properties

a)

AID

b)

ADIC

c)

ACID

d)

DBMS

62.

An .............. can be a real-world object, either animate or inanimate, that can be easily identifiable.

a)

Entity

b)

Entity set

c)

Attribute

d)

Transaction

63.

.......... is an attribute or collection of attributes that uniquely identifies an entity among entity set.

a)

Relations

b)

Attribute

c)

Weak entity

d)

Key

64.

............ are the properties of entities.

a)

Domain

b)

Attributes

c)

Relations

d)

Field

65.
The HAVING clause does which of the following?
a)
Acts like a WHERE clause but is used for groups rather than columns.
b)
Acts like a WHERE clause but is used for rows rather than columns.
c)
Acts like a WHERE clause but is used for columns rather than groups.
d)
Acts EXACTLY like a WHERE clause.
e)
Acts like a WHERE clause but is used for groups rather than rows.
66.
Which of the following function cannot be performed by SQL ?
a)
Setting permissions on tables
b)
Creating views in a database
c)
Updating records
d)
Creating Complex UI
e)
Delete database
67.

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.

a)

Degree 15, Cardinality 16

b)

Degree 8 Cardinality 16

c)

Degree 8 Cardinality 60

d)

Degree 15 cardinality 60

68.

The restrictions or conditions applied on data are known as (a)  

69.

What will be the output?

SELECT ROUND(36.7894,2)

a)

36.78

b)

38.79

c)

36.7

d)

36

70.

What will be the output?

SELECT TRUNCATE(36.5643,2);

a)

36.56

b)

36.57

c)

36.5643

d)

36

71.

Write a query to display the details of employees of emp table whose sal is within the range 10000 and 50000.

(a)  

72.

Which is the correct query to delete the rows of employees whose exp is less than 10.

a)

DELETE * FROM EMP WHERE EXP<10;

b)

DELETE FROM EMP;

c)

DELETE FROM EMP WHERE EXP<10;

d)

DELETE FROM EMP WHERE EXP>10;

73.

____ is a minimal set of columns used to uniquely define any row in a table.

a)

keys

b)

values

c)

strings

d)

none of the above

74.

______________ of two tables produces a table with rows that are present in the first table but not in the second table and _____________ operation creates a new table from the existing table.

a)

Assignment, Difference

b)

Union, projection

c)

Difference , assignment

d)

Difference, Cartesian

75.

Expand ACID.

a)

Atomicity, Consistency ,Integrity , Dependability

b)

Atomicity, Concatenation,Isolation , Durability

c)

Atomicity, Consistency, Isolation, and Durability

d)

Atomic, Consistent, Independent, Durable

76.

____________is the process of joining tables that were decomposed during normalization process.

a)

Normalisation

b)

Combine

c)

Denormalisation

d)

Keys

77.

Under Which dependency the following table comes under?

a)

Partial Dependency

b)

Full Dependency

c)

Transitive dependency

d)

Functional dependency

78.

Create table student(rollno number primary key, student_name varchar2(20),marks number(2),result number(2). Table is of degree (a)  

79.

Is the table in 1NF ?

a)

True

b)

False

80.

POWER(5,3)

a)

15

b)

53

c)

25

d)

125

81.

ABS(-1000)

a)

-1

b)

-1000

c)

+1

d)

1000

82.

SIGN(+50)

a)

+1

b)

-1

c)

50

d)

51

83.

MOD(3,5)

a)

3

b)

5

c)

2

d)

1

84.

FLOOR(54.7)

a)

54

b)

55

c)

54.0

85.

CEIL(54.3)

a)

54

b)

54.0

c)

55

d)

54.5

86.

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

a)

SELECT* FROM PERSONS WHERE FIRSTNAME='%a%';

b)

SELECT* FROM PERSONS WHERE FIRSTNAME LIKE %a;

c)

SELECT* FROM PERSONS WHERE FIRSTNAME LIKE a%;

d)

SELECT* FROM PERSONS WHERE FIRSTNAME ='A'

87.

With SQL, how can you return the number of records in the "Persons" table?

a)

SELECT NO(*) FROM Persons

b)

SELECT COUNT(*) FROM Persons

c)

SELECT COLUMNS(*) FROM Persons

d)

SELECT LEN(*) FROM Persons

88.

The relational data model was invented by

a)

Edgar Codd

b)

Tim Berners Lee

c)

James Gosling

d)

Dennis Ritchie

89.

Commercial RDBMS products from numerous vendors started to appear about

a)

1970

b)

1980

c)

1990

d)

1991

90.

What action does ⋈ operator perform in relational algebra

a)

Output specified attributes from all rows of the input relation and remove duplicate tuples from the output

b)

Outputs pairs of rows from the two input relations that have the same value on all attributes that have the same name

c)

Output all pairs of rows from the two input relations (regardless of whether or not they have the same values on common attributes)

d)

Return rows of the input relation that satisfy the predicate

Similar Resources on Wayground

A+Core 1 (200-300)#3

92 questions

A+Core 1 (200-300)#3

quiz

Worksheet

•

10th Grade - University

ITPC12 Reviewer ch1

85 questions

ITPC12 Reviewer ch1

quiz

Worksheet

•

University

Final Exam Prep Review

87 questions

Final Exam Prep Review

quiz

Worksheet

•

University

PS Review

91 questions

PS Review

quiz

Worksheet

•

University

Batch-2_Test-2

87 questions

Batch-2_Test-2

quiz

Worksheet

•

University

Koshkarbaeva 41 Part 1

93 questions

Koshkarbaeva 41 Part 1

quiz

Worksheet

•

University

CBT1

85 questions

CBT1

quiz

Worksheet

•

University

STEP 3 - Lockdown 3.0 Review

87 questions

STEP 3 - Lockdown 3.0 Review

quiz

Worksheet

•

University