Chap#10 Basic Concepts and Terminology Flashcards

You may prefer our related Brainscape-certified flashcards:
1
Q

Insert command is used to insert:

A

a new record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Create command is used to create a:

A

Table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

SQL is used for:

A

Data definition and manipulation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

The foreign key is found in:

A

Dependant table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

A table must have:

A

Primary Key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

How many components are present in database?

A

Five

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

DBA is a:

A

Database manager

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

IDE is a(an):

A

Interface

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which of the following is a database object?

A

Table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

Tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which of the following is the responsibility of DBA?

A

Performance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

DBA defines:

A

Security

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

DBMS must include a:

A

DML Processor

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

DBMS must provide a:

A

Data dictionary functions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

An example of a database IDE is:

A

MS Access

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

The output of a query is in the form of:

A

Table

17
Q

Data exists in a database in the form of:

A

Tables

18
Q

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

A

High Level Language

19
Q

DBS must be able to accept:

A

Data Definitions

20
Q

From database, data is accessed through:

A

Queries