Database management test 1

Data consistency means

giving each user a consistent view of the data including changes

Which term can be described as the duplication of data and storing data in multiple locations

redundancy

The ERM emphasizes what part of a relational database

relationships

How are entities represented in a relational database

Each entity is stored as a table

Which SQL keywords start an SQL statement to append a new record to a table

INSERT INTO

what is the primary purpose of creating an index

Improving the speed by which data os searched and presented

Why doesn't Access SQL provide for the SWL CREATE VIEW statement

In Access, queries function as views

Which Access field property might you use to set data integrity rules on a single field

Validation rule

Which feature of ACCESS mimics that of relational database management system triggers

data macros

How do you identify the primary key field in DBDL notation

with and underline as well as the abbreviation PK

Which symbol is a wildcard representing any number of character - * - <> - & - #

*

Which of the following is not a constraint on the primary key field for a table -There may be no null values -All values must be unique All values must have a matching value in the foreign key field of the table in which it has a one-to-many relationship -All values must contain data within the data type assigned to that field

All the values must have a matching value in the foreign key field of the table in which it has a one-to-many relationship

Which SQL operator can be rewritten with >= AND <= operators

Between

Which of the following is not an atomic value - 15 - Oklahoma City - IBM Corporation - Bill Gates

Bill Gates

Which of the following database architectures is most closely aligned with traditional, enterprise-level relational databases -Centralized -Client/Server -Data Warehouse - Distributed

Centralized

What type of software programs are Access, Oracle, DB2, MySQL and SQL Server

DBMS

Which of the following is not a benefit of the database normalization process -Redundant data is minimized -Data is simplified into only the important attributes Data is more accurate -Data is more consistant

Data is simplified into only the important attributes

Which of the following is a drawback of flat files

Data partitioned into several separate files can be difficult to summarize

What is the term for a collection of data organized in a manner that allows access, retrieval, and use of the data?

Database

Which feature of Access is used to create a report on the metadata about tables and queries

Database Documenter

Which of the following is not a characteristic of a healthy relation -Each column has a distinct name (technically called the attribute name) - Each intersection of a row and column in a table may contain more than 1 value - all values in a column are values of the same attribute - the order of the rows and columns are not important

Each intersection of a row and column in a table may contain more than one value

Who invented normalization

Edgar F. Codd

In a _____________, rectangles represent entities and display their attributes; lines represent relationships between connected entities

Entity- Relationship Diagram

Which of the following statements is true about a one-to-many relationship - Every primary key field participates on the "one" side - Every foreign key field participates on the "one" side - Every Primary key field participates on the "many" side - Every foreign key field participates on the "many" side

Every foreign key participates on the "many" side

Which of the following statements is correct? - User data cannot be combined and shared amount authorized users - Database users should each work on their own copy of the database - In a flat-file environment, data is partitioned into several disjointed systems, lists, and files - Controlling redundancy is easier in an flat file than in a database

In a flat-file environment, data is partitioned into several disjointed system, lists and files

Which of the following best describes functional dependence -It describes the relationship of attributes in an entity -It describes the relationship of tuples in an entity -It describes the relationship of entities as compared to other entities -It describes the relationship of unnormalized data to 1NF

It describes the relationship of attributes in an entity

With _________, only one criterion must evaluate true order for a record to be selected and with ___________, All criteria must be evaluate true in order for a record to be selected

OR criteria, AND criteria

Which of the following programming languages does the "P" in modern software solution stacks such as the LAMP, LAPP, and WAMP -PHP -Python -Perl -Pascal

Pascal

A __________ can store information about multiple types of entities and the relationships among the entities

Relational database

Which of the following is a reason to store business data in a database rather than in a spreadsheet

Spreadsheets have limited data sharing and security features

Which file extension is a type of XML file -XLSX -JSON -TXT -DBF

XLSX

What does it mean to enforce referential integrity on a not to many relationship

You may not create orphan records by entering a phony foreign key value in the many table

What do two tables use to link related records from each table

a common field

Which of the following is a screen object used to maintain and view data from a database - report - form -macro -spreadsheet

a form

a __________ is a set go rules, calculations, and assumptions used to solve a problem

algorithm

Which of the following tasks is a data analyst likely to preform - Maintain the company database -install software to work with the database design a new database apply an algorithm to find sales trends

apply an algorithm to find sales trends

which of the following is not a technique that would be used in the process of developing a relational database -Normalize the data -Review existing data forms and reports - Interview those who use the data to understand business rules -combine all attributes into one large table

combine all attributes into one large table

According to the bureau of labor statistics, what is the job growth outlook for database admins

faster than average

Which of the following are screen objects used to maintain, view, and print data from a database -forms -data files -entities -fields

forms

Which of the following is a problem that data redundancy causes - Removal of primary key fields -increased data errors and inconsistencies -Increased data independence -removal of orphan records

increased data errors and inconsistences