Test Questions Flashcards

1
Q

Changing from analysis (conceptual model) to implementation (physical model) means an identifier in a model becomes a ______ in a relation?

A

Primary key

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

_____ are made up of characteristics of data.

A

Schemas

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

Type of database language used for granting and revoking user access is called ____?

A

Data Control Language

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

Data Manipulation Language (DML) commands work on ____?

A

Data in the table

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

Unstructured database model is known as ____?

A

Object-oriented model

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

____ are crucial for improving query performance, data retrieval, and data integrity in a database.

A

Indexes.

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

The category of optimisation that is based on heuristics is known as _____?

A

Rule-based optimisation.

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

Examples of query optimisation tools is:

A
  • SQL tuning advisor
  • Index advisor
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Best practices for query optimisation include:

A
  • Avoid using ‘SELECT *’ and select only the required fields.
  • Use efficient data types to reduce storage processing.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Embedding non-procedural queries involves integrating _____ queries into procedural languages

A

non-procedural or SQL

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

The ____ language is used to embed non-procedural queries into a procedural programming language.

A

query or host

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

The result component in QBE is used to specify the______ format.

A

Output

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