NEW
Font size
S
M
L
XL
Worksheets25 JUNE 21 DBMS FOR COE 6:30 TO 7:30 PM
Total questions: 24
Worksheet time: 12mins
Name
Class
Date
1.
Replacement of this query would be<br /><br />SELECT name, course_id <br />FROM instructor, teaches <br />WHERE instructor_ID= teaches_ID; <br />
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;
2.
Which one of the following queries contains an 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';
3.
A Database Management System is a type of _________software.
a)
System
b)
Application
c)
General
d)
Both A and C
4.
Rows of a relation are known as the _______.
a)
Tuple
b)
Degree
c)
Entity
d)
All the above
5.
Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
a)
DML
b)
DDL
c)
query
d)
Relational schema
6.
Which forms are based on the concept of functional dependency
a)
1NF
b)
2NF
c)
3NF
d)
4NF
7.
Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
a)
DML
b)
DDL
c)
query
d)
relational schema
8.
DELETE FROM r; //r - relation<br />This command performs which of the following action?
a)
remove relation
b)
clear realtion entries
c)
delete fields
d)
delete rows
9.
Which of the following statements contains an 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’;
10.
To include integrity constraint in an existing relation use
a)
Create table
b)
Modify table
c)
Alter table
d)
Drop table
11.
1.DBMS Applications Store:<br />
a)
Data in a tabular form
b)
Data as file
c)
Data consistent
d)
Data definition language
12.
In case of entity integrity, the primary key maybe
a)
Not null
b)
Null
c)
Both a and b
d)
Any value
13.
How many types of database languages are there:
a)
3
b)
5
c)
4
d)
6
14.
The method of access which uses key transformation is known as
a)
Direct
b)
Hash
c)
Random
d)
Sequential
15.
The statement in SQL which allows changing the definition of a table is
a)
Alter
b)
Update
c)
Delete
d)
Select
16.
Which model designs the data in form of rows and columns within a table?
a)
Relational data model
b)
Semistruced data model
c)
Object-based data model
d)
Entity-relationalship data model
17.
Which one of the following refers to the copies of the same data (or information) occupying the memory space at multiple places.
a)
Data Redundancy
b)
Data Inconsistency
c)
Data Repository
d)
Data Mining
18.
A huge collection of the information or data accumulated form several different sources is known as ________:
a)
Data Mining
b)
Data Management
c)
Data Warehouse
d)
Both A and C
19.
What do you mean by one to many relationships?
a)
One class may have many teachers
b)
One teacher can have many classes
c)
Many classes may have many teachers
d)
Many teachers may have many classes
20.
The term "FAT" is stands for_____
a)
File Allocation Tree
b)
File Allocation Table
c)
Both A & B
d)
None of the above
21.
Which one of the following given statements possibly contains the error?
a)
select empid where empid = 1009 and Lastname = 'GELLER';
b)
select empid from emp;
c)
select * from emp where empid = 10003;
d)
select empid from emp where empid = 10006;
22.
"The given Query can also be replaced with_______:<br /><br />SELECT name, course_id <br />FROM instructor, teaches <br />WHERE instructor_ID= teaches_ID; "
a)
Select course_id from instructor join teaches;
b)
Select name, course_id from instructor natural join teaches;
c)
Select name, course_id from instructor;
d)
Select name,course_id from teaches,instructor where instructor_id=course_id;
23.
Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?
a)
Data Manipulation Language
b)
Query
c)
Relational Schema
d)
Data Definition Language
24.
What do you mean by one to many relationships?
a)
One class may have many teachers
b)
One teacher can have many classes
c)
Many classes may have many teachers
d)
Many teachers may have many classes
Reset
