Font size
WorksheetsDBMS
Total questions: 20
Worksheet time: 13mins
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
The database definition or descriptive information is also stored by the DBMS in the form of a _______________
Data catalog
excel file
document file
pdf file
The database and DBMS software together is called a ________________
Database system
Data Model
Application Program
System software
Which command is used to remove all rows from a table ?
Delete
Remove
Truncate
Both [A] and [B]
The statement in SQL which allows to change the definition of a table is
Alter
Update
Create
Select
Select the DBMS software
What is DBMS stands for
Database Manager Service
Database Management System
Database Manipulation Service
Data Business Management Service
Which of the following statements contains an error?
Select * from emp where empid = 10003;
Select empid from emp where empid = 10006;
Select empid from emp;
Select empid where empid = 1009 and lastname = ‘GELLER’;
To remove a relation from an SQL database, we use the ______ command.
delete
drop
remove
none of these
can a primary key be null
yes
no
A (a) is a database management system that is based on the relational model
(a) are used to identify which type of data we are going to store in the database
A (a) is a unique value that identifies a row in a table
A (a) is a language that enables users to access and manipulate data in a database.
A (a) is a part of DML involving information retrieval only.
A popular data manipulation language is (a) .
A (a) helps the user to systematically store information in the database
