Worksheets12 C.APP -LS 3 INTRO. TO DBMS
Total questions: 20
Worksheet time: 14mins
Which language is used to request information from a Database?
Relational
Structural
Query
Compiler
An entity set that does not have enough attributes to form primary key is known as
Strong entity set
Weak entity set
Identity set
Owner set
Which type of below DBMS is MySQL?
Object Oriented
Hierarchical
Relational
Network
The structure representing the organizational view of entire database is known as in MySQL database
Schema
View
Instance
Table
To prevent the conflict in database update, the transfer actions are isolated from other user and serialized. This is called as ……………………….
Atomicity
Consistency
Isolation
Degree of Consistency
IDS stands for ……………………..
Integrated Data Store
Indian Data Store
Integrated Data Service
Integrated Decide Service
Which of the two databases models are similar?
Hierarchical, Network
Network, relational
Relational, Object oriented
Network, Object oriented
Columns are otherwise called as …………………….
(a)
Object oriented model uses small, reusable software known as ………………………
objects
software
class
private
Each super key is called as ……………………… key.
Sub
Candidate
Schema
Constraint
How many basic concepts are there in ER model?
2
3
4
5
What is the symbol for weak Entity?
square
double square
rectangle
double rectangle
……………………. describes a unique characteristic of an entity.
(a)
How many types of attributes are there?
3
4
5
6
Customer places the order is an example of ……………………. relationship
one to one
one to many
many to many
two to many
The structured collection of data is ……………………..
data
Table
Row
Database
Multiple numbers of values are not allowed in ………………………. attributes.
single valued
composite
multi valued
key
The existing record in a table is removed from the table using ………………………. command.
Delete
Drop
Update
Insert
Write a SQL command to create a table as EMP of field as follows
1. eno 2. ename 3. esalary 4. Address
Write a SQL command to alter the table by adding a new field mobile number.
