Advance Database Management System (ADBMS) MCQs and Notes

Explanation: The correct answer is (b) Accessing. Meaningful filenames can help in easy file accessing. When files are named descriptively and meaningfully, it becomes easier for users to identify and locate the files they need. This is particularly important when working with large numbers of files or when collaborating with others on a project.

Explanation: The correct answer is (a) address. The name of the location of a particular piece of data is its address. In computing, data is stored in memory, which is organized into a series of addressable locations, each of which can store a fixed amount of data.

Explanation: Collecting personal information and effectively posing as another individual is known as the crime of spoofing.

Explanation: A binary choice offers two options to choose from, typically represented as "yes" or "no", "on" or "off", "true" or "false", or "0" or "1". The term "binary" refers to the use of a two-digit system (base-2) to represent data, in which each digit can only have two possible values (0 or 1).

Explanation: The path of creation of an executable is: (d) coding, compiling, linking, parsing.

Explanation: Size of storage disk. A data dictionary contains a list of all files in the database, the number of records in each file, and the names and types of each field. Data dictionaries do not contain any actual data from the database, only book-keeping information for managing it.

Explanation: A database is a collection of data that is organized in a structured format. This collection of data can be arranged in rows and columns, tables, indexes, schemas, and other related components. Therefore, the correct option is (c) It is a collection of data arranged in rows and columns

Explanation: The field that uniquely identifies which person, thing, or event the record describes is called a "primary key". The primary key is a column or set of columns in a database table that contains unique values for each record. It is used to identify and retrieve specific records from the table, and it ensures that each record in the table is unique and identifiable.

Explanation: The referential integrity command is typically found in the Table menu in database management systems. Therefore, the correct option is (d) Table.