Font size
WorksheetsDBMS
Total questions: 52
Worksheet time: 26mins
Which of the following is an example of a DBMS
SQL
Microsoft Office
PHP
Oracle
Which of the following is a property of database
Represents some aspect of the real world
Logically related collection of data
Built, and populated with data for a specific purpose
All the above
A database management system (DBMS) is a collection of programs that enables users to
create a database
manipulate a database
both create and manipulate a database
for storing data only
The database definition or descriptive information is also stored by the DBMS in the form of a _______________
Data catalog
excel file
document file
pdf file
The database and DBMS software together is called a ________________
Database system
Data Model
Application Program
System software
Which of the following are characteristics of a DBMS
Self-Describing
Support Multiple Views
Single user systems
Data Sharing
Who is responsible for authorizing access to the database, coordinating and monitoring its use
Database programmer
System Analyst
DBA
Specialised user
Which type of users specify their requests using sophisticated database queries
Parametric users
Casual end user
Specialised user
DBA
Who is responsible for determining requirements of end users
DBA
Database Designer
Application Programmer
System Analyst
The data model which describes how the data is actually stored is
internal model
external model
logical model
none of these
Data about data is normally termed as
directory
data bank
meta data
none of the above
A view of database that appears to an application program is known as
schema
subschema
virtual table
none of the above
Collection of information stored in a database at a particular moment is
view
schema
instance
none of the above
DBA stands for
Data Bank Access
Database Access
Data Bank Administration
Database Administrator
Data items grouped together for storage purposes are called a :
Record
title
list
string
Which command is used to remove all rows from a table ?
Delete
Remove
Truncate
Both [A] and [B]
What is the language used by most of the DBMS for helping their users to access data ?
High level language
Query language
SQL
4GL
This is an authorization command of SQL
Access
Grant
Allow
None of these
The statement in SQL which allows to change the definition of a table is
Alter
Update
Create
Select
Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.
Relational
Structural
Procedural
Fundamental
Which of the following is used to denote the selection operation in relational algebra?
Pi
Sigma
Lambda
Omega
For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigma.
Predicates, relation
Relation, Predicates
Operation, Predicates
Relation, Operation
The ___________ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.
Union
Set Difference
Division
Intersection
Which is a join condition contains an equality operator:
Equi Join
Cartesian
Natural
Left
In precedence of set operators, the expression is evaluated from
Left to Right
Right to Left
From user specification
Left & Right both in parallel
Which of the following is the comparison operator in tuple relational calculus
⇒
=
ε
All of these
A set of possible data values is called
Attribute
Degree
Tuple
Domain
When we want to display records with attributes from many relations then we use:
SELECT operation
PROJECT operation
JOIN operation
PERFORM operation
SELECT operator works _____ wise whereas PROJECT operator works _______ wise.
Row, Column
Column, Row
Row, Row
Column, Column
In order to perform Union operation on two relations, both operand and relations must be
Union compatible
Set compatible
Difference compatible
User compatible
QBE stands for
Query By Example
Query By Entity
Question By Example
Question By Entity
An entity is a
object of relation
present working model
thing in real world
model of relation
Which of the following is not a component of ER Model in DBMS?
entity
database
attribute
relationship
A relationship is
an item in an application
a meaningful dependency between entities
a collection of related entities
a related data
Entity is represented as
ellipse
double ellipse
rectangle
double rectangle
In one to many relationship, the entity that is on the one side of relationship is called
subtype
child
instance
parent
Property that describes the characteristics of entity is
entities
relationship
attributes
identifiers
Entities can be associated with one another in which of the following
attribute
identifiers
entities
relationship
By relation cardinality we mean
number of items in a relationship
number of relationships in which an entity can appear
number of items in an entity
number of entity sets which may be related to a given entity
If an entity appears in N relationship then it is
a 1:1 relationship
a 1:N relationship
a N:1 relationship
a N:M relationship
Attributes are
properties of relationship
attributed to entities
properties of members of an entity set
In ER diagram relationships is represented by
circles
rectangles
ellipse
diamond shaped box
One entity may be
related to only one other entity
related to itself
related to only two other entities
related to many other entities
Given the basic ER and relational models, which of the following is INCORRECT?
An attribute of an entity can have more than one value
An attribute of an entity can be composite
In a row of a relational table, an attribute can have more than one value
In a row of a relational table, an attribute can have exactly one value or a NULL value
Consider the following ER diagram. The minimum number of tables needed to represent M, N, P, R1, R2 is:
2
3
4
5
Which of the following is NOT a basic element of all versions of the E-R model?
Entities
Attributes
Relationships
Primary keys
zero or one
Which is the correct and the best conversion of the ER diagram below to the relational model
Country(Country_name,no_of_states)
Capital(Capital_name,coordinator)
Country(Country_name,no_of_states,Capital_name)
Capital(Capital_name,coordinator)
Country(Country_name,no_of_states)
Capital(Capital_name,coordinator,Country_name)
Country_Capital(Country_name,no_of_states,Capital_name,coordinator)
In figure below what is the best way to model the Supplier and Project entity types and Supplies relationship type to relational schema
Supplier(Sname)
Project(Proj_name)
Supplier(Sname, Proj_name)
Project(Proj_name)
Supplier(Sname)
Project(Proj_name, Sname)
Supplier(Sname)
Project(Proj_name)
Supplies(Sname, Proj_name)
Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?
Weak entity
Strong entity
ID-dependent entity
ID- independent entity
