GMU MIS Review

During the normalization process, the remedy for a relation that is not well formed is to:

Break it into two or more relations that are well formed

Microsoft Access 2019 database files are stored using the file extension

.accdb

A candidate key is

A candidate to become the primary key

Which of the following is not true about a relation?

A relation may have duplicate column names.

Which of the following is known to be true?

A single instance if ENTITY B may be related to many instances of ENTITY A.

Which of the following is the correct technique for representing a N:M relationship using the relational model?

An intersection relation is created, and the keys of both parent entities are placed as a composite key in the intersection relation.

What relationship pattern is illustrated in the following schema? PRODUCT(ProductID, Description) SUPPLIER(SupplierID, ContactName, PhoneNumber) PRODUCT_SUPPLIER (ProductID, SupplierID, Cost)

Association relationship

Conditions after the WHERE keyword require single quotes around the values for columns that have which data type?

Char

INSERT INTO VALUES requires single quotes around the values for columns that have which data type?

Char

Each attribute of an entity becomes a(n) ________ of a table.

Column

The creation of a database and its tables is a function of which component of the database system?

DBMS

Which of the following is NOT true:

Data marts typically have more subjects of analysis than data warehouses

In the entity-relationship data model, all instances of an entity of a given type are group into:

Entity Classes

Given the table STUDENT(StudentID, Name, AdvisorID) ADVISOR(AdvisorID, AdvisorName, Office, Phone, ) Which of the following SQL statements would be used to implant a join between the two tables?

FROM STUDENT JOIN ADVISOR ON STUDENT.AdvisorID = ADVISOR.AdvisorID

Given the tables STUDENT(StudentID, StudentName, AdvisorID) ADVISOR(AdvisorID, AdvisorName, Office, Phone) which of the following SQL statements would be used to implant a join between the two tables?

FROM STUDENT JOIN ADVISOR ON STUDENT.AdvisorID=ADVISOR.AdvisorID

Star schemas have a ________ at the center of the star.

Face Table

________ contain measures related to the subject of analysis.

Fact tables

A table that meets the requirements of a relation is said to be in which normal form?

First normal form

When the primary key of one relation is placed into a second relation, it is called a:

Foreign key

Homework and Exams are Due on:

Friday

Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements would be used to change the value of the Advisor field to 'Smith' for all rows in the STUDENT table?

INSERT INTO STUDENT VALUES (123, 'Jones','Smith');

The first step of the normalization process is to

Identify all of the candidate keys of a relation

In SQL Server, the starting value of a surrogate key is called the

Identity Seed

Which of the following is not true of the five SQL Built-in Functions?

MODE

Given the below functional dependency, MedicineCode → (MedicineName, ShelfLife, Manufacturer, Dosage) which of the following statements is not known to be true?

MedicineName is a determinant

Operational queries are typically issued:

More often than analytical queries

Which of the following is not true about null values?

Null values cannot be avoided.

Which of the following data types used in SQL would define a numeric field of the pattern 99.99?

Numeric (4,2)

A Business Intelligence (BI) reporting system that uses extensions to SQL is

OLAP

which of the following terms is synonymous with "tuple"?

Row

Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance), what is the standard SQL query phrase to retrieve the Name and Phone Number of customers?

SELECT Name, PhoneNum

The statement: SELECT STUDENT.StudentNumber, STUDENT.StudentName, FROM STUDENT WHERE STUDENT.StudentNumber = S12345678; is an example of:

SQL

What is the name of your professor?

Samer

Operational queries typically process:

Smaller amounts of data than analytical queries

In a typical properly-designed star schema, the number of records/rows in any of the dimension tables is:

Smaller than in the fact table

SQL stands for

Structured Query Language

An example of an entity is

Student Parking

An example of an attribute is:

StudentLastName ParkingPermitNumber

which of the following terms is synonymous with "relation"?

Table

Which of the following is not a standard data type used in SQL?

Text

A surrogate key may be appropriate under which of the following circumstances?

The available candidate keys would be prone to typographical errors.

Which of the following is true when representing a 1:1 binary relationship using the relational model?

The key of either entity is placed in the other as a foreign key.

Which of the following is the correct technique for representing a 1:N relationship model?

The key of the entity on the one side is placed into the relation for the entity on the many side.

In the normalization process, if you find that every determinant in a relation is a candidate key then you have determined that:

