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;
154 Cards in this Set
- Front
- Back
True/False A database will not only hold information about multiple types of entities, but also information about the relationships among these multiple entities.
|
True |
|
True/False A relationship is an association between attributes. |
False |
|
True/False The attributes of an entity become the rows in the table |
False |
|
True/False Eliminating redundancy is always possible when using a database approach. |
False |
|
A person who is in charge of a database within an organization is often called the database ____. |
adminstrator |
|
During the ____ process, a database expert determines the structure of the required database. |
database design |
|
A DBMS lets you assign users to ____. |
groups |
|
True/False A database cannot be password protected to prevent unauthorized users from accessing the data. |
False |
|
An integrity constraint is a rule that ____. |
data must follow in the database |
|
____ is the prevention of unauthorized access to the database. |
Security |
|
True/False Programs created with Visual Basic, Java, Perl, PHP, or C++ can access the database directly, rather than having to access it through the DBMS. |
False |
|
A(n) ____ is the computer counterpart to an ordinary paper file you might keep in a file cabinet or an accounting ledger. |
data file |
|
___ is a property that lets you change the structure of the database without requiring you to change the programs that access the database |
Data independence |
|
One disadvantage of a database system is ____. |
a larger file size |
|
___ are screen objects used to maintain, view, and print data from a database. |
Forms |
|
True/False A good DBMS provides integrity constraints, which are features that let you change the structure of the database without changing the programs that access the database. |
False |
|
A(n) ____ frees programmers who write database access programs from having to engage in mundane data manipulation activities, such as adding new data and deleting existing data. |
DBMS |
|
A(n) ____ is a person, place, object, event, or idea for which you want to store and process data. |
entity |
|
true/false A spreadsheet’s data-sharing features allows multiple employees to update data in one spreadsheet at the same time. |
False |
|
The ____ of an entity become the columns in the database table. |
attributes |
|
True/False To support all the complex functions that it provides to users, a DBMS must store data in multiple files. |
False |
|
A(n) ____ is a characteristic or property of an entity. |
attribute |
|
True/False
There is a greater impact of failure in a nondatabase, file-oriented system. |
False |
|
A good ____ should provide an opportunity for users to incorporate integrity constraints when they design the database. |
DBMS |
|
True/False An attribute is a characteristic or property of an entity. |
True |
|
True/False In a database, each entity has its own table. |
True |
|
Storing the same data in more than one place is called ____. |
redundacy |
|
True/False Redundancy wastes space because you are storing the same data in more than one place. |
True |
|
A visual way to represent a database is with a(n) ____. |
entity-relationship diagram |
|
True/False Sharing data is one advantage of database processing. |
True |
|
Which of the following statements is correct? Answers: a.)In a nondatabase, file-oriented environment, data is often partitioned into several disjointed systems with each system having its own collection of files.
b.)User data cannot be combined and shared among authorized users.
c.)Database users should not have access to the same information.
d.)The elimination of redundancy is always possible. |
a.)In a nondatabase, file-oriented environment, data is often partitioned into several disjointed systems with each system having its own collection of files |
|
Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server. |
DBMSs |
|
An association between entities is known as a(n) ____. |
relationship |
|
True/False In an entity-relationship (E-R) diagram, rectangles represent entities and lines represent relationships between connected entities. |
True |
|
A database has ____ if the data in it satisfies all established integrity constraints. |
integrity |
|
The ____ command within relational algebra takes a vertical subset of a table. |
PROJECT |
|
True/False QBE is a visual approach to writing queries. |
True |
|
True/False A relation is essentially just a two-dimensional table. |
True |
|
When duplicate column names exist in a database and you need to indicate the column to which you are referring, ____. |
write both the table name and the column name, separated by a period |
|
True/False In a relation, the order of rows is important. |
False |
|
Using the product operator, if table A has 4 rows and table B has 4 rows, the number of rows in the product of these two tables is ____. |
16 |
|
Count, Sum, Avg, Max, and Min are a few of the built-in statistics or ____ functions that can be used in a query. |
aggregate |
|
True/False A relational database is a collection of relations. |
True |
|
You can restrict the output from a join to include only certain columns by using the ____ command. |
PROJECT |
|
A ____ query creates a new table using the query results. |
Make-table |
|
The ____ operator is performed by the SUBTRACT command in relational algebra. |
difference |
|
True/False The concept of grouping means that statistics will be calculated for individual records. |
False |
|
True/False
A relational database handles entities, attributes, and relationships by storing each entity in its own table. |
True |
|
Based on the statement below, which of the following is the primary key? |
PartNum |
|
True/False When a field name contains spaces or SQL reserved words, you must enclose the field name in curly braces ({}). |
False |
|
True/False The secondary key provides an important way of distinguishing one row in a table from another. |
False |
|
Rows are also called ____. |
tuples |
|
The ____ operator is used to concatenate every row in the first table with every row in the second table. |
product |
|
Two tables are considered to be ____ compatible if they have the same number of columns and their corresponding columns represent the same type of data. |
union |
|
If you are sorting records by more than one field, the more important field is called the ____. |
Primary Sort Key |
|
True/False Access automatically adds double quotation marks around values in the design grid that are formatted as Text fields when you run the query or move the insertion point to another cell in the design grid. |
True |
|
True/False An unnormalized relation is a table that has more than one row. |
False |
|
The ____ command within relational algebra includes the word OVER followed by a list of the columns to be included. |
PROJECT |
|
True/False In a relation, the order of the columns is immaterial. |
True |
|
True/False The attributes of an entity become the rows or records in a table. |
False |
|
The compound criteria (conditions) are created by using ____. |
AND or OR |
|
The product of two tables is also called the ____ product. |
Cartesian |
|
True/False In an OR criterion, the overall criterion is true if either of the individual criteria is true. |
True |
|
A relation is a(n) ____. |
table |
|
Based on the Customer table below, which command lists all information from the table concerning customer 524? |
SELECT Customer WHERE CustomerNum=524 GIVING Answer |
|
True/False The comparison operators are +, *, %, and /. |
False |
|
A query that changes data is a(n) ____ query. |
update |
|
The ____ key of a table is the column or collection of columns that uniquely identifies a given row in that table. |
primary |
|
True/False
The comparison operators are also known as relational operators. |
True |
|
Which operation will allow you to extract data from more than one table? |
Join |
|
True/False The IN operator can be used instead or the OR operator in phrasing certain conditions. |
True |
|
True/False Preceding a condition by the NOT operator reverses the truth or falsity of the original condition. |
True |
|
Student (StudentID, FirstName, LastName, Street, City, State, Zip) |
SELECT * FROM Student ; |
|
True/False Most relational DBMSs use a version of SQL as a data manipulation language. |
True |
|
Student (StudentID, FirstName, LastName, Street, City, State, Zip) |
SELECT FirstName, LastName FROM Student WHERE Zip=‘10113’ ; |
|
True/False There are two versions of the “not equal to” operator: <> and !=. |
True |
|
True/False Fields will appear in the query results in the order in which they are listed in the SELECT clause. |
True |
|
True/False The HAVING clause is to groups what the WHERE clause is to rows. |
True |
|
Student (StudentID, FirstName, LastName, Street, City, State, Zip) |
SELECT FirstName, LastName FROM Student WHERE StudentID=’1167’ ; |
|
Student (StudentID, FirstName, LastName, Street, City, State, Zip) |
UPDATE Student SET Zip=’14455’ WHERE StudentID=’11433’ ; |
|
When a subquery is used, ____ is(are) evaluated first. |
the subquery query |
|
Part (PartNum, Description, OnHand, Class, Warehouse, Price ) Based on the code above, find how many parts are in item class HW. |
SELECT COUNT(*) FROM Part WHERE Class=’HW’ ; |
|
True/False CHAR data types are numbers without a decimal part. |
False |
|
In MySQL, the ____ is used as a wildcard to represent any collection of characters. |
Percent sign (%) |
|
The basic form of an SQL retrieval command is ____. |
SELECT-WHERE-FROM |
|
True/False A WHERE and a HAVING clause cannot be included in the same query. |
False |
|
OrderLine (OrderNum, PartNum, NumOrdered, QuotedPrice) |
DELETE FROM OrderLine WHERE PartNum=’BV06’ ; |
|
Customer ( CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum ) |
SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance BETWEEN 1000 AND 5000 ; |
|
True/False To create numbers with decimals in Access, you can use the CURRENCY, NUMBER, or DECIMAL data types. |
False |
|
Customer ( CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum ) |
SELECT CustomerNum, CustomerName, Street, City, State, Zip FROM Customer WHERE Street LIKE “%Oxford%” ; |
|
True/False In a SELECT statement, the WHERE clause is mandatory. |
False |
|
Customer ( CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum ) |
SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance ; |
|
Many versions of SQL require you to end a command with a ____. |
semicolon (;) |
|
True/False You can combine values in character fields as well as number fields. |
True |
|
True/False In SQL, you join tables by entering the appropriate conditions in the WHERE clause. |
True |
|
Customer ( CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum ) |
SELECT RepNum, COUNT(*), AVG(Balance) FROM Customer GROUP BY RepNum ORDER BY RepNum |
|
True/False The rules for naming tables and columns are the same in every version of SQL. |
False |
|
True/False The BETWEEN operator is an essential feature of SQL. |
False |
|
When you use a name containing a space in Access SQL, you must ____. |
enclose it in square brackets |
|
True/False When you enter numbers in an SQL command, you do not type commas or dollar signs. |
True |
|
True/False When rows are grouped, one line of output is produced for each group. |
True |
|
Customer ( CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum ) |
SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit DESC, CustomerName ; |
|
The ____ clause can be used to create groups of records. |
GROUP BY |
|
Customer ( CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum ) |
SELECT CustomerNum, CustomerName, CreditLimit-Balance AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ; |
|
You can save the results of a query as a table by including the ____ clause in the query. |
INTO |
|
When used after the word SELECT, the ____ symbol indicates that you want to include all fields in the query results in the order in which you described them to the DBMS when you created the table. |
* |
|
The ____ function determines the largest value in a given column. |
MAX |
|
True/False You can use the GROUP BY clause and the ORDER BY clause in the same SELECT statement. |
True |
|
In Access SQL, the ____ is used as a wildcard to represent any individual character. |
question mark (?) |
|
To use a wildcard, include the ____ operator in the WHERE clause. |
LIKE |
|
True/False When a query involves a character field, such as CustomerName, you must enclose the value to which the field is being compared in percent symbols (%). |
False |
|
True/False In SQL, you use the SORT BY clause to display results in a desired order. |
False |
|
Part (PartNum, Description, OnHand, Class, Warehouse, Price ) |
SELECT Description FROM Part WHERE Warehouse=’3’ AND OnHand>20 ; |
|
When rows are grouped, ____. |
one line of output is produced for each group |
|
To add new data to a table, use the ____ command. |
INSERT |
|
Part (PartNum, Description, OnHand, Class, Warehouse, Price ) |
SELECT Description FROM Part WHERE Warehouse=’3’ OR OnHand>20 ; |
|
True/False Instead of listing all the field names in the SELECT clause, you can use the * symbol. |
True |
|
Part (PartNum, Description, OnHand, Class, Warehouse, Price ) |
SELECT Description FROM Part WHERE NOT Warehouse=’3’ ; |
|
n order to make changes to existing data in a table, you would use the ____ command. |
UPDATE |
|
A(n) ____ is an action that occurs automatically in response to an associated database operation such as an INSERT, UPDATE, or DELETE command. |
trigger |
|
A trigger is stored and compiled on the ____. |
server |
|
In SQL, you use the CHECK clause to enforce ____ integrity. |
legal-values |
|
The ____ statement will take away user privileges to the database. |
REVOKE |
|
To create the primary key clause for the Orders table on the OrderNum and PartNum fields, the correct statement is ____. |
PRIMARY KEY (OrderNum, PartNum) |
|
To create an index for the Customer table named RepBal with the keys RepNum and Balance and with the balances listed in descending order, the command is ____. |
CREATE INDEX RepBal ON Customer (RepNum, Balance DESC) ; |
|
The statement, ____, removes the table LargeCust from a DBMS. |
DROP TABLE LargeCust; |
|
The CHECK clause can be included in the ____ command. |
CREATE TABLE |
|
To insert a new field in a table, the ____ keyword should be used with the ALTER TABLE command. |
ADD |
|
True/False
The following command will revoke the ability to retrieve Customer records from user Jones: |
False |
|
The ____ command will create an application program's or individual user's picture of the database. |
CREATE VIEW |
|
True/False The following command will enable Jones to retrieve data from the Customer table, but not to take any other action: GRANT SELECT ON Customer TO Jones ; |
True |
|
To create the primary key clause for the Customer table on the CustomerNum field, the correct statement is ____. |
PRIMARY KEY (CustomerNum) |
|
True/False Information about tables in the database is kept in the system catalog. |
True |
|
To create a trigger in MySQL, use the _____ command. |
CREATE TRIGGER |
|
The SQL command for deleting the Warehouse field from the Part table is ____. |
ALTER TABLE Part DROP COLUMN Warehouse ; |
|
True/False One advantage of a view is that different users can view the same data in different ways. |
True |
|
A(n) ____ is a computer that is connected to a network and has access through the server to the database. |
client |
|
If you anticipate running a particular query often, you can improve overall performance by saving the query in a special file called a(n) ____. |
stored procedure |
|
To use a stored procedure in MySQL, a user enters the word _____ followed by the procedure name. |
CALL |
|
True/False When you create an index whose key has a single field, you have created what is called a primary index. |
False |
|
True/False The SELECT command that creates the view, which is called the view query, indicates what to include in the view. |
False |
|
True/False Legal-values integrity is the property that states that no record can exist in the database with a value in the field other than one of the legal values. |
True |
|
True/False A stored procedure is placed on a client computer. |
False |
|
True/False The command DELETE INDEX CustList; would remove the index named CustList. |
False |
|
True/False Views cannot be used to examine table data. |
False |
|
True/False To create a view in Access, you simply create and then save a query |
True |
|
True/False To change the field names in a view include the AS clause in the CREATE VIEW command. |
True |
|
True/False Once you add an index to a database, you cannot delete it. |
False |
|
True/False An individual can use a view to create reports, charts, and other objects that show database data. |
True |
|
n MySQL, you use the _____ command to produce a list of tables. |
SHOW TABLES |
|
Essentially, setting the value in a given field to ____ is similar to not entering a value in it at all. |
null |
|
What statement fragments will only allow a CreditLimit of $7,500, $10,000, or $15,000? |
CHECK (CreditLimit IN (7500, 10000, 15000)) |
|
In Access, many macro actions require additional information, called _____ to complete the action. |
arguments |
|
True/False Access 2010 supports data macros. |
True |