Database Final - Exam 1 Questions
The creation of a database and its tables is a function of which component of the database system?a.DBMS b.Application c.Web server d.Database e.Users
A.DBMS
Which of the following is not one of the five SQL built in functions? MAX AVERAGE SUM AVG COUNT
AVERAGE
A database is a set of one or more computer programs that serves as an intermediary between the users and the database management system (DBMS). True False
False
While the relational model for databases appears to hold much purpose, few commercial databases have implemented it. T/F
False
With the traditional filing processing approach, each application shares data files, thus enabling much data sharing.
False
Program data dependence is caused by: Data descriptions being stored on a server Data cohabiting with programs Data descriptions being written into programming code File descriptions being stored in each database application
File descriptions being stored in each database application
Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY?
HAVING
The SDLC phase in which database processing programs are created is the ____ phase.
Implementation
In SQL, the IS NULL keyword can be used to select on records containing NULL values in a particular column.
True
In a 1:1 relationship, a single entity instance of one type is related to a single entity instance of the same or another type.T/F
True
One or more entities can be associated together in relationships.
True
To represent a relationship in the relational model, the primary key of one relation is placed into a second relation
True
Which symbol is used in standard SQL as a wildcard to represent a single, unspecified character?
_
A departmental multi~tiered client/server database is stored on a central device called a: a.Server b.Network c.Remote PC d.Client
a. Server
Which of the following is an entity that exists independently of other entity types? a.Strong b.Variant c.Weak d. Codependent
a. Strong
Relational databases establish the relationships between entities by means of common fields included in a file called a(n): a) relation b) entity c) association d) relationship
a.relation
The number of entity classes involved in a relationship is known as the relationship's ____ Degree Minimum cardinality Ordinarily Class Maximum cardinality
degree
An attribute of an entity that is computed is a(n) Fuzzy attribute Derived attribute Optional attribute Composite attribute
derived attribute
A key must be unique True False
false
In the relational model, each row of a table contains data that represents an attribute of the entity True False
false
There is usually only one instance of an entity in an entity class True False
false
When used to represent a relationship, the primary key must have the same name as the corresponding foreign key. True False
false
Business policies and rules govern all of the following except: Updating data, Removing data, Creating data, Managing employees
managing employees
Data that describe the properties of other data are: Metadata, Relationships, Physical, Logical
metadata
The number of entity types that participate in a Unary relationship is One Zero Two Three
one
With the database approach, data descriptions are stored in a central location known as a: server PC Mainframe Repository
repository
Which of the following terms is synonymous with "tuple"? Field Row Relation Attribute Table
row
Which of the following terms is synonymous with "relation"? Record Attribute Table Row Tuple
table
A data model is a graphical system used to capture the nature and relationships among data.
true
A person is an example of an entity. True False
true
A possible problem with keeping data in files is that if you delete a row of data from a file, you may also delete some data items that you want to keep. True False
true
Ensuring that every value of a foreign key matches a value of the corresponding primary key is an example of referential integrity constraint. True False
true
In SQL, the LIKE keyword can be used to select on partial values True False
true
Information is processed data True False
true
It is possible for an entity to have a relationship to itself. True False
true
Standard SQL does not allow built in functions to be used in a WHERE clause True False
true
A relationship between the instances of a single entity type is called a ____ relationship Primary Ternary Binary Unary
unary
Which of the following is the correct SQL clause to restrict the results of a SELECT query to only records that have a value in the range of 10 to 50 in the Hours column? WHERE hours = 10 and hours = 50 WHERE hours between 10 and 50 WHERE hours = min(10) and max(50) WHERE Hours RANGE 10 to 50 WHERE Hours IN [10,50]
where hours between 10 and 50
By separating data into tables containing data on only one time each, making changes to the data is simplified.
True
E.F. Codd developed the relational model in the:
1970s
Which SQL keyword is used to eliminate duplicate rows in the results of an SQL select query? ORDER BY SORT DISTINCT UNIQUE REDUCE
DISTINCT
In the entity relationship data model, all instances of an entity of a given type are grouped into _____. Entity classes Class objects Entity attributes Identifiers Entity objects
Entity classes
Which SQL keyword can be used in conjunction wildcards to select partial values? SUBSTRING FIND SELECT SEARCH LIKE
LIKE
A database is an organized collection of ____ related data
Logically
A property or characteristic of an entity type that is of interest to the organization is called a(n) Relationship Cross function Attribute Coexisting entity
attribute
A _____ defines or constrains some aspect of the business.
business rule
Which of the following is NOT an advantage of database systems? a.Reduced program maintenance b.Better data quality c.Redundant data d.Program data independence
c. Redundant Data
Languages, menus, and other facilities by which users interact with the database are collectively called a(n): a. client b. development environment c. user interface d. icon
c. user interface
A ____ specifies the number of instances of one entity that can be associated with each instance of another entity Limit Degree Cardinality constraint Counter constraint
cardinality constraint
A rule that CANNOT be violated by database users is called a: Password View Constraint Program
constraint
A key that contains more than one attribute is called a(n) _____. a.Multi~key b.Complex key c.Multivalued key d.Composite key e.Candidate key
d. composite key
A graphical system used to capture the nature and relationships among data is called a(n): RAD Data model XML data model SDLC
data model
Which organizational function should set database standards? Database administration Management Technical services Application development
database administration
Microsoft SQL server is an example of a _____. Table Database Database management system List manager
database management system