Certiport: Chapter 6 - Understanding Databases UPDATED ACTUAL Exam Questions and CORRECT Answers

Certiport: Chapter 6 - Understanding
Databases UPDATED ACTUAL Exam
Questions and CORRECT Answers
Relational database - CORRECT ANSWER - It is a system for storing potentially large
amounts of data.


What do relational databases consist of? - CORRECT ANSWER - Usually one or more
tables that can be visualized as columns and rows.


What is one primary advantage of a relational database? - CORRECT ANSWER - One of
the primary advantages of a relational database is the reduction of data redundancy -
data in multiple tables can be linked instead of stored twice.


In a table, what is a primary key? - CORRECT ANSWER - It defines a column that
uniquely identifies each row.


Foreign key - CORRECT ANSWER - A foreign key from one table (Albums) refers to a
primary key in another table (Artists).
This establishes a relationship between the two tables.


Which SQL command should Jesper use to add a new album to his database?
a.
ADD
b.
INSERT
c.

UPDATE - CORRECT ANSWER - b. INSERT

, Jesper can save frequently used queries as:
a.
UPDATE files
b.
database methods
c.

stored procedures - CORRECT ANSWER - c. stored procedures


Which query could retrieve the artist "U2" from the table of artists?
a.
SELECT "U2" FROM Artists
b.
SELECT * FROM Artists WHERE ArtistName = "U2"
c.

SELECT * FROM Artists WHERE "U2" IN ArtistName - CORRECT ANSWER - b.
SELECT * FROM Artists WHERE ArtistName = "U2"


What is SQL? - CORRECT ANSWER - SQL stands for Structured Query Language and is
used to execute most common actions on a relational database. It is used to manage data in a
relational database.


What else can SQL be used to do? - CORRECT ANSWER - SQL queries can be used
interactively with the database itself or implemented in an application that accesses the database.
Basic statements in SQL queries include:


• SELECT to retrieve data
• INSERT to add rows to the database
• UPDATE to modify existing rows
• DELETE to remove an existing row