NEW
Font size
WorksheetsMidterm InfoTech2
Total questions: 20
Worksheet time: 15mins
What is DBMS?
DBMS is a collection of queries
DBMS is a high-level language
DBMS is a programming language
DBMS stores, modifies and retrieves data
DBMS is a collection of queries
Edgar Codd
Charles Bachman
Charles Babbage
Sharon Codd
In which of the following formats data is stored in the database management system?
image
text
table
Graph
Which of the following is NOT a type of database?
Decentralized
Distributed
Cloud
Object-oriented
Which of the following is not an example of DBMS?
MySQL
Microsoft Access
IBM DB2
Which of the following is not a function of the database?
Managing stored data
manipulating data
Security for stored data
Analyzing code
Which of the following is known as a set of entities of the same type that share same properties, or attributes?
Relation set
Tuples
Entity set
Entity Relation model
What does an RDBMS consist of?
collection of records
collection of keys
collection of tables
collection of fields
The DBMS acts as an interface between ________________ and ________________ of an enterprise-class system.
Data and the DBMS
Application and SQL
Database application and the database
The user and the software
The ability to query data, as well as insert, delete, and alter tuples, is offered by ____________
TCL (Transaction Control Language)
DCL (Data Control Language)
DDL (Data Definition Langauge)
DML (Data Manipulation Langauge)
The oldest DB model is
Network
Physical
Hierarchical
Relational
Which of the following establishes a top-to-bottom relationship among the items?
Relational schema
Network schema
Hierarchical schema
All of these
In any hierarchy of data organization, the smallest entity to be processed as a single unit is called
data field
data record
data file
database
What name is given to the collection of facts, items of information or data which are related in some way?
database
directory information
information tree
information provider
A database management system
Allows simultaneous access to multiple files
Can do more than a record management system
Is a collection of programs for managing data in a single file
None of the above
In which state one gathers and list all the necessary fields for the database design project.
Data definition
Data refinement
Establishing Relationship
None of these
The function which causes the retrieval of any kind of data from database is considered as
key
query
structure
storing cycle
DBMS helps achieve
Data independence
Centralized control of data
Neither A or B
Both A and B
Which of the following are the properties of entities?
Groups
Tables
Attributes
Queries
A collection of interrelated records is called a
Database
Spreadsheet
Management information system
Text file
