Basic component of a database system

Assignment Help Database Management System

Reference no: EM13774930

Question 1: A relational database stores data in the form of:

lists.

forms.

columns.

tables.

spreadsheets.

Question 2: SQL stands for:

Standard Query Language.

Structural Question Language.

Structured Query Language.

Standard Question Language.

Structured Question Language.

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

Database

User

ERD

DBMS

Data applications

Question 4: A relational database is:

a self-describing collection of related tables.

a collection of forms and reports that support a given purpose.

a library of queries and data files for querying.

a set of applications and the data sets for those applications.

a set of metadata.

Question 5: Which of the following terms is synonymous with "tuple"?

Attribute

Table

Field

Row

Relation

Question 6: Which of the following terms is synonymous with "relation"?

Attribute

Table

Record

Row

Question 7: A primary key is:

required to be unique.

used to represent rows in relationships.

a candidate key.

used to identify unique rows.

All of these

Question 8: A candidate key is:

required to be unique.

used to represent rows in relationships.

a candidate to be the primary key.

Both required to be unique and used to represent rows in relationships

Both required to be unique and a candidate to be the primary key

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

field key.

referential integrity.

foreign key.

candidate key.

relocated key.

Question 10: STUDENT (SID, StudentName, Major, AdvisorID)ADVISOR (AdvisorID, AdvisorName, Ofce, Phone)Given the relations above such that each student is assigned to one advisor, which of the following is true?

SID is both a primary key and a foreign key.

AdvisorName is a determinant.

AdvisorID is a foreign key.

Phone is a candidate key.

Major is a candidate key.

Question 11: One important relational design principle is that:

every determinant must be a candidate key.

every candidate key must not be a determinant.

every primary key must be a surrogate key.

every determinant must be functionally dependent on the primary key.

every primary key must be functionally dependent on every determinant.

Question 12: The first step of the normalization process is to:

identify all the candidate keys of a relation.

identify all the foreign keys of a relation.

identify all the functional dependencies of a relation.

identify all the determinants of a relation.

split the relation into two or more new relations.

Question 13: Which of the following is not true about primary keys?

Primary keys cannot be null.

Primary keys must be unique.

Primary keys must be a single attribute.

Primary keys are used to represent relationships.

Primary keys can be defined using a SQL CONSTRAINT phrase

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

SELECT

FROM

WHERE

ORDER BY

GROUP BY

Question 15: 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 CUSTOMER-Name AND CUSTOMER-PhoneNum

SELECT (CUSTOMER-Name AND CUSTOMER-PhoneNum)

SELECT Name, PhoneNum

SELECT (Name, PhoneNum)

SELECT *

Question 16: Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance), what is the standard SQL query phrase to retrieve data for customers with an account balance greater than 50?

WHERE CUSTOMER-AcctBalance > 50

WHERE (CUSTOMER-AcctBalance > 50)

WHERE AcctBalance > 50

WHERE (AcctBalance > 50)

HAVING AcctBalance > 50

Question 17: Which of the following SQL commands would be used to remove only the data from a table named STUDENT while leaving the table structure intact?

DROP TABLE STUDENT;

DELETE TABLE STUDENT;

REMOVE TABLE STUDENT;

SELECT * FROM STUDENT THEN DROP;

DELETE FROM STUDENT;

Question 18: Which of the following SQL commands would be used to remove both the data and the table structure of a table named STUDENT?

DROP TABLE STUDENT;

DELETE TABLE STUDENT;

REMOVE TABLE STUDENT;

SELECT * FROM STUDENT THEN DROP;

DELETE FROM STUDENT;

Question 19: A dashed line between entities indicates:

a unique identifier.

a minimum cardinality of zero.

a minimum cardinality of one.

an identifying relationship.

a nonidentifying relationship.

Question 20: In crow's foot style E-R diagrams, a circle across the relationship line near an entity indicates:

a minimum cardinality of zero.

a minimum cardinality of one.

a maximum cardinality of one.

a maximum cardinality of many.

Both a minimum cardinality of one and a maximum cardinality of one

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

a minimum cardinality of zero.

a minimum cardinality of one.

a maximum cardinality of one.

a maximum cardinality of many.

Both a minimum cardinality of one and a maximum cardinality of one

Question 22: Which of the following would be a reason to denormalize a relation?

Relax security

Lack of design time

End user preference

Improve performance

None of these

Question 23: Which of the following is true about representing a weak entity with the relational model?

If the weak entity is existence-dependent, the key of the parent must be part of the key of the weak entity.

If the strong entity has a minimum cardinality of 1, the key of the weak entity must be part of the strong entity.

If the weak entity is ID-dependent, the key of the weak entity must be part of the key of the parent entity.

