Question 1

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

Accepted Answer

Client-server

Answer

Relational

Answer

Hierarchical

Answer

Network

Question 2

What is the purpose of a primary key in a database?

Accepted Answer

To uniquely identify each row in a table

Answer

To sort data in a table

Answer

To store large amounts of data

Answer

To establish relationships between tables

Question 3

What is the difference between a database and a table?

Accepted Answer

A database is a collection of tables, while a table is a collection of rows and columns

Answer

A table is a subset of a database

Answer

A database and a table are the same thing

Answer

A table is a collection of databases, while a database is a collection of rows and columns

Question 4

What is normalization in database design?

Accepted Answer

The process of organizing data to minimize redundancy

Answer

The process of creating databases with no relationships

Answer

The process of converting data from one type to another

Answer

The process of adding redundancy to data

Question 5

Which of the following is not a type of SQL join?

Accepted Answer

Unilateral

Answer

Right

Answer

Left

Answer

Inner

Question 6

What is an index in a database?

Accepted Answer

A data structure that improves the speed of data retrieval

Answer

A way to store large amounts of data

Answer

A backup copy of a database

Answer

A way to group data together

Question 7

What is a transaction in database management?

Accepted Answer

A sequence of operations that must be executed as a single unit

Answer

A way to display data in a table

Answer

A way to add columns to a table

Answer

A way to delete data from a table

Question 8

What is a database trigger?

Accepted Answer

A procedure that is automatically executed in response to certain database events

Answer

A way to change the structure of a table

Answer

A way to backup a database

Answer

A way to manually execute SQL queries

Question 9

What is a view in a database?

Accepted Answer

A virtual table based on the result of a SQL query

Answer

A tool used to create databases

Answer

A physical table that stores large amounts of data

Answer

A type of database model

Question 10

What is a foreign key in database management?

Accepted Answer

A field in one table that references the primary key in another table

Answer

A way to sort data in a table

Answer

A way to store large amounts of data

Answer

A way to delete data from a table

Related quizzes

Related quizzes