NEW
Font size
WorksheetsITD11303 DATABASE
Total questions: 35
Worksheet time: 18mins
The DBMS acts as an interface between what two components of an enterprise-class database system?
Database application and SQL
Data and the database
The user and the database application
Database application and the database
The following are components of a database except ________ .
user data
metadata
reports
indexes
An application where only one user accesses the database at a given time is an example of a(n) ________ .
single-user database application
multiuser database application
e-commerce database application
data mining database application
SQL stands for ________ .
Structured Question Language
Sequential Query Language
Structured Query Language
Sequential Question Language
The following are functions of a DBMS except ________ .
creating and processing forms
creating databases
processing data
administrating databases
Helping people keep track of things is the purpose of a(n) ________ .
table
database
instance
relationship
Software that defines a database, stores the data, supports a query language, produces reports and creates data entry screens is a(n) ________ .
Data dictionary
Database Management System
Decision Support System
Relational database
Which of the following items is not the advantage of a DBMS?
Improved ability to enforce standards
Improved data consistency
Local control over the data
Minimal data redundancy
Which is the database language?
C
C++
SQL
PHP
DBMS should provide following features ___________.
All of these
Safety of the information stored
Authorized access
Protect the data from the system crash
Before the use of DBMS, information was stored using _______.
File management system
Data system
Cloud storage
Single database
___________ command can be used to modify a column in a table.
Alter
Update
Set
Create
An advantage of the database management approach is ______.
Data is dependent on programs
Data redundancy increase
Data is integrated and can be accessed by multiple programs
Data is inconsistent
DML is provided for ______.
Description of logical structure of database
Addition of new structures in the database system
Manipulation & processing of database
Definition of physical structure of database system
Disadvantages of file-systems to store data is ______.
Data redundancy & inconsistency
Difficult in accessing data
Data isolation
All of the above
DML 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
The database environment has all of the following components except _______.
Users
Separate files
Database
Database Administrator
Between the users and the database itself, a DBMS will act as ____
Barrier
Interface
referee
obstacle
A database management system (DBMS) is a _____.
hardware system used to create, maintain, and provide controlled access to a database.
hardware system used to create, maintain, and provide uncontrolled access to a
database.
software system used to create, maintain, and provide controlled access to a database.
software system used to create, maintain, and provide uncontrolled access to a
database.
Data administrators are responsible for _____.
physical database design
managing technical issues in the database environment
overall management of data resources in an organization
writing application programs
Some advantages of the database approach include all, but _____.
minimal data redundancy
improved data consistency
improved data sharing
program-data dependency
An advantage of the database approach is the creation of maximum data redundancy.
True
False
The source of the data is sometimes called the system of record.
True
False
The database approach requires additional costs and risks.
True
False
The most common source of database failures in an organization is the failure to implement a
strong database administration function.
True
False
Information stored in information repository can be accessed by ____.
Client servers
Host computers
Security managers
Database administrators
A _____ is used to define overall design of the database.
Schema
Application program
Data definition language
Data manipulation language
Which of the following is not the DDL statements?
Create
Insert
Drop
Alter
Which of the following DBMS types is not a classification based on a data model?
Relational Data Model
Hierarchical Data Model
Network Data Model
Cloud Data Model
Which of the following are part of the Query Processor?
DDL Compiler
Connection Manager
Transaction Manager
. DML Compiler
A characteristic of a file server is which of the following ____ .
Manages file operations and is shared on a network
Manages file operations and is limited to one PC
Acts as a fat client and is shared on a network
Acts as a fat client and is limited to one PC
The conceptual design ____.
is a documentation technique.
needs data volume and processing frequencies to determine the size of the database.
involves modelling independent of the DBMS.
is designing the relational model.
An ________ is a set of entities of the same type that share the same properties, or attributes.
Entity set
Attribute set
Relation set
Entity model
The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called ______________
Simple attribute
Composite attribute
Multivalued attribute
Derived attribute
What are you not supposed to do in the implementation phase?
Setting Up a DBMS
Creating a Database
Data Downloading/Changing
Database Testing
