DBMS Basics

What is DBMS stands for

• Database Manager Service

• Database Management System

• Database Manipulation Service

• Data Business Management Service

_____________ are used to identify which type of data we are going to store in the database

Collection of information stored in a database at a particular moment is

• view

• schema

• instance

• none of the above

_______________________ IS A SYSTEMATIC COLLECTION OF DATA, EACH DATA IS RELATED TO EACH OTHER.

• DATABASE

• FILE SYSTEM

• FILE

The data model which describes how the data is actually stored is

• internal model

• external model

• logical model

• none of these

Count function in SQL returns the number of

• Values

• Distinct values

• Groups

• Columns

.......... can be facts related to any object in consideration. For example, your name, age, height, weight, etc

• DATABASE

• DATA

• FILE

• FILE SYSTEM

PROCESS DATA IS CALLED AS ______________

• DATA

• INFORMATION

• FACTS

A view of database that appears to an application program is known as

• schema

• subschema

• virtual table

• none of the above

Which command is used to remove all rows from a table ?

• Delete

• Remove

• Truncate

• Both [A] and [B]