The relation is well formed

Which of the following is not true of surrogate keys

They are meaningful to the users.

Data time-horizon is:

Typically, shorter in operational systems than in analytical systems

In crow's foot style E-R diagrams, a crow's foot mark on the relationship line near an entity indicates:

a maximum cardinality of many

In crow's foot style E-R diagram, a crow's foot mark on the relationship line near an entity indicates

a minimum cardinality of optional

A rule that requires that the values in a foreign key must have a matching value in the primary key to which the foreign key corresponds is called:

a referential integrity constraint

A relational database is

a self-describing collection of related tables

A key that contains more than one attribute is called a(n):

composite key

a data mart differs from a data warehouse in these ways except:

data warehouses receive their data from the data marts

The number of entity classes involved in a relationship is known as the relationship's

degree

Data warehouses use a(n) _______

dimensional database

One important relational design principle is that

every determinant must be a candidate key.

In the normalization process it is not necessary to

identify all the foreign keys of a relation

The component of a database that makes it self-describing is the:

metadata

Whether or not an instance of one entity class must participate in a relationship with another entity class is indicated by the

minimum cardinality

Whether or not an instance of one entity class must participate in a relationship with another entity class is indicated by the_____

minimum cardinality

OLAP stands for ________.

online analytical processing

The Order of the columns returned by an SQL SELECT statement is determined by the _________

order they are listed in following SELECT

The dimensional schema is often referred to as the:

star schema

A relational database stores data in the form of

tables

The purpose of the source system is:

Both the original operational purposes and as a source system for the data warehouse

Which of the following can be defined using the constraint phrase in which SQL command?

Create Table

The first step in transforming an extended E-R model into a relational database design is to

Create a table for each entity

In a relational database design, all relationships are expressed by ______.

Creating a foreign key

The number of entity classes involved in a relationship is known as the relationship's____

Degree

Typically, in a star schema all ________ are given a simple, non-composite system-generated primary key, also called a surrogate key.

Dimension tables

Which SQL Keyword is used to eliminate Duplicate rows in the result of an SQL Select Query?

Distinct

Regarding Big Data what does the term NoSQL really mean?

Nonrelational Database

A relationship can be specified using:

Optional Mandatory

Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance) What is the standard SQL query phrase to retrieve the Name and Phone Number of customers?

SELECT Name, PhoneNum

Which SQL keyword is used to specify a condition that rows must meet to be included in the results of an SQL SELECT query?

WHERE

Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance), what is the standard SQL query to retrieve Data for Customers with an account balance greater than 50?

Where AcctBalance > 50

A primary key is

a candidate key

__________ contain descriptions of the business, organization, or enterprise to which the subject of analysis belongs.

Dimension tables

Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements would be used to add new student data to the STUDENT table?

INSERT INTO STUDENT VALUES (123, 'Jones', 'Smith');

which of the following is likely to be a user of a bank's data warehouse

Bank's CEO

In many-to-many relationship database design,

Both the keys of both tables are placed in a third table and the keys of both tables are joined into a composite key

Microsoft SQL serve is an example of

Database Management Systems

Which of the following cannot be done using the constraint Phrase

Define an attribute to be NOT NULL

A relationship is specified using:

One Many

Which of the following is not true about Primary Keys

Primary Keys must be a single attribute

Given the relation Student (SID,StudentName, Major, AdvisorID) Advisor(AdvisorID, AdvisorName, Office, Phone) Such that each student is assigned to one advisor which of the following is true?

AdvisorID is a foreign key

Which of the following is true about a relation?

All entries in any column must be of the same kind.

How should students contact the professor

Blackboard Messages

Operational queries are typically issued:

By more users than analytical queries

The identify of the entity becomes the _____ of the corresponding table

Primary key

A data warehouse database differs from an operational database because __________.

Data warehouse data are often stored in a dimensional database

Which of the following problems associated with storing data in a list is avoided by storing data in a relational database?

Duplicate of data items

Which of the following is not a basic component of a database system?

ERD

Which of the following data types used in SQL would define a fixed-length text field of 10 characters?

Char(10)

A Primary Key can be defined using the constraint phrase in which SQL command?

Create Table

Select all the correct answers (Multiple Answers):

Optional & Mandatory

Today almost every commercial database is based on:

the relational model