Database | MCQs

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

A foreign key is used to link two tables and can contain duplicate values.

In contrast, primary, candidate, and even secondary keys are typically unique.

Explanation

A primary key must be unique for each record and never change.

Zip code is not unique (many people can share the same zip code), so it's not suitable as a primary key.

Explanation

In an Entity-Relationship (E-R) diagram, a rectangle represents an Entity.

Attributes are shown as ellipses.

Relationships are shown as diamonds.

Explanation

• Communication with MySQL is established through network calls.
• MySQL is a client-server system, where clients communicate with the server over a network connection.
• This communication involves sending queries, commands, and receiving responses over the network.

Explanation

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

Explanation

• The `--log-bin-index` option is used to enable the binary log index file in MySQL.
• This option allows you to specify the name of the index file that stores the binary log file names.

Explanation

• The 'CREATE TABLESPACE' privilege allows users to create tablespaces at the server level.
• Tablespaces are used for managing the physical storage of tables and indexes.
• This privilege falls under the realm of server administration.

Explanation

The SERIALIZABLE isolation level is the strictest transaction isolation level provided by SQL Server. It ensures that transactions are executed in a serialized manner, as if they were the only transaction operating on the database. This means that:

• No other transactions can modify data being read by a transaction.
• No other transactions can insert new data that would affect the results of a transaction.
• No other transactions can delete data that a transaction is using.

Explanation

DDL stands for Data Definition Language.

These commands are used to change the structure of a database and database objects.

For example, DDL commands can be used to add, remove, or modify tables with in a database.

*******

VU CBT FIA  PAPER 19-12-2021