Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
11 Cards in this Set
- Front
- Back
|
Tables in relational databases can be related to other tables by which relationship? |
All of the above |
|
|
The _ is the computer that stores the file and databases of the system. |
Server |
|
|
DBMS stands for |
DataBase Management System |
|
|
A statement that would create a new database would look something like |
CREATEDATABASEPH_TEST |
|
|
Which of the following recommendations won't improve the readability of your SQL |
Use comments to describe what each statements does. |
|
|
The data type that is assigned to a column difines the type of information that can be stored there. |
True |
|
|
The result of a SELECT statement is called |
result set |
|
|
Which of the following types of statements isn't an action query? |
Select |
|
|
A _ consists of a SELECT statement that is stored with the database and can be managed independently of the applications that use them. |
View |
|
|
ANSI stands for |
American National Standards Institute |
|
|
Using the following code example
SELECT VendorName, InvoiceName FROM Invoice LEFT JOIN Vendors ON Invoices.VendorID=Vendors.VenforID
If the LEFT keyword was replaced with the RIGHT keyword, the total number of rows that are returned must equal
The total number of rows returned by this query must equal |
A. the number of rows in the Invoices table B. the number of rows in the Vendors table C. the number of rows in the Invoices table plus the number of rows in the Vendors table D. NONE OF THE ABOVE |
