DBMS

Which of the following is not a DBMS despite having database capabilities:

• Microsoft Excel or similar spreadsheets
• Oracle
• MySQL
• Microsoft Access or similar

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

All DBMS systems use SQL as a command language.

• False
• True

Select the DBMS software

• 
• 
• 
• 

What is DBMS stands for

• Database Manager Service

• Database Management System

• Database Manipulation Service

• Data Business Management Service