If the weak entity is ID-dependent, the key of the parent entity must be part of the key of the weak entity.

If the parent entity is existence-dependent, then the minimum cardinality of the weak entity is zero.

Question 24: Which normal form was developed in order to eliminate multivalued dependencies?

3NF

BCNF

4NF

5NF

DK/NF

Question 25: The fundamental rule of normalization can be stated as:

every table must meet the definition of a relation.

every determinant must be a candidate key.

every domain must be logical consequence of the constraints.

every key must be a candidate key.

every constraint must be a determinant.

Question 26: Given the generic relation: GENERIC (PKey1, PKey2, Attribute1, Attribute2, Attribute3), and the functional dependencies: (PKey1, PKey2) → Attribute1 and PKey2 → (Attribute2, Attribute3), which of the following is true?

GENERIC is not fully normalized.

PKey1 is a determinant.

PKey2 is a candidate key.

GENERIC is in DK/NF.

All of these

Question 27: Given TABLE_A (Attribute1, Attribute2, Attribute3) and TABLE_B (Attribute4, Attribute5, Attribute6) shown in the figure below, which of the following would display the correct placement of foreign keys in the relational model?

TABLE_A (Attribute1, Attribute2, Attribute3)TABLE _B (Attribute4, Attribute5, Attribute6, Attribute1)

TABLE _A (Attribute1, Attribute2, Attribute3, Attribute4, Attribute5)TABLE _B (Attribute4, Attribute5, Attribute6)

TABLE _A (Attribute1, Attribute2, Attribute3, Attribute4)TABLE _B (Attribute4, Attribute5, Attribute6, Attribute1)

TABLE _A (Attribute1, Attribute2, Attribute3)TABLE _B (Attribute4, Attribute5, Attribute6)

TABLE _A (Attribute1, Attribute2, Attribute3, Attribute6)TABLE _B (Attribute4, Attribute5, Attribute6)

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

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

The key of the child is placed into the relation of the parent.

The key of either relation can be placed into the other relation.

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

An intersection relation is created and the keys from both parent entities are placed as keys in the intersection relation.

Question 29: Given the entities PRODUCT and SUPPLIER shown in the figure below, which of the following would represent the correct placement of foreign keys?

PRODUCT (ProductID, Description, Cost)SUPPLIER (SupplierID, ContactName, PhoneNumber)

PRODUCT (ProductID, Description, Cost)SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductID)

PRODUCT (ProductID, Description, Cost, SupplierID)SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductID)

PRODUCT (ProductID, Description, Cost, ContactName)SUPPLIER (SupplierID, ContactName, PhoneNumber)

PRODUCT (ProductID, Description, Cost, SupplierID)SUPPLIER (SupplierID, ContactName, PhoneNumber)

Question 30: Given the PRODUCT and SUPPLIER entities in the figure below, which of the following would represent the correct placement of foreign keys?

PRODUCT (ProductID, Description, Cost)SUPPLIER (SupplierID, ContactName, PhoneNumber)

PRODUCT (ProductID, Description, Cost, SupplierID)SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductID)

PRODUCT (ProductID, Description, Cost)SUPPLIER (SupplierID, ContactName, PhoneNumber)PRODUCT_SUPPLIER (ProductID, SupplierID)

PRODUCT (ProductID, Description, Cost, SupplierID)SUPPLIER (SupplierID, ContactName, PhoneNumber)

