DBMS Basics — Set 1
Computers · DBMS मूल बातें · Questions 1–10 of 60
What does the abbreviation DBMS stand for in the context of computing?
Correct Answer: A. Database Management System
DBMS stands for Database Management System, which is software used to manage databases. It allows users to create, retrieve, update, and manage data efficiently. This system acts as an interface between the database and end-users.
Which of the following is considered a collection of related data with an implicit meaning?
Correct Answer: D. Database
A database is defined as a systematic collection of structured information or data. It is designed to be easily accessed, managed, and updated by various applications. It serves as a central repository for electronic records.
In a database, what is the term used for a single row representing a unique record?
Correct Answer: A. Tuple
A tuple is a single row in a table that represents a specific record or data object. It contains a set of values for all the attributes defined in that table. This term is primarily used in the relational database model.
Which property ensures that a database remains in a consistent state after a transaction?
Correct Answer: D. Consistency
The consistency property ensures that a transaction takes the database from one valid state to another. It maintains all predefined data integrity rules and constraints during execution. It is part of the ACID properties governing database transactions.
What is the primary role of a 'Primary Key' in a database table?
Correct Answer: A. To uniquely identify each record in a table
A Primary Key is a unique identifier that prevents duplicate entries in a specific table. It cannot contain null values, ensuring that every record can be precisely located. Most relational databases require at least one primary key per table.
Which level of database abstraction describes how data is actually stored on the disk?
Correct Answer: D. Physical Level
The physical level is the lowest level of abstraction that describes complex low-level data structures. it handles the actual storage mechanisms and hardware interactions of the database. This level is generally hidden from the end-users for simplicity.
In a relational database, what is an 'Attribute' referring to?
Correct Answer: A. A column
An attribute represents a specific characteristic or property of a data entity, stored as a column. For example, 'Name' and 'Age' would be attributes in a student table. Each attribute has a specific data type associated with it.
Which language is most commonly used to interact with a Relational Database Management System?
Correct Answer: D. SQL
SQL or Structured Query Language is the standard language for managing data in RDBMS. It is used for tasks such as querying data, updating records, and managing table structures. Most modern database systems like MySQL and Oracle use SQL.
What does the 'A' in ACID properties stand for regarding database transactions?
Correct Answer: A. Atomicity
Atomicity ensures that a transaction is treated as a single unit, which either succeeds completely or fails completely. If any part of the transaction fails, the entire operation is rolled back to the previous state. This prevents partial data updates that could lead to errors.
Which type of key is used to create a link between two tables in a relational database?
Correct Answer: C. Foreign Key
A foreign key is a column that refers to the primary key of another table. It establishes a relationship between the data in the two tables, ensuring referential integrity. This allows databases to organize information into normalized structures.