Worksheetsdbms
Total questions: 25
Worksheet time: 15mins
Which of the following is an example of a DBMS
SQL
Microsoft Office
PHP
Oracle
A database management system (DBMS) is a collection of programs that enables users to
create a database
manipulate a database
both create and manipulate a database
for storing data only
Who is responsible for authorizing access to the database, coordinating and monitoring its use
Database programmer
System Analyst
DBA
Specialised user
Who is responsible for determining requirements of end users
DBA
Database Designer
Application Programmer
System Analyst
DBA stands for
Data Bank Access
Database Access
Data Bank Administration
Database Administrator
Which command is used to remove all rows from a table ?
Delete
Remove
Truncate
Both [A] and [B]
Which of the following is not an example of DBMS?
MySQL
Microsoft Access
IBM DB2
What does SQL stand for?
Structured Query Language
Sequential Query Language
Structured Question Language
Systematic Query Language
Which SQL clause is used to filter rows from a result set?
WHERE
SELECT
FROM
GROUP BY
Which of the following is an example of a DDL (Data Definition Language) statement?
SELECT
INSERT
CREATE
UPDATE
An ordered set of data constituting a record is called
Attribute
Row
Tuple
Field
________ have the control over the database
DBA
Application programmers
Specialized users
Sophisticated users
How many types of DBMS architectures are there?
1
2
3
4
Which command is used to retrieve data from a database in SQL?
RETRIEVE
GET
SEARCH
SELECT
What command is used to create a new table in SQL?
UPDATE TABLE
ADD TABLE
CREATE TABLE
INSERT TABLE
Which command is used to add a new column to an existing table in SQL?
UPDATE TABLE
ALTER TABLE
ADD COLUMN
CREATE TABLE
Which command is used to delete a table in SQL?
DELETE TABLE
ERASE TABLE
REMOVE TABLE
DROP TABLE
What is a database?
Organized collection of information that cannot be accessed, updated, and managed
Collection of data or information without organizing
Organized collection of data or information that can be accessed, updated, and managed
Organized collection of data that cannot be updated
Data about data is ______________
Data Description
Metadata
Data redundancy
Data inconsistency
Repetition of data is called data ..............
dependance
redundancy
inconsistency
isolation
Mismatched redundant copies of data is known as data ............
dependance
redundancy
inconsistency
isolation
A ............ is an organized collection of structured data.
information
file
database
DBMS
