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

Which of the following is a property of database

• Represents some aspect of the real world

• Logically related collection of data

• Built, and populated with data for a specific purpose

• All the above

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 of the following are characteristics of a DBMS

• Self-Describing

• Support Multiple Views

• Single user systems

• Data Sharing

Data items grouped together for storage purposes are called a :

• Record

• title

• list

• string

Count function in SQL returns the number of

• Values

• Distinct values

• Groups

• Columns

The statement in SQL which allows to change the definition of a table is

• Alter

• Update

• Create

• Select