Database Quiz (Certmaster 5.1 - 5.3)

Microsoft SQL Server is an example of what?

• RDBMS
• Relational database
• Query/report builder
• Database server

What is a database?

• A database is a software program that is used to show better ways to access data.
• A database is a collection of bits of random information stored together on a computer.
• A database is a collection of related data organized in a structured manner for easier access.
• A database is any individual basic piece of data that an organization considers valuable.

Why might a table called “Students” in a relational database have twelve rows?

• There are twelve students.
• Twelve pieces of data are stored for each student.
• A relational table must have a minimum of twelve rows.
• Rows in a table are added in multiples of twelve.

When processing large numbers of transactions, how does processing speed compare between databases and flat file systems?

• The speed of processing transactions is the same whether the data is stored in a flat file or a database.
• Flat files’ processing speeds are much faster than database processing speeds.
• Database processing speeds are much faster than flat file speeds.
• Flat file processing speeds are faster than database processing speeds if the computer’s processor is slower than average.

Which of the following actions is most likely associated with database use?

• Querying
• Printing
• File Sharing
• Creating Diagrams

What is the relationship between queries and reports?

• A query produces output on the screen and a report produces output on the printer.
• A report filters the data values to provide only the needed data and a query retrieves it.
• A query selects and retrieves the correct data, whereas a report formats and summarizes the output.
• “Report” and “query” are really two terms for the same thing.

What term is defined as the ability of a database to increase in size as more information is added to it without increasing costs at the same rate?

• Persistence
• Scalability
• Import
• Relational

The output of a query in a relational database is most likely used to generate:

• scalability
• storage
• a schema.
• a report.

What is the purpose of a schema?

• It is used only by the programmer for documentation.
• It contains data values used for queries.
• It describes the structure of a database.
• It displays business rules that dictate how a database will be used.

In a relational database, what best describes the relationship between a primary key and a foreign key?

• The primary key is in one table and it is matched to the foreign key in a secondary table.
• The foreign key and primary key are in the same table. The foreign key is used as the backup key in case the primary key is compromised.
• Both foreign and primary keys are used to uniquely identify each row in a table.
• Primary keys are used to uniquely identify each row in a table, whereas the foreign key is used only for searching and sorting.