PRODUCT (ProductID, Description, Cost)SUPPLIER (SupplierID, ContactName, PhoneNumber)PRODUCT_SUPPLIER (ProductID, SupplierID

Question 31: What relationship pattern is illustrated in the following schema?

VEHICLE (VehicleID, Cost)

CAR (VehicleID, NumberOfSeats)

TRUCK(VehicleID, CargoCapacity)

VehicleID in CAR must exist in VehicleID in VEHICLE

VehicleID in TRUCK must exist in VehicleID in VEHICLE

Association relationship

Intersection relationship

Recursive relationship

Strong entity relationship

Supertype/subtype relationship

Question 32: The purpose of concurrency control is to:

ensure that each form has a corresponding report.

ensure that ASPs do not duplicate JSPs.

ensure that one user's work does not interfere with another's.

ensure that stored procedures do not invoke triggers.

ensure that triggers do not invoke stored procedures.

Question 33: When a transaction functions in such a way that either all of the transaction actions are completed or none of them will be, the transaction is said to be:

consistent.

isolated.

atomic.

locked.

logical.

Question 34: What concurrent processing problem occurs when a transaction reads a changed record that has not been committed to the database?

Nonrepeatable reads

Phantom reads

Dirty reads

Serialized reads

Unlocked reads

Question 35: Preventing multiple applications from obtaining copies of the same record when the record is about to changed is called:

serialized reading.

lost updating.

concurrent processing.

resource locking.

block factoring.

Question 36: Which of the following is not true of database recovery through reprocessing?

Reprocessing makes use of a database save.

Reprocessing takes the same amount of time as did processing in the first place.

Reprocessing will always return the database to its exact previous state.

Reprocessing requires a record of all transactions since the last time the database was saved.

All of these are true of reprocessing.

Question 37: ODBC stands for:

Open Database Compatibility.

Open Database Connectivity.

Open-source Database Compatibility.

Open-source Database Connectivity.

None of these

Question 38: If the computer hosting the Web server is running a Unix or Linux operating system, the Web server is probably:

Apache.

Tomcat.

Internet Information Server (IIS).

Internet Interpreter Server (IIS).

Information Interpreter Server (IIS).

Question 39: In PHP, any programming language statements that are to be processed on the server must be enclosed in:

<!-- and --!>.

[php and php].

(php and php).

<?php and ?>.

<server> and </server>.

Question 40: The final step of using a PHP connection to a DBMS is to open the connection.

test the connection.

query the database.

process the query results.

close the connection.

Question 41: XML document s can be ________ against their XML Schema.

measured

grown

validated

browsed

All of these

Question 42: XML Schemas consist of ________.

elements

attributes

properties

Both elements and attributes

All of these

Question 43: When working with Microsoft Access on a Windows operating system, a simple but usable ASCII text editor is:

Microsoft Word.

Notepad.

Wordpad.

Microsoft Frontpage.

Microsoft Visual Studio .NET.

Question 44: Business Intelligence (BI) systems do which of the following?

Analyze current and past activities

Predict future events

Record and process transactions

Both Analyze current and past activities and Predict future events

All of these

Question 45: Data mining applications are used accomplish which of the following tasks?

Perform what-if analysis

Make predications

Facilitate decision making

Both Perform what-if analysis and Make predications

All of these

Question 46: We have obtained access to the company's operational data. In one record, we find that a customer's age has been recorded as "337". This is an example of:

dirty data.

inconsistent data.

non-integrated data.

a "wrong format" problem.

a "too much data" problem.

Question 47: We have obtained access to the company's operational data. We examine 50 records for customers with phone numbers that should use the current area code of 345. Of these 50 records, we find 10 that still use an older area code of 567. This is an example of:

dirty data.

inconsistent data.

non-integrated data.

a "wrong format" problem.

a "too much data" problem.

Question 48: A data mart difers from a data warehouse in that:

it has a smaller database.

it deals with a particular component or functional area of the business.

data mart users do not have the data management expertise of data warehouse employees.

Both it has a smaller database and it deals with a particular component or functional area of the business

All of these

Question 49: OLAP stands for:

OnLine Analytical Processing.

OfLine Analytical Processing.

OnLine Analysis Process.

OfLine Analytical Processing.

Lazy, Old And Particular.

Question 50: Data mining techniques are used to find patterns and relationships that can be used to:

report.

classify.

predict.

Both classify and predict

All of these.

Reference no: EM13774930

Questions Cloud

How well do you protect your safety : How Well Do You Protect Your Safety - Are You an Environmentalist?

What is the probability of finding the electron : What is the position of the innermost radial node? Give your answer in terms of the nuclear charge Z and the Bohr radius ao and What is the probability of finding the electron

Explain the significance of the selected category : Select one (1) category from the completed World View Chart. Provide a rationale for choosing this category. Describe the selected content and explain the significance of the selected category across the religions studied.

What was your first reaction to the results : What was your first reaction to the results; your career interest and work values assessment? Do the descriptions seem accurate for you? Why or why not?

Basic component of a database system : Which of the following is not a basic component of a database system? Which of the following terms is synonymous with "tuple"

Leadership theory that a public leader could apply : From the weekly readings and first e-Activity, recommend a distributive, servant, or other leadership theory that a public leader could apply in order to resolve conflicts and implement change while working with external stakeholders.

Marketing strategies and subcultures paper : Write a 1,050-word paper on marketing strategies and subcultures. In this week, you research subcultures to determine what marketing strategies you would use to market flavored cigarettes to the target market group. Address the following in your p..

Studying various media outlets : You have been studying various media outlets. Among other things, you have been looking for bias in media outlets. Write 2 pages or more on the results of your discussion and studies.

Write a research paper based on integrating research : Write and submit a research paper based on "Integrating Research". For this assignment, you are required to submit your Works Cited list by the assigned date to the course's reference librarian for review using NoodleTools.

User Account

All Pages