Advance Database Management System (ADBMS) MCQs and Notes

Explanation: The correct answer is (d) Both (a) and (b). To understand DBMS (Database Management System), it is important to understand the physical schema which defines how the data is actually stored on the physical storage devices, such as hard disk or SSD. This includes the storage structures, indexing techniques, and access methods used to store and retrieve data efficiently.

Explanation: The E-R modeling technique is a top-down approach. It involves identifying the entities in a system and the relationships between them, and then creating a diagram to represent this information. Therefore, the correct option is (a) top-down approach.

Explanation: The database administrator (DBA) is responsible for managing the database and acting as a liaison between the database and the users who access it. The DBA is not directly responsible for coordinating between the DBMS and database, or between application programs and users.

Explanation: The data dictionary is a catalog or repository of metadata that contains information about the data in a database. This includes field names, field types, and field formats, as well as other information such as data relationships, data dependencies, and data usage.

Explanation: Data independency in DBMS is known as data modelling. Q. The function of Data Manipulation is (in DBMS).

Explanation: The correct answer is (d) database. A collection of interrelated files in a computer is typically called a database. A database is a structured collection of data that is organized in a way that allows for efficient storage, retrieval, and manipulation of that data.

Explanation: The correct answer is (c) Character, field, record, file, database. Explanation: A character is the smallest unit of data that can be processed, such as a letter or a number. A field is a collection of characters that represents an attribute of an entity, such as a person's name or address. A record is a collection of fields that represents a complete set of information about an entity, such as a customer or an order. A file is a collection of records, typically of the same type, stored in a single unit, such as a text file or a spreadsheet. A database is a collection of related files that are organized in a way that facilitates efficient retrieval of information. Therefore, the order from smallest to largest common data elements is character, field, record, file, database.

Explanation: To show the database objects along with their description, we need to use the "DESCRIBE" or "DESC" command in SQL. Therefore, the correct option is (e) None of the above.

Explanation: Files are commonly organized and stored in folders, which are a type of container used to group related files together and create a hierarchy of information. This allows for easy access and management of files on a computer or other storage device. Tables and databases are used to organize data, while graphs are used to visualize data.