Font size
WorksheetsDBMS Unit 1 Exam
Total questions: 50
Worksheet time: 33mins
(a) means that the data is accurate and consistent in the database.
What is DBMS stands for
Database Manager Service
Database Management System
Database Manipulation Service
Data Business Management Service
In an E-R diagram attributes are represented by
square
ellipse
rectangle
triangle
(a) statements or commands are used to define and modify the database structure of your tables or schema.
An entity set that does not have sufficient attributes to form a primary key is termed a (a)
Minimal super keys are also called-----------------
(a)
In a Hierarchical model records are organized as
(a)
In the architecture of a database system external level is the
(a)
What is SQL?
Standard Query Language
Structured Query Language
Sequence Query Language
None of the above
What is part of a database that holds only one type of information?
Report
Field
Record
File
Which of the following commands is used to save any transaction permanently into the database?
Commit
Rollback
Savepoint
None of the above
In E-R Diagram, weak entity is represented by.......
Rectangle
Square
Double Rectangle
Circle
This is an authorization command of SQL
Access
Grant
Allow
None of these
Intersection of rows and columns is called ..........
Table
Row
Column
Cell
A set of possible data values is called
Attribute
Degree
Tuple
Domain
The attribute refers to a _____ of a table
Record
Foreign key
Primary key
Field
This is an example of ________________
Data inconsistency
Data redundancy
Data security
Data consistency
A Database Management System (DBMS) is
Collection of interrelated data
Collection of programs to access data
Collection of data describing one particular enterprise
All of the above
Which of the following is not a level of data abstraction?
Physical Level
Critical Level
Logical Level
View Level
Data Manipulation Language enables users to
Retrieval of information stored in database
Insertion of new information into the database
Deletion of information from the database
All of the above
Select the DBMS software
Which of the following can add a row to a table ?
Add
Insert
Update
Alter
MySQL is
A Programming language
A Markup language
A technique for writing reliable programs
A Relational Database Management System
Which one will delete the table data as well as table structure?
DELETE
DROP
The table columns are also known as.....
Attributes
Fields
Records
Index
Key
What is the meaning of DCL?
Data Count Language
Database Control Language
Data Calculation Language
Data Control Language
Which of the following SQL clauses is used to DELETE tuples from a database table?
DELETE
REMOVE
DROP
CLEAR
The DBMS is a collection of interrelated __________ and a set of programs to access those data.
information
data
database
events
Data redundancy leads to which of the following problem?
Data Isolation
Data Security
Data Integrity
Data inconsistency
Which level of data abstraction describes how the data are stored in the database?
Physical level
Logical Level
View Level
All the Above
The overall design of the database is called _____________.
Data Model
Architecture
Schema
instance
Before use of DBMS information was stored using __________.
Cloud Storage
Data System
File Management System
Business Process Modeling
Which of the following is NOT the DDL command?
Drop
Create
Alter
Update
Which person is responsible for overall activities for database:
Database designer
Database analyst
Database Administrator
Database manager
Which level of database is viewed by user:
Internal level
External level
Conceptual
All of these
Which is the most popular database model:
Network Model
Relational Model
Hierarchical Model
Object Oriented
In database records are called:
Attributes
Entity
Tuples
Relations
The number of tuples of a relation is its:
Degree
Intension
Cardinality
Domain
The ---------- diagram gives a logical structure of the database graphically?
Entity - Relationship
Entity
Architectural Representation
Database
Which type of below DBMS is MySQL?
Object Oriented
Hierarchical
Relational
Network
Which is not a RDBMS?
MySql
Ms Access
Oracle
Ms word
A single entry in a table is called as
Row
Tuple
Record
All the above
The database and DBMS software together is called a ________________
Database system
Data Model
Application Program
System software
The database schema written in
HLL
DML
DDL
DCL
An Association between Student and a course is:
1:1 relationship
1:M relationship
M:N relationship
None of these
All the _____________ in a table are called fields.
rows
columns
cells
constraints
The statement in SQL which allows to change the definition of a table is
Alter
Update
Create
Select
Which of the following is an example of a DBMS
SQL
Microsoft Office
PHP
Oracle
ROLLBACK in a database is ____ statement.
(A) DDL
(B) DML
(C) DCL
(D) TCL
Q.3 In an E-R diagram an entity set is represented by a
(A) rectangle.
(B) ellipse.
(C) diamond box.
(D) circle.
