Ch. 1 quiz (4430)
The extension to the SQL language that Oracle Database offers is called _____.
PL/SQL
Which of the following recommendations won't improve the readability of your SQL statements?
Use comments to describe what each statement does.
To retrieve or update the data in a database, the client sends a/an _____ to the database.
query
A relational database consists of one or more _____.
tables
If you define a column with a default value, that value is used whenever a row
that doesn't include a value for that column is added to the table.
Which of the following types of statements isn't an action query?
Select
SQL statements that define the tables in a database are referred to as _____ statements.
/DDL/,/Data Definition Language/
Which of the following isn't true about a stored procedure?
A stored procedure is compiled each time that it is executed.
Which of the following types of SQL statements isn't a DML statement?
Create Table
Insert, Update, and Delete statements can be referred to as ______________ queries.
action
The processing that's done by the DBMS is typically referred to as
back-end processing
The intersection of a row and a column is commonly called a/an _____.
cell
The interface between an application program and the DMBS is usually provided by the
data access API
A database driver is software that lets the
data access model communicate with the database
A view is a SELECT statement that is stored with the _____.
database
To relate one table to another, a/an _____ in one table is used to point to the primary key in another table.
foreign key
The three main hardware components of a client/server system are the clients, the server, and the _____.
network
The most common type of relationship between two tables is a/an _____ relationship.
one-to-many
A/An _____ uniquely identifies each row in a table.
primary key
When a column in a table is defined, it is given a data ________________ that determines what kind of data it can store.
type