• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/154

Click to flip

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?
Part (PartNum, Description, OnHand, Class, Warehouse, Price)

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?
CustomerNum CustomerName Street City State Zip
462 Bargains Galore 3829 Central Grove FL 33321
524 Kline’s 838 Ridgeland Filmore FL 33336

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)

Based on the code above, list the complete student table.

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)

Based on the code above, list the name of every student whose Zip code is 10113.

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)

Based on the code above, find the name of the student whose ID is 1167.

SELECT FirstName, LastName FROM Student WHERE StudentID=’1167’ ;

Student (StudentID, FirstName, LastName, Street, City, State, Zip)

Based on the code above, change the Zip code of the student with ID 11433 to 14455.

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)
Part (PartNum, Description, OnHand, Class, Warehouse, Price )

Based on the code above, delete any row in the OrderLine table in which the part number is BV06.

DELETE FROM OrderLine WHERE PartNum=’BV06’ ;

Customer ( CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum )

Based on the code above, list the number, name, and balance of all customers with balances greater than or equal to $1,000 and less than or equal to $5,000.

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 )

Based on the code above, list the number, name, and complete address of every customer located on a street that contains the letters “Oxford”.

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 )

Based on the code above, list the number, name, credit limit, and balance for all customers with credit limits that exceed their balances.

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 )

Based on the code above, for each sales rep, list the rep number, the number of customers assigned to the rep, and the average balance of the rep’s customers. Group the records by rep number and order the records by rep number.


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 )

Based on the code above, list the number, name, street, and credit limit of all customers. Order the customers by name within descending credit limit.


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 )

Based on the code above, list the number, name, and available credit for all customers with credit limits that exceed their balances.

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 )

Based on the code above, list the descriptions of all parts that are located in Warehouse 3 and for which there are more than 20 units on hand.

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 )

Based on the code above, list the descriptions of all parts that are located in Warehouse 3 or for which there are more than 20 units on hand, or both.

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 )

Based on the code above, list the descriptions of all parts that are not in Warehouse 3.

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:
REVOKE GRANT ON Customer FROM 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