SQL Exam

In an E-R diagram, there are ________ business rule(s) for every relationship.

2

Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance.

80%

What entity type is sometimes called a Linking Table?

Associative Entry

What is another term for a simple attribute?

Atomic

Which of the following factors drive the need for data warehousing?

Businesses need an integrated view of company information

A ________ specifies the number of instances of one entity that can be associated with each instance of another entity.

Cardinality constraint

DCL (Data Control Language)

Controls the DB privileges

Which of the following is NOT a method for storing XML documents?

Convert to text

DDL (Data Definition Language)

Defines DB structure

The total quiz points for a student for an entire semester is a(n) ________ attribute.

Derived

A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship.

Many-to-many

A class of database technology used to store textual and other unstructured data is called:

NoSQL

When you are born, you are assigned a social security number. It belongs only to you and you have only one. What type of relationship exists between you and your social security number?

One-to-one

Some applicants may have reading challenges such as Dyslexia that require additional support from the learning environment. Other applicants may not.

Optional

What is it called when a record in one table does not require a corresponding record in another table?

Optional Relationship

Autonumber

PK

Composite PK

PKs that relate two or more tables

DML (Data Manipulation Language)

Queries the DB

An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called:

RAD

ORDER MATTERS in SQL

SELECT → FROM → WHERE → GROUP BY → HAVING → ORDER BY HAVING needs GROUP BY

If your school was dissolved in the college, you would still be considered a student and could continue your education here. What type of entity is a "student"?

Strong

Which type of entity cannot exist within a database if an entity that it is linked to is removed from that database?

Weak

A mutually exclusive relationship is one in which:

an entity instance can participate in only one of several alternative relationships.

Extensible Business Reporting Language (XBRL) is an example of:

an xml-based vocabulary

The SDLC phase in which every data attribute is defined, every category of data is listed and every business relationship between data entities is defined is called the ________ phase.

analysis

Web services:

are a set of emerging standards for protocols for automatic communication between software over the Web.

column

attribute

Which of the following is a component of processing logic?

business rules

Derived attributes

calculated within database

Which of the following data-mining techniques identifies clusters of observations with similar characteristics?

cluster and single processing

An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):

composite identifier

Conformance means that:

data are stored, exchanged or presented in a format that is specified by its metadata

The value a field will assume unless the user enters an explicit value for an instance of that field is called a

default value

Designing physical files requires ________ of where and when data are used in various ways.

description

Organizing the database in computer disk storage is done in the ________ phase.

design

In most cases the goal of ________ dominates the design process. Efficient data processing

efficient data processing

A database action that results from a transaction is called a(n):

event

The most common source of database failures in organizations is:

failure to implement a strong database administration function

A client PC that is responsible for processing presentation logic, extensive application and business rules logic as well as many DBMS functions is called a:

fat client

In a relational database, what is another term for an attribute?

field

A(n) ________ is a technique for physically arranging the records of a file on secondary storage devices.

file organizations

A dependent data mart:

is filled exclusively from the enterprise data warehouse with reconciled data

An index on columns from two or more tables that come from the same domain of values is called a:

join index

One disadvantage of file processing systems is:

limited data sharing

Validation rule

limiting values of a specific attribute

Input Mask

limiting values to specific format

A database is an organized collection of ________ related data.

logically

What type of attribute may take on more than one value for a given entity instance?

multivalued

The use of a set of graphical tools that provides users with multidimensional views of their data is called:

online analytical processing (OLAP).

In which data model would a code table appear?

physical

A Web server:

processes client requests and returns HTML pages to the client.

An integrity control supported by a DBMS is:

range control

row

record

Relational databases establish the relationships between entities by means of common fields included in a file called a(n):

relation

When you applied to the college, you were required to provide your name, social security, address, and phone. What type of attributes are these items?

required

Which type of file is most efficient with storage space?

sequential

The main difference between Java applets and Java servlets is:

servlets are stored on the server while applets are stored on the client.

Lookup

setting to limit values via pop-up box

cell

single data

A(n) ________ is a module of code written in SQL or some proprietary language to run business rules on a server

stored procedure

A value that indicates the date or time of a data value is called a:

time stamp

All of the following are concerns about developing a Web services approach EXCEPT:

user acceptability

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.

user view

A data warehouse derives its data from:

various operational databases