Quiz 1 Flashcards
What is the most common type of relationship between two tables?
many-to-many
one-to-many
one-to-one
one-to-few
one-to-many
When a column in a table is defined, what determines the kind of data it can store?
an index
a relationship
a primary key
a data type
a data type
What uniquely identifies each row in a table?
cell
foreign key
primary key
field
primary key
SQL statements that define the tables in a database are referred to as ________________ statements.
Data Definition Language (DDL)
ASCII
SELECT
Data Manipulation Language (DML)
Data Definition Language (DDL)
The processing that’s done by the DBMS (Database Management System) is typically referred to as:
back-end processing
anytime processing
delayed processing
front-end processing
back-end processing
The three main hardware components of a client/server system are the clients, the server, and the
application
network
data access API
hard drive
network
Which of the following recommendations won’t improve the readability of your SQL statements?
start each clause on a new line
use capital letters for all clauses except DDL statements
break long clauses into multiple lines
indent continued lines
use capital letters for all clauses except DDL statements
Which of the following is not a SQL DML (Data Manipulation Language) statement?
SELECT
INSERT
CREATE TABLE
UPDATE
CREATE TABLE
If you define a column with a default value, that value is used whenever a row ___________.
with a zero value for that column is added to the table
is added to the table
in the table is updated
that doesn’t include a value for that column is added to the table
that doesn’t include a value for that column is added to the table
To retrieve or update the data in a database, the client sends a ________________ to the database.
query
ping
transaction request
handshake
query
