Section 1
Preview this deck
Open source software
Front
| 5 | 0 | ||
| 4 | 0 | ||
| 3 | 0 | ||
| 2 | 0 | ||
| 1 | 0 |
Active users
0
All-time users
0
Favorites
0
Last updated
4 years ago
Date created
Mar 1, 2020
Cards (401)
Section 1
(50 cards)
Open source software
...is software for which the source code is freely and publicly available.
extension
The order line in a Premiere Products order form contains a total that is called an...
False
The BOOK table at Henry Books includes the author number.
Linux
The ... operating system is an example of a popular open source program.
False
Because Premiere Products wants the flexibility to quote and charge differnet prices to different customers, the QUOTED_PRICE column is included in the ORDER_LINE table.
code
Each publisher has a ... that uniquely identifies the publisher at Henry Books.
WROTE
Which of the following tables relates books to authors?
False
All of the sales representatives at Premiere Products get the same commission rate.
True
At Alexamara Marian Group, marina slips are numbered within each section.
heading
The ... of the order form at Premiere Products contains the order number and date; the customer's number, name, and address; and the sales rep's number and name.
False
The overall order total is stored in the Premiere Products database.
2
an owner number in the OWNER table at Alexamara Marina consists of ... uppercase letters followed by a two-digit number.
service_request
If another appointment is required to complete additional service, the appointment date appears in the NEXT_SERVICE_DATE column of the ... table of Alexamara.
quantity ordered
Each line in the Premiere Products order form contains a part number, the number of units of the ordered part, the quoted price, and ...
total
The computer calculates the ... for Premiere Products whenever an order is printed or displayed on the screen.
False
The BRANCH table is used to indicate the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.
INVENTORY
The ... table indicates the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.
AUTHOR_NUMBER
Ray tracks for Henry Books each author's last and first names and an ...
False
SQL stands for Syntactical Question Language.
slips
Alexamara Marina Group offers in-water storage to boat owners by providing boat ... that boat owners can rent on an annual basis.
False
The customer's name and address and the number of the sales rep who represents the customer are stored with sales rep information.
False
In the Henry Books database, the AUTHOR table contains the author's number, name and address.
title
For each book, Ray at Henry Books tracks the book code, ..., publisher code, type of book, price and whether the book is paper back.
code
Each book at Henry Books is uniquely identified with a ...
database
A ... is a structure that contains different categories of information and the relationships between these categories.
total
The footing of the order at Premiere Products contains the order ...
My SQL
... is currently the world's most popular open source database.
items
The body of the order contains one or more order lines, sometimes called line ...
employees
Ray tracks the branch's name, location, and number of .... for Henry Books.
True
Each branch of Henry Books has a number that uniquely identifies the branch.
number
A marina ... uniquely identifies each marina in the MARINA table.
extension
Each order line at Premiere Products contains a total, usually called an ...
ID
Each row in the table MARINA_SLIP at Alexamara contains a slip ... that identifies the particular slip.
Database Management System (DBMS)
A ... is a software program that lets you create a database and then use it to add, change, delete, sort, and view the data in a database.
AUTHOR
The BRANCH, PUBLISHER, and ... tables are part of the Henry Books Database.
simple
When designing tables a ... structure is preferred.
appliances, housewares, and sporting goods.
Premiere Products sells...
MARINA
Alexamara stores information about its marinas in the ... table.
commission rate
The REP table consists of the order number, order date, and ...
SERVICE_REQUEST
Information about the Alexamara services requested by boat owners is stored in the ... table.
inventory
The table named ... is used to indicate the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.
description of the catagory
Alexamara provides boat maintenance service for owners at its two marinas. The SERVICE_CATEGORY table contains a ...
make a more complicated table
Combining the ORDER_LINE and ORDERS tables will ...
owner
Alexamara stores information about the boat owners to whom it rents slips in the ... table.
5
How many tables make up the Premiere Products database?
line items
The body of a Premiere Products order contains a number of order lines, sometimes called ...
customer number
The ORDERS table consists of the order number, order date, and ...
2
Alexamara owns ___ marinas.
SEQUENCE
The ... field of the WROTE table of Henry Books indicates the order in which the authors of a particular book are listed on the cover.
body
The three components of a Premiere Products order are heading, ..., and footing.
Section 2
(50 cards)
row, record, tuple
In a relational database each ____ should be unique.
NONKEY
A(n) _____ column is a column that is not part of the primary key.
column
A field is another term for a(n) ____.
relationship
A(n) ____ is the association between entities.
lines
In an entity-relationship (E-R) diagram, one-to-many relationships between entities are drawn as ____ .
tuple
A record is another term for a(n) ____.
second
If the primary key of a table contains only a single column, the table is automatically in _____ normal form.
relations
A relational database is a collection of ________.
False
A relation is essentially a three-dimensional table.
True
In a relation, all values in a column are values of the same attribute.
RELATIONSHIPS
In one style of entity-relationship (E-R) diagrams, diamonds are used to describe _____.
nonkey
A ____ column is a column that is not part of the primary key.
True
An unnormalized relation is a relation that contains repeating groups.
inconsistent data
____ is one of the categories of update anomalies.
False
In a relational database, two columns can be identical
dependency
Any column (or collection of columns) that determines another column is called a(n) ____.
(.)
Which of the following symbols is used to qualify column names?
tuple
A(n) ____ is another name for a record or a row.
one-to-many
At Premiere Products, there is a ____ relationship between sales reps and customers.
All of the above (attribute, field, column)
A(n) ____ is a characteristic or property of an entity.
concatenation
____ is the formal term for combining two or more columns to form a primary key.
third normal form
In this text, Boyce-Codd normal form is the same as ____.
False
A determinant is any column (or collection of columns) that determines another table.
True
Each column in a table of a relational database should have a distinct name.
updates
The four categories of update anomalies are additions, deletions, inconsistent data, and ______.
redundancy
____ is the duplication of data.
database design
The process of determining the particular tables and columns that will comprise a database is known as ____.
parentheses
There is a commonly accepted shorthand representation to show the structure of a relational database: After the name of the table, all the columns in the table are listed within a set of ____.
Entities
A relationship is an association between _______.
True
The definition for a primary key really defines a candidate key as well
False
Columns are sometimes called tuples.
ENTITY
A(n) ______ is a person, place, object, event, or idea for which you want to store and process data.
True
In a relational database, relationships are implemented by having common columns in two or more tables.
False
Normalization is done before creating the database design
PRIMARY
The _______ key of a table (relation) is the column or collection of columns that uniquely identifies a given row in that table.
Order_num and Part_num
Which of the following is the primary key of the ORDER_LINE (ORDER_NUM, PART_NUM, NUM_ORDERED, QUOTED_PRICE) table?
False
A programmer interviews users, examines existing and proposed documents, and examines organizational policies to determine exactly the type of data needs the database must support
True
Because there is a one-to-many relationship between sales reps and customers n the Premiere Products database, One sales rep can be associated with zero, one, or more customers.
update anomalies
____ can occur when there is a column in a table that is dependent on only a portion of the primary key.
RELATIONSHIP
A(n) ________ is the association between entities.
BOYCE-CODD NORMAL FORM (BCNF)
________ is another name given to third normal form in this text.
REPEATING
A table's design should be as simple as possible; you should restrict each position in a table to a single entry by not allowing multiple entries (called a(n) _____ group) in an individual location in the table.
immaterial
In a relation, the order of the rows and columns is ____________________
rectangles
In an entity-relationship (E-R) diagram, ____ are used to represent an entity.
False
A table is in third normal form if it is in second normal form and no nonkey column is dependent on only a portion of the primary key.
True
The statement "A sales rep's pay class functionally determines his or her pay rate" means that if you know the pay class, you also know the pay rate.
False
A tabular database is a collection of tables.
functionally dependent
In a relational database, column B is ______ on another column A, it at any point in time a value for A determines a single value for B.
first normal form
A relation is in ____ if it does not contain any repeating groups.
qualify
When you write a column in the format CUSTOMER.REP_NUM, you say that you _____ the column name
Section 3
(50 cards)
single quotation marks
For any column whose data type is CHAR, values must be enclosed in ____.
decimal
The correct data type for the BALANCE column in the CUSTOMER table is ____.
False
In SQL, there are special rules that specify that a particular word must begin in a particular position on the line.
script
A file containing SQL commands is called a ____________________ file.
False
When adding rows to character columns, make sure you enclose the values in double quotation marks.
auto_increment
If the word ____________________ follows the word INT, a column is created for which MySQL will automatically generate a new sequence number each time a new row is added.
create table
The ____ command defines a table's structure by listing its columns, data types, and column lengths
insert
The ____________________ command adds rows to a table.
query
SQL is Structured ____________________ Language.
int
The ____ data type is used to store integers.
use
In MySQL, you use the ____________________ command to change the database to the one you want to use.
create table
You use the ____________________ command to describe the layout of a table.
CTRL + E
In MySQL, to move to the end of a line, you need to press the ____ key(s).
sequel
What is the original name of SQL?
select
To view the data in a table, you use the ____________________ command.
command line
The mysql prompt displays in the ____ Client window.
False
To enter a null value into a table, you use a special format of the NULL command
asterisk
To display all the rows and columns in a table, type the word SELECT, followed by a(n) ____, followed by the word FROM and then the name of the table containing the data you want to view.
drop
You can delete the entire table using the ____________________ TABLE command.
False
If you added a row that should not be in a table, use a REMOVE command to remove it.
help union
To get more information about the union command, type ____________________ at the command prompt.
statement history
In MySQL, the most recent command entered is stored in a special area of memory called the ____.
True
The CREATE DATABASE command is executed only once for a database.
YYYY-MM-DD
In MySQL, dates have the form ____.
notepad
____ is an example of a text editor.
\G
To display data vertically rather than horizontally, replace the semicolon at the end of the command with ____.
show columns
To examine the structure of a table, use the ____________________ command.
.txt
Script files must have a ____________________ file name extension.
create database
To create a new database, execute the ____________________ command.
\.
To run a script file, type either SOURCE or ____________________ followed by the name of the file.
True
In MySQL, you can display the data vertically rather than horizontally.
False
In MySQL, the data type STRING(n) stores a character string n characters long.
up arrow
To move up a line in the statement history, use the ____________________ key(s).
varchar
The ____ data type stores only the actual character string.
not null
To indicate columns that cannot contain null values, use the ____________________ clause in a CREATE TABLE statement.
semicolon
When a script file contains more than one command, each command must end with a ____.
TBL_1
Which of the following is a valid name for a table?
\h
The simplest way to obtain help in MySQL is to type ____ at the mysql> prompt.
CTRL + A
In MySQL, to move to the beginning of the current line, you need to press the ____ key(s).
True
In SQL, you use the NOT NULL clause in a CREATE TABLE command to indicate columns that cannot contain null values.
semicolon
You indicate the end of a command by typing a(n) ____.
18
In MySQL, table names cannot exceed ____ characters.
prompt
In MySQL, you type commands at the mysql> ____.`
use
The ____ command activates the default database.
True
The shortcut command to quit MySQL is \q.
False
To edit an SQL command, type EDIT at the mysql prompt..
Backspace
In MySQL, to delete the previous character, you need to press the ____ key(s).
update
Which of the following commands changes the value in a column?
update
You can use the ____________________ command to update a value in a table.
1970's
SQL was developed in the mid-____.
Section 4
(50 cards)
single quotes
To include spaces in computed column names, enclose the computed column name in ____.
Between
The ____ operator is inclusive meaning that a value equal to either value would be selected.
True
It is possible to place one query inside another.
False
You cannot change the order of the columns to be displayed in query results.
compound
______ conditions are formed by connecting two or more simple conditions.
between
The ____ operator specifies a range of values in a condition.
Select
In SQL, you use the ____ command to query a database.
%
In SQL, the ____ symbol is used as a wildcard to represent any collection of characters.
All of the above (and/or/not)
You form compound conditions by connecting two or more simple conditions using the ____ operators.
where
You use the _____ clause to retrieve rows that satisfy some condition.
group by
The ____ clause lets you group data on a particular column.
not
Preceding a condition by the ____ operator reverses the truth of the original condition.
like
The ____ operator uses one or more wildcard characters to test for a pattern match.
major
When you need to sort data on two columns, the more important column is called the ___ sort key.
order by
In MySQL, you specify the results order by using the _____ clause.
agregate
MySQL has special functions, called _________ functions, to calculate sums, averages, counts, maximum values, and minimum values.
and
When the _____ operator connects simple conditions, all the simple conditions must be true in order for the compound condition to be true.
True
Aggregate functions apply to groups of rows.
+
Which of the following operators can be used for a column computation?
null
When you use the MAX function, SQL ignores any _____ value(s) in the column and eliminates them from the computations.
count
The ____ function determines the number of rows in a table.
True
You can use computed columns in comparisons.
binary
In MySQL, to retrieve character data that exactly matches the case used in a WHERE clause, use the ____ keyword.
having
The ____ clause is used to restrict the groups that are included.
sum
When you use the ______ function, you must specify the column to total, and the column data type must be numeric.
grouping
_____ creates groups of rows that share some common characteristic.
query
A(n) _____ is simply a question represented in a way that the DBMS can understand.
count
When you use the ____ function, you can use the asterisk (*) to represent any column.
computed
A(n) ______ column is a column that does not exist in the database but can be computed using data in the existing columns.
False
In a SELECT statement, the FROM clause and the WHERE clause (when used) must appear on separate lines.
sum
The ____ function calculates a total of the values in a column.
True
It is possible to use both a WHERE clause and a HAVING clause in a SELECT statement.
minor
When you need to sort data on two columns, the less important column is called the ____ sort key.
is not null
The ____ operator finds rows that do not contain a null value in the specified column
select-from-where
The basic form of the SQL SELECT command is ____.
numeric
When you use the SUM function, the column data type must be ______.
*
In the SELECT clause, you can use the ____ symbol to indicate that you want to include all columns.
False
The only arithmetic operators that can be used in SELECT statements are + for addition and - for subtraction.
True
There are no special formatting rules in MySQL.
key
The column on which data is to be sorted is called a sort _____.
order by
You use the ____ clause to list data in a specific order.
in
A(n) ___ clause provides a concise way of phrasing certain conditions.
subquery
The inner query in a nested query is called a(n) _______.
is null
The ________ operator finds rows that contain a null value in the specified column.
as
You can also assign a name to a computed column by following the computation with the word ___ and the desired name.
False
When you connect two or more simple conditions with the AND operator, each condition must be listed on a separate line.
True
Sometimes a condition involves a column that can accept null values.
having
You can use the ________ clause to limit the groups that are included.
_
The ____ wildcard symbol represents any individual character.
nested
A ____ query is one query inside another.
Section 5
(50 cards)
select
In a multiple-table query, you list all the desired columns in the ___ clause and qualify any columns that appear in more than one table.
False
To produce the same results as the minus operator, use not, the in operator and a sub-query.
join
If you had two separate tables for customers and the query requested customers in the first table having the same city as customers in the second table, you could use a normal ___ operation to find the answer.
nested
A sub-query within a sub-query is called a ___ sub-query.
spacebar
You create an alias by typing the name of the table, pressing the ___, and then typing the name of the alias.
union
Two tables are ___ compatible if they have the same number of columns and if their corresponding columns have identical data types and lengths.
join
To retrieve data from more than one table, you mus ____ the tables together by finding rows in the two tables that have identical values in matching columns.
intersect
The ____ of two tables is a table containing all rows that are in both tables.
left outer join
In a ___, all rows from the table on the left will be included regardless of whether they match rows from the table on the right.
(.)
To quality a column name, precede the name of the column with the name of the table, followed by a ____.
where
You can join tables by using a condition in the ____ clause.
...
The ___ of two tables is the set of all rows that are in the first table but that are not in the second table.
union
Two tables are ___ compatible if they have the same number of columns and if their corresponding columns have identical data types and lengths.
inner
A join that compares the tables in the from clause and lists only those rows that satisfy the condition in the where clause is called an ___ join.
Cartesian
The product of two tables is formally called the ___ product.
True
To ensure that query results are listed in a desired order, use the order by clause.
minus & intersect
Which of the following set operators are not supported by MySQL?
full outer
Sometimes you need to list all the rows from one of the tables in a join, regardless of whether they match any rows in the other table. This type of join is called a ____ join.
product
The ___ of two tables is the combination of all rows in the first table and all rows in the second table.
True
One reason for using an alias is simplicity.
self-join
Joining a table to itself, is called a ____.
all
If you precede the sub-query by the ___ operator, the condition is true only is it satisfies all values produced by the sub-query.
any
If you precede a sub-query by the ___ operator, the condition is true only is it satisfied one or more values produced by the sub-query.
qualify
When there is potential ambiguity in listing column names, you must ___ the columns involved in the query.
correlated
The sub-query that involves a table listed in the outer query is called a ___ sub-query.
intersect
The ___ of two tables is a table containing all rows that are in both tables.
True
When using a DBMS without an optimizer, the formulation of a query can make a difference in the speed with which the query is executed.
difference
The ___ of two tables is the set of rows that are in the first table but that are not in the second table.
duplicate
For an SQL implementation to truly support the union operation, it must remove ___ rows automatically.
all
If you precede a sub-query by the ___ operator, the condition is true only if it satisfied all values produced by the sub-query.
alias
When tables are listed in the from clause, you can give each table an ___ or an alternate name.
right outer join
In a ___, all rows from the table on the right will be included regardless of whether they match rows from the table on the left.
True
You can join tables by using a condition in the where clause.
optimizations
MySQL performs many built-in ___ that analyze queries to determine the best way to satisfy them.
full outer
In a ___ join, all rows from both tables are included regardless of whether they match rows from the other table.
union
the ____ of two tables is a table containing every row that is in either the first table, the second table, or both tables.
select
A ____ clause can include statistics calculated for only the groups or columns whose values are identical for each row in a group.
inner
Which of the following joins compares the tables in the from clause and lists only those rows that satisfy the condition in the where clause?
False
MySQL supports the intersect operator.
correlated
What a sub-query involves a table listed in the outer query, the sub query is called a ___ sub-query.
rows
If the SQL implementation truly supports the union operation, it will remove any duplicate ___ automatically.
exists
You can precede a sub-query with the ___ operator to create a condition that is true if one or more rows are obtained with the sub-query is executed.
union
The ___ of two tables is a table containing every row that is in either the first table, the second table, or both tables.
where
You join tables in SQL by including a condition in the ___ clause to ensure that matching columns contain equal values.
in
To retrieve data from multiple tables in a query you can use the ___ operator with a sub-query.
False
In small databases, there is a significant time difference between different query approaches.
True
It is permissible to quality all column names in a query.
False
For two tables to be union compatible, the columns of the two tables must be identical.
any
If you precede the sub-query by the ___ operator, the condition is true only is it satisfies any values produced by the sub-query.
...
You must join tables on matching columns.
Section 6
(50 cards)
varchar
In MySQL, use the ____ data type for variable-length character columns.
select
By placing a(n) _____ command in an INSERT command, you can add the query results to a table.
True
If you specify NOT NULL for a column when you create a table, you are prohibited from changing a value in the column to null.
rollback
In a transaction, if any update cannot be completed, execute the __ command and discontinue the updates for the current transaction.
commit
In a transaction, if you can complete all updates successfully, execute the ______ command after completing the final update.
show columns
In MySQL, use the ___ command to show the layout of a table.
rollback
If you have not run the COMMIT command, executing the ____ command will reverse all updates made during the current work session.
transaction
A(n) ________ is a logical unit of work.
rollback
If you decide that you do not want to save the changes you have made during your current work session, you can reverse the changes by executing the _____ command.
add
To add a new column, use the _____ clause of the ALTER TABLE command.
False
The DROP TABLE command creates an empty table
not null
If you specified ___ for the column when you created the table, then changing a value in a column to null is prohibited.
where
To make the same update for all rows in a table, omit the ____ clause.
show columns
In MySQL, use the ____ command to show the revised structure of a table.
all rows will be deleted from the table
What happens if you run a DELETE command that does not contain a WHERE clause?
delete
You use the ____ command to remove rows from a table.
transaction
A(n) ____ can be viewed as a sequence of steps that accomplishes a single task.
show columns
In MySQL, use the ____ command to show the layout of a table.
drop
You can delete a table that is no longer needed by using the ___ TABLE command.
commit
The ____ command is permanent.
set
The UPDATE command contains the word ____, followed by the name of the column to be updated, an equals sign, and the new value.
True
It is possible to use calculations to update a value in a column.
autocommit
In order to use the ROLLBACK commands in MySQL, you need to change the value for ____ to 0.
True
The data stored in tables is subject to constant change.
modify
You can use the ____ clause of the ALTER TABLE command to change a column that currently rejects null values so that it will accept null values.
order by
To sort rows in a specific order, use the ______ clause with the desired sort key(s).
modify
To change a column that currently rejects null values so that it accepts null values, use the ____ clause of the ALTER TABLE command
False
You can increase the length of a column but you cannot decrease the length of a column
delete
To delete data from the database, use the ____ command.
False
To verify that the correct change was made to data in a table, use the DISPLAY command
drop table
You can use the ____ command to delete an entire table and its data.
commit
Before beginning the updates for a transaction, commit any previous updates by executing the_____ command.
commit
If you have verified that the update you made is correct, you can use the ____ command to make the update permanent.
data
The ROLLBACK command reverses changes made to the _____ only.
alter table
With SQL, you can change a table's structure by using the _______ command.
rollback;
Which of the following commands executes a rollback?
column
The ADD clause consists of the word ADD followed by the name of the ___ to be added, followed by the characteristics.
False
When you use the CREATE TABLE command with the word LIKE to create a new table from an existing table, the new table has the same data as the original table
create table
You can use the ____ command to create a new table using data in an existing table.
False
The NULL value should be enclosed in single quotation marks
0
In order to use the COMMIT command in MySQL, you need to change the value for AUTOCOMMIT to ____.
drop table level1_customer:
Which of the following is a valid SQL command?
table
The format for the ALTER TABLE command is the words ALTER TABLE followed by the name of the _____ to be altered, followed by an appropriate clause.
commit;
Which of the following is a valid SQL command?
False
In a transaction, it is acceptable if some steps fail
like
The command CREATE TABLE LEVEL1_CUSTOMER ____ CUSTOMER; creates a new table from an existing table.
commit
During your current work session you can save your changes immediately by executing the _______ command.
modify
You can change the characteristics of existing columns by using the __ clause of the ALTER TABLE command
not null
If you specified ____ for a column when you created a table, then changing a value in a column to null is prohibited.
False
When necessary, include a WHERE clause into the UPDATE command to indicate the column on which the change is to take place.
Section 7
(50 cards)
AS
The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word ____, and then a query.
drop index
Which of the following commands deletes an index?
False
A view cannot involve statistics.
create index
The command used to create an index is ___.
True
When you specify a foreign key, the table referenced by the foreign key is the parent table.
security
___ is the prevention of unauthorized access to a database.
True
A view is a derived table.
show index
To list all the indexes associated with a table, use the ____ command.
row and columns
A(n) __ subset view consists of a subset of the rows and columns in some base table.
view
A(n) ___ is an application program's or an individual user's picture of the database.
database administrator
In a business organization, a person or an entire group known as the ____ is charged with managing the database.
False
If two base tables have the same primary key and the primary key is used as the join column, updating the database is a problem.
primary key
A view is updatable when it is derived from joining two base tables on the ____ of each table.
parent
When you specify a foreign key, the table referenced by the foreign key is the ____.
True
With a view, the display of data can be customized to meet each user's needs.
drop view
When a view is no longer needed, you can remove it using the ____ command.
all of the above
The types of constraints supported in MySQL are ____.
create unique index
To ensure the uniqueness of values in a non-primary key column, you can create a unique index by using the ___ command.
show columns
The ___ command lists all the columns in a given table.
show grants
Which of the following commands lists all the privileges granted to a user?
parentheses
When renaming columns, you include the new column names in ____ following the name of the view.
index
Within relational model systems on both mainframes and personal computers, the main mechanism for increasing the efficiency with which data is retrieved from the database is the ____.
drop view
Which of the following commands deletes a view?
False
When you specify a foreign key, the table containing the foreign key is the parent.
revoke
The database administrator uses the ____ command to revoke privileges from users.
update
The privilege ____ can be granted to change data.
drop index
The command used to delete an index is __.
view
A(n) ____ is an application program's or an individual user's picture of the database.
grant
The main mechanism for providing access to a database is the ________ command.
index
You can create and use a(n) __ to speed up the searching process significantly.
data dictionary
The system catalog is also called the ____.
with grant option
If the user needs to be able to pass the privilege to other users, the GRANT command must include the ____ clause.
add primary key
To add a primary key after creating a table, you can use the ___ clause of the ALTER TABLE command.
False
The GRANT command to indicate that a user has all privileges includes the FULL privilege.
False
If the database structure changes, the user cannot access and use the view.
references
The general form for assigning a foreign key is ADD FOREIGN KEY, the column name(s) of the foreign key, the ____ clause, and then the table name that the foreign key must match
revoke
The database administrator uses the ____ command to revoke privileges from users.
show tables
The ____ command lists all tables in the default database.
True
The DROP VIEW command removes only a view definition.
create view
To create a view definition, use the ___ command.
base
In general, views that involve joins of ___ tables can cause problems at update.
grant
The main mechanism for providing access to a database is the ____ command.
query
A view is defined by creating a defining __, which indicates the rows and columns to include in the view.
select
The privilege ____ can be granted to retrieve data.
True
The defining query for a view can be any valid SQL query.
constraint
An integrity ___ is a rule for the data in the database.
delete
The correct command to allow user Thompson to delete rows in the CUSTOMER table would be: GRANT ____ ON CUSTOMER TO THOMPSON.
alter
The privilege ____ can be granted to change the table structure.
catalog
Information about tables in the database is kept in the system ____.
administrations
The process of managing a database is called database _____.
Section 8
(50 cards)
importing
___ is the process of converting data to a MySQL database.
text
A(n) ____ file contains unformatted data.
table
In the MySQL Query Browser, the MySQL ____ Editor lets you view and change the columns in a table and their data types.
optimizer
A(n) ____ is a built-in program or routine that the DBMS uses to monitor and improve database performance.
a. algorithm c. optimizer
catalogs
In MySQL Administrator, you can perform table maintenance using the ____ section.
trx
The __ Browser lists all queries that make up a single transaction.
False
The EXPLAIN command examines a query statement after the query is executed.
history
In the MySQL Query Browser, the ____ Browser lets you browse all the previously created queries during your session.
params
The ___ Browser provides parameters that can help you build queries.
procedure analyse
The _____ function examines and analyzes query results.
object
In the MySQL Query Browser, the ____ Browser has three tabbed pages entitled Schemata, Bookmarks, and History.
exporting
____ is the process of converting the data in a MySQL database to a file format for use in another program.
replication
____ is the process of making multiple copies of the database.
load data infile
Use the ____ command to import a text file into MySQL.
tab-delimited
To import a text file into MySQL, the text file must be ____ and the data should not be enclosed in quotation marks.
user administration
In MySQL Administrator, you can use the ____ section to manage user privileges.
True
The SQL commands that you enter in the Query Area are identical to those that are used in the MySQL Command Line Client window.
False
The commands in the Syntax Browser are organized into five categories: Data Manipulation, Data Definition, MySQL Utility, Transaction and Locking, and Data Privileges.
html
____ files are text files that are used for creating and formatting web pages.
analyze table
The ____ command analyzes the data in a table and creates statistics that the MySQL optimizer uses.
health
In MySQL Administrator, you can use the ____ section to monitor database performance.
database performance
____ is defined as the speed or rate with which the DBMS supplies information to the user.
csv
A(n) _____ file is a text file in which values are enclosed in quotation marks and separated by commas.
True
To export all columns in a table use an asterisk after the word SELECT.
schemata
The __ Browser displays all databases on the MySQL server to which you are connected.
check table
The ______ command checks a table for errors, such as identifying corrupt tables resulting from not being closed properly.
optimize
The ____ command recovers unused space caused by fragmented files.
Repair Table
The ____ command fixes damaged or corrupted tables.
True
With the MySQL Query Browser, you can export a resultset to Microsoft Excel file format.
False
When you use the MySQL Query Browser, you do not need to run a query to export a table.
enum
The ____ data type is an object type with a value chosen from a list of allowed values that are enumerated explicitly in the column specification at the time the table is created.
mysql query browser
The _____ is a separate MySQL program that you can use to create and execute queries using a graphical user interface.
True
When you import a text file that contains blank lines, MySQL inserts a blank row at the end of the table.
administrator
MySQL ____ is a tool for performing administrative operations, such as monitoring the status and performance of MySQL.
syntax
The ___ Browser provides a quick reference to MySQL query syntax.
False
It is very unusual for data stored in a database to originate from other sources.
result area
In the MySQL Query Browser, query results appear in the ___ on tabbed pages.
schema
In the MySQL Query Browser, a database is referenced as a(n) ____.
bookmarks
In the MySQL Query Browser, the ____ Browser allows you to save queries that you use frequently.
select into outfile
Use the ____ command to export a MySQL table to a text file.
recovery
To back up a database using MySQL Administrator, use the ___ section.
create table
Before you can import data into a new table, you must use the ____ command to create the new table
recovery
The process of returning a database to its correct state after data has been damaged or destroyed is called _____.
False
The REPAIR TABLE command recovers unused space caused by fragmented files.
functions
The ___ Browser is a quick reference to the built-in functions available in MySQL.
explain
The _____ command examines a query statement before it is executed.
script editor
In the MySQL Query Browser, the ___ provides another way to create and edit scripts
False
To display query output vertically, include the \V command in the query.
xml
____ is a data interchange format that allows you to exchange data between dissimilar systems or applications.
Section 9
(1 card)