Data Bases UD1

What is the purpose of a database?. Store data. Provide an organizational structure for data. Provide a mechanism for querying, creating, modifying, and deleting data. All of the above.

What is a Database Management System (DBMS)?. A program that controls and manages the operations of the database. The database itself. A programming language. A program for creating databases.

Who is responsible for managing the entire DBMS system?. Application Programmers. Database Administrators (DBA). End-Users. All of the above.

What are the functions of a DBMS. Create databases. Read database data. Modify database data (insert, update, delete). All of the above.

What types of databases exist based on the model?. Hierarchical, Relational, Object-Oriented. Network, Non-relational, Distributed. Relational, Hierarchical, Non-relational. All of the above.

In the hierarchical model, how is data organized?. In a table structure. In a tree-like structure. In a graph structure. In a network structure.

What is the function of a Primary Key (PK). Uniquely identify each row. Contain null values. Link data between two tables. All of the above.

What is SQL and what is its purpose?. A programming language. Structured Query Language, for extracting and organizing data in a relational database. A database model. An operating system.

What does CRUD stand for in the context of databases?. Create, Retrieve, Update, Delete. Compute, Read, Understand, Delete. Control, Relate, Update, Define. Centralize, Retrieve, Utilize, Distribute.

What is the role of an Application Programmer in a DBMS environment?. Manage the entire DBMS system. Write programs to interact with databases in various programming languages. Interact with end-users. Design database structures.

What is the responsibility of a Database Administrator (DBA)?. Write code for applications. Manage the entire DBMS system. Interact with end-users. Create database structures.

What does SQL (Structured Query Language) primarily focus on?. Managing the database system. Writing code for applications. Extracting and organizing data in a relational database. Designing database structures.

In a Relational Database, what is the purpose of a Foreign Key (FK)?. Identify each row uniquely. Link data between two tables. Contain null values. Define the primary structure of the table.

What is the main characteristic of a Primary Key (PK)?. It can contain null values. It must be unique for each row of data. It links data between tables. It is used for querying data.

What is the significance of a Cloud Database?. It centralizes data storage. It uses a hierarchical model. It stores data on a cloud computing platform. It only supports SQL queries.

What is the purpose of data security in a database?. To slow down data access. To make data less accessible. To ensure data is secure but easily accessible to authorized users. To prevent data creation.

Why is multi-access control important in a DBMS?. To limit access to only one user at a time. To enable multiple users to access the database simultaneously without affecting integrity. To restrict access to database administrators only. To prevent data modification.

What is the significance of performing data backup and recovery in a DBMS?. To slow down the system. To create duplicate data. To ensure data integrity. To retrieve data in case of errors or failures.

Name one example of a Non-relational (NoSQL) database. MySQL. Oracle Database. MongoDB. SQLite.

In the context of databases, what does the term "distributed" mean?. Centralized data storage. Data stored in various locations. Hierarchical data organization. Non-relational data structures.