BCAC0005 DBMS Quiz-1

What are databases mainly used for?

• To store archived data

• To store and organise data

• To analyse data

Which of the following statements best defines the word 'database'?

• A database is a collection of data or information which is stored in a logical and structured way

• A database is a collection of statistics stored only for computers.

• A database does not collect data or information.

Which of the following uses paper-based databases?

• Phonebook

• Smart Phone

• Computer

Which software program do we use to create a database

• Microsoft Excel

• Microsoft Word

• Microsoft Access

• Microsoft Publisher

A column in a database is better known as a...

• Record

• Query

• Field

• Form

A row in a database is better known as

• Record

• Query

• Field

• Form

In a database, Multiple _________ can be created.

• Tables

• Documents

• Primary Key

• All of these

This table has ___________ records.

• 2

• 4

• 5

• 6

This table has ___________ fields.

• 2

• 4

• 5

• 6

___________, ___________ & ___________ are fields.

• S. No, Product Code & Description

• 1021, Beverages & Soft drinks, coffees, teas

• Dairy Products, Beverages & Seafood.

• All of these are fields.