DBMS Class 10

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 and DBMS software together is called a ________________

• Database system

• Data Model

• Application Program

• System software

Data about data is normally termed as

• directory

• data bank

• meta data

• none of the above

What is the language used by most of the DBMS for helping their users to access data ?

• High level language

• Query language

• SQL

• 4GL

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

DBMS can summarise the data stored in the database and produce an easy to read _____:

• reports
• queries
• tables
• criteria