DataBase Midterm

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

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


Ensembles d'études connexes

ATI Pharmacology 4.0 Hematologic System

View Set

NSG 170 lecture *EXAM 4 (sexuality/reproduction)

View Set

Topic 5: The Statement of Cash Flows

View Set

Aristotle's Ethics / The Golden Mean

View Set

CCNA Final Set 2, CCNA 2 Final set 1

View Set

Frankenstein Reading Questions Chapters 9-10

View Set

Psychology 370 Cognition Chapter 4 Exam Review

View Set