Which of the following is NOT a drawback of flat file systems compared to database systems?

Limited data types for each column

Inability to manage multiple tables

Limited support for concurrent users

Which of the following is a benefit of using databases over flat file systems?

Databases can enforce data types for each column

Databases are cheaper to maintain

What does scalability in databases mean?

Expanding usage without increasing costs at the same rate

Increasing costs at the same rate as usage

Limiting the capacity of the system

What is a relational database?

A highly structured type of database where information is organized in tables.

A type of database where information is stored in a single table.

A database that does not use Structured Query Language (SQL).

A type of database that does not support multiple linked tables.

What is the purpose of using Structured Query Language (SQL) in relational databases?

To maintain and query data in the database.

To create graphical user interfaces.

What is a primary key in a relational database?

A unique identifier for each record in a table.

A field that can have duplicate values.

A type of data encryption method.

Why is it impractical to store a complex set of data within a single table in a relational database?

It can lead to data duplication and inconsistencies.

It makes the database more secure.

It improves the speed of data retrieval.

It simplifies the database design.

In the context of relational databases, what does the term "schema" refer to?

The structure of the database including fields and relationships

The unique identifier for each row in a table

The column that references a primary key in another table

The process of normalizing data

What is the advantage of drawing customer information from the Customer table and book information from the Book table in a Lending table?

It allows for easier updates to customer information.

It reduces the number of tables needed.

It eliminates the need for queries.

It increases the complexity of the database.

What does the concept of Garbage In, Garbage Out (GIGO) emphasize in an RDBMS?

The importance of consistent and correct data entry.

The importance of having multiple tables.

The necessity of having a primary key.

What is an example of a constraint in a database?

A primary key that must be unique.

A table that stores customer information.

A field that allows null values.

What is a document database?

A type of semi-structured database that grows by adding documents.

A type of database that uses tables and fields.

A database that only stores text documents.

A database that does not require a query engine.

Which markup language is commonly used to provide structure in documents?

XML (eXtensible Markup Language)

HTML (HyperText Markup Language)

SQL (Structured Query Language)

What is a key/value pair database used for?

Storing the properties of objects without predetermining the fields

Storing the properties of objects with predetermined fields

Which of the following statements is TRUE about key/value pair databases?

Not all properties have to be defined for each object.

All properties must be defined for each object.

Only numerical properties can be defined.

Only textual properties can be defined.

What type of databases are described as non-relational because there are no formal structures to link different data objects and files?

Document databases and key/value pair databases

What is the purpose of the ALTER TABLE command in SQL?

To add, remove, or modify table columns and configure constraints

To specify that a column is indexed

What does the UPDATE command do in SQL?

Changes the value of one or more table columns

What is the purpose of the SELECT command in SQL?

To define a query to retrieve data from a database

To change the value of table columns

What does the following SQL statement do? SELECT * FROM Customers;

Retrieves all data in the specified "Customers" table

Adds a new row in the Customers table

Deletes all records from the Customers table

Changes the value of one or more columns in the Customers table

What does the following SQL statement do? SELECT Name, Town FROM Customers;

Retrieves the values in the Name and Town fields for all records in the Customers table

Adds a new row in the Customers table

Deletes all records from the Customers table

Changes the value of one or more columns in the Customers table

Which SQL statement retrieves all records from the Customers table where the value in the Town field is equal to "Slough"?

SELECT * FROM Customers WHERE Town='Slough';

SELECT * FROM Customers WHERE Town='London';

SELECT * FROM Customers WHERE Name='Slough';

SELECT * FROM Customers WHERE Town='New York';

What does the following SQL statement do? SELECT * FROM Customers WHERE Town='Slough' ORDER BY Name;

Retrieves all records from the Customers table where the value in the Town field is equal to "Slough" and sorts the results in alphabetical order by the contents of the Name field.

Retrieves all records from the Customers table where the value in the Name field is equal to "Slough" and sorts the results in alphabetical order by the contents of the Town field.

Retrieves all records from the Customers table where the value in the Town field is equal to "Slough" and sorts the results in descending order by the contents of the Name field.

Retrieves all records from the Customers table where the value in the Town field is equal to "London" and sorts the results in alphabetical order by the contents of the Name field.

What does the following SQL statement do? GRANT SELECT ON Customers TO james

Grants use of the SELECT statement to the user "james" on the Customers table.

Denies use of the SELECT statement to the user "james" on the Customers table.

Grants use of the SELECT statement to the user "james" on all tables.

Grants use of the DELETE statement to the user "james" on the Customers table.

What are Database access methods?

Processes to run SQL commands on the server or update/extract information

Methods to create new databases

Tools to design database schemas

How can a software application interact with a database programmatically?

By using SQL commands or stored procedures

What is the purpose of making secure backups of databases?

To increase database performance

What is a dump in the context of databases?

A copy of the database or table schema along with the records expressed as SQL statements.

A backup of the database stored in a cloud service.

A temporary storage of database queries.

A method to delete records from a database.

Which file formats are commonly supported for exporting data from databases?

Comma Separated Values (.CSV) and native MS Excel (.XLS)

Database Concepts Quiz

Authored by Ciara Williams

Computers

12th Grade

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

55 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a database?

A collection of unorganized information.

A structured collection of information stored for easier access.

A random assortment of data.

A type of software used for creating websites.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In a database, what does each row represent?

A single field within a record.

A separate record in the database.

A table of information.

A column of data.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a process involved in database usage?

Creation

Import/input

Storage (data persistence)

Deletion

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of a query in a database?

To store data persistently and securely.

To format and summarize records.

To specify criteria to match values in fields and display selected information.

To create new tables of information.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the role of reports in a database?

To create new records.

To format and summarize records returned by a query.

To store data temporarily.

To delete unnecessary data.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is an example of a flat file data storage and access system?

Database

Spreadsheet

Cloud Storage

Data Warehouse

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does a Comma Separated Values (CSV) file use to identify the end of a column?

Semicolons

Tabs

Commas

Spaces

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

52 questions

Computer Basics

Quiz

•

9th - 12th Grade

50 questions

Journalistsic Integrity and Ethics

Quiz

•

9th - 12th Grade

60 questions

CSD Unit 3 Review

Quiz

•

9th - 12th Grade

54 questions

INFORMATICA II- SEGUNDO PARCIAL-2023 A

Quiz

•

12th Grade

50 questions

Sistem Komputer gerbang aritmatika Kelas 10

Quiz

•

12th Grade - University

60 questions

مسابقة تقنية رقمية ٣ نظري+ عملي

Quiz

•

12th Grade

50 questions

Solon Microsoft Excel Quiz

Quiz

•

9th - 12th Grade

50 questions

Application Software Quiz

Quiz

•

12th Grade - University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Computers

18 questions

[AP CSP] JavaScript Programming Lesson 2025-2026

Lesson

•

9th - 12th Grade

57 questions

[AP CSP] Unit 5 Review: Internet & Cybersecurity

Quiz

•

9th - 12th Grade