Database Programming Techniques Quiz

1. What is database programming?

• Designing graphical user interfaces for apps.
• Creating diagrams for database structure.
• Writing code to create and manage databases.
• Writing scripts to format text documents.

2. What is the primary purpose of a Database Management System (DBMS)?

• Executing complex mathematical calculations.
• Designing web pages and graphics.
• Creating user interfaces for applications.
• Storing and managing data in databases.

3. Which language is commonly used to interact with relational databases?

• Python
• Java
• HTML
• SQL

4. What does SQL stand for?

• Structured Query Language
• Standard Query Language
• Sequential Query Language
• Simple Query Language

5. What are CRUD operations in database programming?

• Create, Read, Edit, Drop
• Create, Get, Modify, Remove
• Create, Retrieve, Alter, Destroy
• Create, Read, Update, Delete

6. Which database programming language is used in Oracle Database?

• MySQL
• T-SQL
• SQL
• PL/SQL

7. Which type of database is based on a schemaless data model?

• Hierarchical database
• Object-oriented database
• Relational database
• NoSQL database

8. What is the purpose of data modeling in database programming?

• Optimizing network speed for connections.
• Defining the structure of the database.
• Storing user passwords securely.
• Generating random data for testing purposes.

9. What is the role of indexing in database programming?

• Improving database performance.
• Ensuring data is encrypted during transmission.
• Managing user permissions effectively.
• Storing data in multiple formats.

10. Which term refers to the process of connecting an application to a database?

• Linking
• Connecting
• Gluing
• Attaching

11. Which database programming language is commonly used in Microsoft SQL Server?

• DDL
• T-SQL
• CQL
• PL/SQL

12. What is the primary purpose of a primary key in a database table?

• Storing large amounts of unstructured data.
• Creating backups of data in tables.
• Allowing multiple records to share the same value.
• Ensuring data integrity and uniqueness.

13. Which term is used to describe managing simultaneous access to the database by multiple users?

• Key-value store
• Data integrity
• Database normalization
• Concurrency control

14. Which type of database model uses a collection of key-value pairs to store data?

• Column-family database model
• Graph database model
• Relational database model
• Document database model

15. What is the purpose of using foreign keys in database tables?

• Ensuring data integrity and referential integrity.
• Improving data retrieval speed.
• Enforcing user authentication and permissions.
• Storing large amounts of data.

16. What is a logical unit of work that must be executed as a whole?

• A function
• A trigger
• A procedure
• A transaction

17. What is the purpose of data normalization in database design?

• Speeding up data retrieval and filtering data.
• Organizing data in a hierarchical structure.
• Ensuring data consistency and eliminating data redundancy.
• Storing data in a distributed manner across nodes.

18. Which type of NoSQL database is suitable for handling large volumes of unstructured data, such as text and multimedia content?

• Key-value store
• Relational database
• Graph database
• Document database

19. Which of the following is NOT a data manipulation operation in SQL?

• Delete
• Insert
• Atomicity
• Update

20. Which of the following is a valid SQL query for inserting data into a database table?

• INSERT INTO table_name (columns) VALUES (values);
• SELECT INTO table_name (columns) VALUES (values);
• ADD TO table_name (columns) VALUES (values);
• UPDATE table_name SET columns = (values);

21. In a relational database, what is the purpose of a primary key?

• To store large binary objects in a table.
• To provide a summary of data in a table.
• To group related records in a table.
• To uniquely identify each record in a table.

22. Which type of database model organizes data in a tree-like structure with parent-child relationships?

• Hierarchical database model
• Relational database model
• Object-oriented database model
• Flat file database model

23. Which SQL statement is used to retrieve data from a database table?

• UPDATE
• DELETE
• INSERT
• SELECT

24. What is the purpose of indexing in SQL query optimization?

• To speed up data retrieval by allowing the database to locate specific information quickly.
• To ensure data redundancy and maintain duplicates.
• To normalize data and eliminate relationships.
• To create data backups for security purposes.

25. Which indexing strategy is used to divide large tables into smaller, manageable partitions?

• Record segmentation
• Table partitioning
• Index clustering
• Data sharding

26. How does using the WHERE clause instead of HAVING enhance query efficiency?

• Using WHERE allows for grouping results, which is more efficient than HAVING.
• The HAVING clause never filters any records and applies to all rows of data.
• The WHERE clause filters records before groups are created, which is more efficient than HAVING.
• The WHERE clause applies after aggregation, making queries run slower than HAVING.

27. What is the main difference between running queries inside a loop and running them outside a loop?

• Running queries inside a loop enhances data retrieval speed significantly.
• Running queries inside a loop increases database security and stability.
• Running queries outside a loop improves efficiency by avoiding the iterative pattern that slows down execution time.
• Running queries outside a loop consumes more memory and resources.

28. How does specifying only necessary columns in a SELECT statement improve query performance?

• It allows the database to analyze all columns, making the results more comprehensive.
• It increases the number of rows processed, slowing down the query execution time.
• It minimizes the data retrieved, reducing strain on the database and improving query execution speed.
• It guarantees a higher security level for sensitive database information.

29. What is the purpose of updating statistics in SQL query optimization?

• To improve the graphical representation of data.
• To keep statistics up-to-date, enabling the query optimizer to generate efficient execution plans.
• To delete old records from the database quickly.
• To automatically back up the database at regular intervals.

30. How does optimizing joins enhance query performance?

• By allowing duplicates across all joined tables without filtering.
• By ensuring all tables are joined in a single query without conditions.
• By using only inner joins for all queries.
• By choosing appropriate join techniques and conditions to minimize the number of rows involved in joins.