DataBase Midterm
If you are sorting records by more than one field, the more important field is called the
Primary Sort key/Major Sort key.
In Access SQL, the _______is used as a wildcard to represent any individual character.
Question Mark
. In an E-R diagram,______ represent entities.
Rectangles
Eliminating_______ not only saves space but also makes the process of updating data much simpler.
Redundancy
Storing the same data in more than one place is called
Redundancy
The problem of inconsistency in data is a direct result of_____
Redundancy
A relation is a(n) ____.
two-dimensional table
You can use the SQL CREATE TABLE command to insert rows into a table.
False
When a subquery is used,____ is(are) evaluated first.
the subquery
Rows are also called
tuples/records.
Redundancy wastes space because you are storing different types of data in the same Place.
False
The comparison operators are +, *, %, and /.
False
The concept of grouping means that statistics will be calculated for individual records.
False
There is a greater impact of failure in a nondatabase, file-oriented system.
False
There is no difference between the COUNT function and the SUM function.
False
To create forms to use with a database you must write a program.
False
The compound criteria (conditions) are created by using
AND OR
A person who is in charge of a database within an organization is often called the database______
Administrator
Count, Sum, Avg, Max, and Min are a few of the built-in statistics or _____ unctions that can be used in a query.
Aggregated
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.
Asterisk
Instead of listing all the field names in the SELECT clause, you can use the @ symbol.
Asterisk symbol
A(n) is also called a field or column in many database systems.
Attribute
The of an entity become the columns in the database table.
Attributes
The_____function calculates the number of entries in a table.
Count
A(n) s the computer counterpart to an ordinary paper file you might keep in a file cabinet or an accounting ledger.
Data File
When you connect simple conditions using the AND operator, all the simple conditions must be false for the compound condition to be true.
False
A group of people in charge of a database within an organization is often called the_____
Data-base administration.
A(n)_______rees programmers who write database access programs from having to engage in mundane data manipulation activities, such as adding new data and deleting existing data.
Database Management System (DBMS)
Popular include Access, Oracle, DB2, MySQL, and SQL Server.
Database Management System (DBMS)
A good_____has many features that allow users to gain access to data in a database without having to do any programming.
Database Management System(DBMS)
A good____should provide an opportunity for users to incorporate integrity constraints when they design the database.
Database Management System(DBMS)
A program, or collection of programs, through which users interact with a database is known as a(n) ____________
Database Management System(DBMS).
______is a property that lets you change the structure of the database without requiring you to change the programs that access the database.
Database independence
In an E-R diagram, the _____at the end of a line indicates the "many" part of the one-to-many relationship between two entities.
Dot
A(n) is a person, place, object, event, or idea for which you want to store and process data.
Entity
Unlike a typical data file, a database can store information about multiple_________
Entries
. A valid name for a table might be tbl$Student.
False
A column whose value uniquely identifies a given row in the table is the secondary key.
False
An attribute is known as a row in most databases.
False
An entity is also defined as an attribute.
False
An unnormalized relation is a table that has more than one row.
False
CHAR data types are numbers without a decimal part.
False
Each table in a database represents two or more entities.
False
Fields will appear in the query results in the order in which they are listed in the SELECT clause.
False
In a SELECT statement, the WHERE clause is mandatory.
False
In a relation, the order of the columns is important.
False
In an AND criterion, the overall criterion is true if either of the individual criteria is 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
________are screen objects used to maintain, view, and print data from a database.
Forms
The______clause can be used to create groups of records.
GROUP BY
A DBMS lets you assign users to____
Groups
. To use a wildcard, include the_______operator in the WHERE clause.
Like
In an E-R diagram,______ represent relationships between connected entities.
Lines
A database file requires a large amount of disk space and internal____
Memory
Based on the statement below, which of the following is the primary key? Rep (RepNum, LastName, FirstName, Street, City, State, PostalCode Commission, Rate)
RepNum
The basic form of an SQL retrieval command is_______
SELECT-FROM-WHERE
___is the prevention of unauthorized access to the database.
Security
A DBA can assign passwords to prevent unauthorized users from accessing the data.
True
A WHERE and a HAVING clause cannot be included in the same query.
True
A database will not only hold information about multiple types of entities, but also information about the relationships among these multiple entities.
True
A query is a question represented in a way that the DBMS can recognize and process.
True
A relational database handles entities, attributes, and relationships by storing each entity in its own table.
True
A relational database is a collection of relations.
True
A simple condition includes the field name, a comparison operator, and either another field name or a value.
True
Access automatically adds double quotation marks around values in the design grid that are formatted as Short Text fields when you run the query or move the insertion point to another cell in the design grid.
True
An advantage of using the database approach to processing is that it facilitates Consistency
True
An attribute is a characteristic or property of an entity
True
Each column in a table should have a unique name, and entries in each column should all "match" this column name.
True
For each pair of tables to be joined, a condition must be included indicating how the tables are related.
True
In a relation, the order of rows is important.
True
Preceding a condition by the NOT operator reverses the truth or falsity of the original condition.
True
QBE is a visual approach to writing queries.
True
SQL uses commands to create tables, update tables, and retrieve data from tables.
True
Sharing data is one advantage of database processing.
True
Software packages, called database management systems, can do the job of manipulating databases for you.
True
The BETWEEN operator is an essential feature of SQL.
True
The HAVING clause is to groups what the WHERE clause is to rows.
True
The IN operator provides a concise way of phrasing certain conditions.
True
The attributes of an entity become the fields or columns in a table.
True
The comparison operators are also known as relational operators.
True
The relationship between different entities (in different tables) is handled by their common columns.
True
There are two versions of the "not equal to" operator: <> and !=.
True
When rows are grouped, one line of output is produced for each group.
True
When you need to change data, redundancy makes your changes more cumbersome and time-consuming.
True
You can combine values in character fields.
True
You can use the GROUP BY clause and the ORDER BY clause in the same SELECT statement.
True
A query that changes data is a(n) ________ query
Update
When duplicate column names exist in a database and you need to indicate the column to which you are referring,
You would write the table and the column name separated by a period.
One disadvantage of a database system is_____
a larger file size.
An integrity constraint is a rule that
data must follow in the database.
During the process, a database expert determines the structure of the required database.
database design
When you use a name containing a space in Access SQL, you must__________
enclose it in square brackets
A visual way to represent a database is with a(n)__________
entity-relationship (ER) diagram.
A database has if the data in it satisfies all established integrity constraints.
integrity
A_________uery creates a new table using the query results.
make-table
When rows are grouped
one line of output is produced for each group.
In a(n)________ relationship between two entities, each occurrence of the first entity is related to many occurrences of the second entity and each occurrence of the second entity is related to only one occurrence of the first entity.
one-to-many
In versions of SQL other than Access, the________is used as a wildcard to represent any collection of characters.
percent sign
The_____key of a table is the column or collection of columns that uniquely identifies a given row in that table.
primary
Many versions of SQL require you to end a command with a
semicolon