Font size
WorksheetsDBMS_UNIT1
Total questions: 20
Worksheet time: 20mins
A relational database consists of a collection of
Tables
Records
Fields
Keys
Database __________ which is the logical design of the database,and the database _______ which is a snapshot of the data
Instance, Schema
Relation, Domain
Relation, Schema
Schema, Instance
Which of these is not true in case of responsibilities of Database Administrator?
Acquiring hardware and software resources
Authorizing access to Database
Data entry in to the database
All the above statements are true
Architecture of the database can be viewed as
two levels
four levels
three levels
five levels
QEE stands for
Question Evaluation Engine
Query Evaluation Engine
Query Enterprise Engine
None of the above
Which of the following are keys in DBMS?
Foreign Key
Primary Key
Super Key
Embedded Key
A candidate key is called a minimal super key
True
False
Which of the following is not present in Storage Manager?
Buffer Manager
Transaction Manager
Query Manager
File Manager
The term attribute refers to_____of a table
Record
Column
Tuple
Key
Which one of the following attribute can be taken as a primary key?
Name
Street
ID
Department
File System is an advantage over DBMS
True
False
π is which relational operator
Selection
Projection
Union
Cartesian Product
⨝ is a natural join operator
True
False
Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
Candidate key
Sub key
Super key
Foreign key
Using which language can a user request information from a database?
Query
Relational
Structural
Compiler
Which one of the following is a procedural language?
Domain relational calculus
Relational algebra
Tuple relational calculus
Query language
The _______operation performs a set union of two “similarly structured” tables
Union
Product
Join
Intersect
Which one of the following cannot be taken as a primary key?
Id
Dept_id
Register number
Street
Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________
Relations, Attribute
Tuple, Relation
Attributes, Relation
Tuple, Attributes
A domain is atomic if elements of the domain are considered to be ____________ units.
Different
Constant
Indivisible
Divisible
