Section 1
Preview this deck
When you code an UPDATE statement for one or more rows, the SET clause names the columns to be updated and the values to be assigned to those columns, and the ______________________ clause specifies the conditions a row must meet to be updated.
Front
| 5 | 0 | ||
| 4 | 0 | ||
| 3 | 0 | ||
| 2 | 0 | ||
| 1 | 0 |
Active users
0
All-time users
0
Favorites
0
Last updated
6 years ago
Date created
Mar 1, 2020
Cards (62)
Section 1
(50 cards)
When you code an UPDATE statement for one or more rows, the SET clause names the columns to be updated and the values to be assigned to those columns, and the ______________________ clause specifies the conditions a row must meet to be updated.
WHERE
A SQL script is a file that contains one or more ___________________.
SQL statements
Data processed in a way that increases a user's knowledge is:
INFORMATION
The interface between an application program and the DBMS is usually provided by the
data access API
A database driver is software that lets the
data access model communicate with the database
In MySQL Workbench, you can start or stop the MySQL database server by clicking the Start Server button in the _______________________ window.
Navigator
A person is an example of an entity.
TRUE
When you code a DELETE statement for one or more rows, the _________________ clause specifies which row or rows are to be deleted.
WHERE
When coded in a WHERE clause, which of the following search conditions will not return a result set that includes all invoices with an invoice_total value of $1000 or less?
invoice_total IN (0, 1000)
Which of the following statements best describes what this INSERT statement does? INSERT INTO invoices_copy SELECT * FROM invoices WHERE terms_id = 1
Adds all of the rows in the Invoices table that have 1 in the terms_id column to the Invoices_Copy table.
A data model is a graphical system used to capture the nature and relationships among data.
TRUE
To concatenate character strings, you use the ___________________ function in a string expression.
CONCAT
A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n):
entity
A constraint is a rule in a database system that can be violated by users.
FALSE
The order of precedence for the logical operators in a WHERE clause is
Not, And, Or
Which of the following is not a common error when entering and executing SQL statements?
Forgetting to connect to a database
To retrieve rows in which an expression matches a string pattern called a mask, you can use the ______________ keyword followed by the mask.
Like
A database is an organized collection of ________ related data.
logically
The most common type of relationship between two tables is a/an _______________________ relationship.
One-to-many
Write the code for a DELETE statement that deletes every row in the Invoices_Copy table:
DELETE FROM Invoices_Copy
In a SQL Editor tab of MySQL Workbench, you can do all but one of the following. Which one is it?
create a database diagram
When you have access to a table through MySQL Workbench, you can view both the column definitions for the table and the ______________________ in the table.
data
All of the following are primary purposes of a database management system (DBMS) EXCEPT:
providing an integrated development environment
Which of the following is not true when you're using MySQL Workbench to test a script that contains more than one SQL statement?
. You cannot run all of the statements in the script at once.
To insert rows selected from one or more tables into another table with an INSERT statement, you code a/an ___________________________ in place of the VALUES clause.
Subquery
An _________________ statement is used to retrieve selected columns and rows from a base table.
SELECT
To save your own code in MySQL Workbench so that you do not have to type it each time, you can create a new
Snippet
The most common source of database failures in organizations is:
Failure to implement a strong database administration function
Which of the following types of data can be stored in a database?
Voice,Letters,Numbers ....ALL OF THE ABOVE
By default, MySQL automatically commits changes to the database immediately after each INSERT, UPDATE, and ______________ statement that you issue.
DELETE
A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory
TRUE
A modern database management system automates more of the backup and recovery tasks than a file system.
TRUE
When a column in a table is defined, it is given a data ________________ that determines what kind of data it can store.
TYPE
To prevent duplicate rows from being returned by a SELECT statement, you can code the __________________ keyword in the SELECT clause.
DISTINCT
Assuming that all of the table and column names are spelled correctly, what's wrong with the INSERT statement that follows? INSERT INTO invoices (vendor_id, invoice_number, invoice_total, payment_total, credit_total, terms_id, invoice_date, invoice_due_date) VALUES (97, '456789', 8344.50, 0, 0, 1, '2012-08-31')
The number of items in the column list doesn't match the number in the VALUES list.
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
If you code a column list in an INSERT statement that includes a column that's defined with a default value, you can insert the default value for that column by coding the ____________________ keyword in the VALUES clause of the INSERT statement.
DEFAULT
A graphical system used to capture the nature and relationships among data is called a(n):
data model
Which of the following is software used to create, maintain, and provide controlled access to databases?
Database management system
Which of the following types of SQL statements is not a DML statement?
CREATE TABLE
Languages, menus, and other facilities by which users interact with the database are collectively called a(n):
User Interface
The result of a SELECT statement is
a result set
Which of the following is NOT an advantage of database systems?
Redundant data
___________________________ is a command-line tool that you can use for running SQL statements.
MySQL Command Line Client
When you run a SQL statement that contains a coding error, MySQL Workbench displays an error message that does not include
the likely cause of the error
To override the order of precedence in an arithmetic expression, you can use __________________.
parentheses
Which of the following statements is true when you use MySQL Workbench to run INSERT, UPDATE, and DELETE statements?
By default, the changes are automatically committed to the database.
The type of operation that retrieves data from two or more tables is called a
JOIN
SQL statements that define the tables in a database are referred to as ----- statements.
DDL
You can use the AS keyword with the CREATE TABLE statement to create a copy of a table from a ____________________ statement.
SELECT
Section 2
(12 cards)