Technical Quiz Final Round

The values appearing in given attributes of any tuple in the referencing relation must likewise occur in specified attributes of at least one tuple in the referenced relation, according to _____________________ integrity constraint.

• Referential

• Primary

• Referencing

• Specific

The process of organizing data in a database to reduce redundancy and improve data integrity is called ____________________.

• Normalization

• Denormalization

• Indexing

• Partitioning

In SQL, the command used to remove a table from a database is ____________________.

• DELETE

• DROP

• REMOVE

• TRUNCATE

The rule that ensures that a primary key must contain unique values and cannot contain NULL values is known as ____________________.

• Entity Integrity

• Referential Integrity

• Domain Integrity

• Data Integrity

The SQL command used to modify existing records in a table is ____________________.

• UPDATE

• MODIFY

• CHANGE

• ALTER

The technique of dividing a database into smaller, more manageable pieces is referred to as ____________________.

• Sharding

• Partitioning

• Clustering

• Segmentation

How do you declare a pointer to a function that takes two integers and returns an integer in C?

• A. int (*ptr)(int, int);

• B. ptr(int, int) int;

• C. function int (*ptr)(int, int);

• D. ptr function(int, int) int;

The SQL command used to create a new table in a database is ____________________.

• CREATE

• INSERT

• ADD

• MAKE

The property that ensures that a foreign key must match a primary key in another table is known as ____________________.

• Referential Integrity

• Entity Integrity

• Domain Integrity

• Data Integrity

The method of ensuring that a database remains consistent and valid during transactions is referred to as ____________________.

• ACID

• BASE

• CAP

• CRUD