Database Management | MCQs

Explanation

A memorandum is a written message that is typically used in a professional setting.

Commonly known as a "memo," these messages are typically brief and easily understood.

Explanation

Database replication is the frequent electronic copying of data from a database in one computer or server to a database in another -- so that all users share the same level of information.

Explanation

The relational database environment has all of the following components except separate files.

A relational database is a set of formally described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables.

Explanation

The data dictionary is a part of a DBMS that stores metadata — details like table names, field names, data types, constraints, and relationships.

It helps the system manage and understand the structure of the database.

Explanation

MySQL, Microsoft Access, IBM DB2 are database management systems while Google is a search engine.

Explanation

NADRA Stand for National Database and Registration Authority

NADRA was established as National Database Organization (NDO), an attached department under the Ministry of Interior, Government of Pakistan in 1998.

Explanation

Create Table By Entering Data. Design View. While Using Wizard.

Explanation

 MS Access, columns in a table are called fields.

It store specific types of data for each record.

Rows in an MS Access table are called Records.

It representing individual entries or data points within the table.

Explanation

In database design, a composite key is a candidate key that consists of two or more attributes (table columns) that together uniquely identify an entity occurrence (table row).

A compound key is a composite key for which each attribute that makes up the key is a simple (foreign) key in its own right.