PRELIM EXAM | IM2

What is a database?

• A collection of computer hardware
• A structured collection of data
• A computer program
• A network of interconnected devices

What is the primary purpose of a database management system (DBMS)?

• Create data
• Store and manage data
• Process data for printing
• Encrypt data

Which of the following is not a common type of database model?

• Relational
• hierarchical
• Linear
• NoSQL

What is a schema in the context of a database?

• A programming language used for databases
• A table of data
• A visual representation of data relationships
• The structure that defines the organization of data in a database

What is a table in a relational database?

• A graphical representation of data
• A collection of related records organized in rows and columns
• A document containing data
• A program for accessing data

In a relational database, what is a primary key?

• A key used to open the database
• A key used for encryption
• A unique identifier for a record in a table
• A foreign key that links to another table

What is an entity-relationship diagram (ERD) used for in database design?

• To store data
• To visualize the structure of a database, including tables and relationships between them
• To create SQL queries
• To define primary keys

In a relational database, what is a foreign key?

• A key used to access data from another table
• A key used for encryption
• A unique identifier for a record in a table
• A field that links to a primary key in another table

What does SQL stand for in the context of databases?

• Simple Query Language
• Structured Query Language
• Secure Query Language
• Server Query Language

What SQL command is used to retrieve data from a database table?

• SELECT
• UPDATE
• DELETE
• INSERT