Chap#10 Basic Concepts and Terminology

Question 1

Insert command is used to insert:

Answer 1

a new record

Question 2

Create command is used to create a:

Answer 2

Table

Question 3

SQL is used for:

Answer 3

Data definition and manipulation

Question 4

The foreign key is found in:

Answer 4

Dependant table

Question 5

A table must have:

Answer 5

Primary Key

Question 6

How many components are present in database?

Answer 6

Five

Question 7

DBA is a:

Answer 7

Database manager

Question 8

IDE is a(an):

Answer 8

Interface

Question 9

Which of the following is a database object?

Answer 9

Table

Question 10

Which of the following is used to store the data in database?

Answer 10

Tables

Question 11

Which of the following is the responsibility of DBA?

Answer 11

Performance

Question 12

DBA defines:

Answer 12

Security

Question 13

DBMS must include a:

Answer 13

DML Processor

Question 14

DBMS must provide a:

Answer 14

Data dictionary functions

Question 15

An example of a database IDE is:

Answer 15

MS Access

Question 16

The output of a query is in the form of:

Answer 16

Table

Question 17

Data exists in a database in the form of:

Answer 17

Tables

Question 18

Which of the following package s used by the application programmer in order to write a program?

Answer 18

High Level Language

Question 19

DBS must be able to accept:

Answer 19

Data Definitions

Question 20

From database, data is accessed through:

Answer 20

Queries