Test Questions Flashcards
Changing from analysis (conceptual model) to implementation (physical model) means an identifier in a model becomes a ______ in a relation?
Primary key
_____ are made up of characteristics of data.
Schemas
Type of database language used for granting and revoking user access is called ____?
Data Control Language
Data Manipulation Language (DML) commands work on ____?
Data in the table
Unstructured database model is known as ____?
Object-oriented model
____ are crucial for improving query performance, data retrieval, and data integrity in a database.
Indexes.
The category of optimisation that is based on heuristics is known as _____?
Rule-based optimisation.
Examples of query optimisation tools is:
- SQL tuning advisor
- Index advisor
Best practices for query optimisation include:
- Avoid using ‘SELECT *’ and select only the required fields.
- Use efficient data types to reduce storage processing.
Embedding non-procedural queries involves integrating _____ queries into procedural languages
non-procedural or SQL
The ____ language is used to embed non-procedural queries into a procedural programming language.
query or host
The result component in QBE is used to specify the______ format.
Output