Final Prep Multiple Choice CIST1220-Structured Query Language-SQL

If the results of a SELECT statement include more than one column of data, the column names must be separated in the SELECT clause by which of the following symbols? A) , B) " " C) ' ' D) *

A) ,

Which of the following operators can be used to combine search conditions? A) AND B) = C) IS NOT NULL D) none of the above

A) AND

If you want to create a view based upon a table or tables that do not yet exist, or are currently unavailable (e.g.,off-line), what keyword can you use to avoid receiving an error message? A) FORCE B) NOERROR C) OVERRIDE D) none of the above

A) FORCE

Based upon the contents of the CUSTOMERS table, which of the following will display the shipping location as: City, State Zip A) SELECT INITCAP(CONCAT(city, CONCAT(', ', CONCAT(state, CONCAT(' ', zip))))) FROM customers; B) SELECT CONCAT(city, CONCAT(', ', CONCAT(state, CONCAT(' ', CONCAT(zip))))) FROM customers; C) SELECT INITCAP(CONCAT(city, ', ', state, ' ', zip)) FROM customers; D) none of the above

A) SELECT INITCAP(CONCAT(city, CONCAT(', ', CONCAT(state, CONCAT(' ', zip))))) FROM customers;

A positive number is used in the ROUND function to indicate that numeric data should be rounded to the indicated position to the right of the decimal point. A) True B) False

A) True

A(n) correlated subquery references one or more columns from the outer query. A) True B) False

A) True

Retrieving only specific rows from a table is a process known as selection. A) True B) False

A) True

SELECT *FROM employees;This statement will retrieve all the rows in the employees table. True or False? A) True B) False

A) True

The HAVING clause specifies which groups will be displayed in the results, while the WHERE clause restricts the records that are retrieved from the table for processing. A) True B) False

A) True

The MAX function can be used with character data. A) True B) False

A) True

The NATURAL JOIN keywords can be used to link two tables that have a commonly named and defined column. A) True B) False

A) True

The TO_CHAR function can be used to add a dollar sign ($) to a numeric value. A) True B) False

A) True

The WITH READ ONLY option can be used to prevent changes from being made to the data displayed by the view. A) True B) False

A) True

The optional keyword AS can be used to indicate that the subsequent string of characters is a column alias. A) True B) False

A) True

You can include multiple subqueries in a SELECT statement. A) True B) False

A) True

A(n) ____ clause cannot include a group function. A) WHERE B) HAVING C) SELECT D) both a and c

A) WHERE

Based upon the contents of the CUSTOMERS table, which of the following would be the most appropriate use of a subquery? A) When searching for all customers who live in the same state as customer# 1007. B) When searching for all customers who were referred by customer# 1003. C) When searching for all customers with the last name of Thompson. D) When searching for all customers assigned customer# 1010.

A) When searching for all customers who live in the same state as customer# 1007.

A(n) ____ is used to indicate how data should relate to a given search condition. A) comparison operator B) logical operator C) search pattern D) criteria

A) comparison operator

In an E-R Model a person, place, or thing with characteristics to be stored in the database are referred to as? A) entity B) row C) attribute D) file

A) entity

A(n) ____ has a predefined meaning in Oracle11g. A) keyword B) statement C) syntax D) clause

A) keyword

The SUM function can only be used with ____ data. A) numeric B) character C) date D) alphanumeric

A) numeric

Which type of view is created with the following command? CREATE VIEW OR REPLACE outstanding AS SELECT customer#, order#, orderdate, shipdate FROM orders WHERE shipdate IS NULL WITH READ ONLY; A) simple B) complex C) derived D) inline

A) simple

Which of the following types of views cannot include a group function? A) simple view B) inline view C) complex view D) all of the above

A) simple view

A(n) ____ stores a query and is used to access data in the underlying tables. A) view B) constraint C) function D) argument

A) view

A NATURAL JOIN is based on: A) Columns with the same name B) Columns with the same name and datatype C) olumns with the same datatype and width D) Tables with the same structure

B) Columns with the same name and datatype

A column qualifier indicates the column containing the data being referenced. A) True B) False

B) False

A multiple-column subquery cannot be nested in a WHERE clause. A) True B) False

B) False

A multiple-column subquery nested in the SELECT clause of the outer query is known as an inline view. A) True B) False

B) False

A single-row subquery can return several columns, but only one row, of results to the outer query. A) True B) False

B) False

A(n) Cartesian Join replicates each row from the first table with every row from the second table. A) True B) False

B) False

A(n) outer join can be created by not including a joining condition in a SELECT statement. A) True B) False

B) False

A(n) uncorrelated subquery is when the outer query is executed first, then the inner query is executed. A) True B) False

B) False

An ORDER BY clause can reference a column to be used for sorting based upon its position in the database table. A) True B) False

B) False

An outer join operator consists of a minus sign enclosed in parentheses, (-). A) True B) False

B) False

Each section of a SQL command that begins with a keyword is known as a statement. A) True B) False

B) False

Insignificant zeros are displayed for numeric columns by default to show two decimal places. A) True B) False

B) False

Search conditions for data contained in non-numeric columns must be enclosed in double quotation marks. A) True B) False

B) False

The ALL option can be used in the SELECT clause to indicate that all columns should be retrieved. A) True B) False

B) False

The DIST or UNIQ keywords can be used to suppress duplicate data in the results of a SELECT statement. A) True B) False

B) False

The LTRIM function can be used to remove a specific number of characters from the left side of a set of data. A) True B) False

B) False

The NATURAL JOIN keywords can be used to create non-equality joins. A) True B) False

B) False

The ORDER BY clause is used to group data. A) True B) False

B) False

The SELECT clause of the SELECT statement is used to identify which rows are to be retrieved from a specified table. A) True B) False

B) False

The SOUND function is used to determine the phonetic representation of a character string. A) True B) False

B) False

When a multiple-column subquery is used in the WHERE clause of the outer query, the column names listed on the left side of the comparison operator must be enclosed in double-quotation marks. A) True B) False

B) False

Which of the following functions is used to determine the number of months between two date values? A) MONTH_BETWEEN B) MONTHS_BETWEEN C) MTH_BETWEEN D) MNTH_BETWEEN

B) MONTHS_BETWEEN

Which of the following can be used to replace a specific set of characters with another set of characters? A) SUBSTR B) REPLACE C) FNDRPLCE D) none of the above

B) REPLACE

Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will display all books stored in the BOOKS table that generate more than 60 percent profit? A) SELECT * FROM books WHERE profit > .6; B) SELECT * FROM books WHERE (retail-cost)/cost > .60; C) SELECT * FROM books WHERE (retail-cost)/cost > 60%; D) SELECT * FROM books WHERE (retail-cost)/cost > '60';

B) SELECT * FROM books WHERE (retail-cost)/cost > .60;

Which of the following SQL statements will display the title of the books ordered by customer# 1003? A) SELECT title FROM customers NATURAL JOIN books WHERE customer# = 1003; B) SELECT title FROM customers JOIN orders USING (customer#) JOIN orderitems USING (order#) JOIN books USING (isbn) WHERE customer# = 1003; C) SELECT title FROM customers JOIN orders ON (customer#) JOIN orderitems ON (order#) JOIN books ON (isbn) WHERE customer# = 1003; D) both a and b

B) SELECT title FROM customers JOIN orders USING (customer#) JOIN orderitems USING (order#) JOIN books USING (isbn) WHERE customer# = 1003;

Analyzing historical sales data stored in a database is commonly referred to as ____. A) data storage B) data mining C) data manipulation D) archived data

B) data mining

In which of the following examples is the ORDERS table used as a column qualifier? A) o.order# B) orders.order# C) order#.o D) order#.orders

B) orders.order#

A complete query nested inside another query is called a(n) ____. A) inner view B) subquery C) child view D) all of the above

B) subquery

Which of the following statements about complex views is incorrect? A) It is created with the same CREATE VIEW command as a simple view. B) It retrieves or derives data from one or more tables. C) All DML operations can be performed on complex views, just like simple views. D) It may contain functions or grouped data.

C) All DML operations can be performed on complex views, just like simple views.

Which of the following is true? A) Character values are not case-sensitive B) Character strings must be enclosed in double quotation marks C) Date values are enclosed in single quotation marks D) Date values are not format-sensitive

C) Date values are enclosed in single quotation marks

Which of the following is a valid SQL statement based upon the contents of the CUSTOMERS table? A) SELECT INITCAP(firstname, lastname) FROM customers; B) SELECT LENGTH (city, state, zip) FROM customers; C) SELECT customer#, NVL2(referred, 'Referred', 'Not Referred') FROM customers; D) SELECT INITCAP((firstname),( lastname)) FROM customers; Note: The ST column name is truncated, this represents the STATE column.

C) SELECT customer#, NVL2(referred, 'Referred', 'Not Referred') FROM customers;

Which of the following SQL statements will display the gift that should be sent to any customer who orders the book titled SHORTEST POEMS? A) SELECT gift FROM promotion WHERE gift = minretail; B) SELECT gift FROM promotion, books WHERE retail >= minretail AND title = 'SHORTEST POEMS'; C) SELECT gift FROM promotion, books WHERE retail BETWEEN minretail AND maxretail AND title = 'SHORTEST POEMS'; D) none of the above

C) SELECT gift FROM promotion, books WHERE retail BETWEEN minretail AND maxretail AND title = 'SHORTEST POEMS';

Which statement will return a listing of last names, salaries, and a rating of 'Low', 'Medium', 'Good' or 'Excellent' depending on the salary value? A) SELECT last_name,salary, (CASE WHEN salary<5000 THEN 'Low' WHEN sal <10000 THEN 'Medium' WHEN sal <20000 THEN 'Good' ELSE 'Excellent' END) qualified_salary FROM employees; B) SELECT last_name,salary, (RATING WHEN salary<5000 THEN 'Low' WHEN salary<10000 THEN 'Medium' WHEN salary<20000 THEN 'Good' ELSE 'Excellent' END) qualified_salary FROM employees; C) SELECT last_name,salary, (CASE WHEN salary<5000 THEN 'Low' WHEN salary<10000 THEN 'Medium' WHEN salary<20000 THEN 'Good' ELSE 'Excellent' END) qualified_salary FROM employees; D) SELECT last_name,sal, (CASE WHEN sal<5000 THEN 'Low' WHEN sal<10000 THEN 'Medium' WHEN sal<20000 THEN 'Good' ELSE 'Excellent' END) qualified_salary FROM employees;

C) SELECT last_name,salary, (CASE WHEN salary<5000 THEN 'Low' WHEN salary<10000 THEN 'Medium' WHEN salary<20000 THEN 'Good' ELSE 'Excellent' END) qualified_salary FROM employees;

Which of the following will display the new retail price of each book as 20 percent more than it originally cost? A) SELECT title, cost+.20 "New Retail Price" FROM books; B) SELECT title, cost*.20 "New Retail Price" FROM books; C) SELECT title, cost*1.20 "New Retail Price" FROM books; D) none of the above

C) SELECT title, cost*1.20 "New Retail Price" FROM books;

The ____ function calculates the standard deviation for a specific set of data. A) STDDEVIATION B) STD C) STDDEV D) STANDARDDEV

C) STDDEV

If a SELECT statement contains HAVING, GROUP BY, and WHERE clauses, the ____ clause will be processed first. A) HAVING B) GROUP BY C) WHERE D) ORDER BY

C) WHERE

Which constraint ensures that the data in a view cannot be changed? A) WITH CHECK OPTION B) WITH READ OPTION C) WITH READ ONLY D) NO WRITE OPTION

C) WITH READ ONLY

What is the procedure for assigning new names for the columns that are displayed by a view? A) The new column names can be listed after the VIEW keyword, enclosed in parentheses. B) Column aliases can be used in the subquery, and Oracle11g will use the aliases as column names in the view that is created. C) all of the above D) none of the above

C) all of the above

A(n) ____ subquery is one that can return several rows of results. A) correlated B) single-row C) multiple-row D) uncorrelated

C) multiple-row

Which statement about the view created from the following SQL command is correct, assuming ISBN from the BOOKS table is the primary key used by the view? CREATE OR REPLACE VIEW prices AS SELECT isbn, title, cost, retail, retail-cost profit, name FROM books NATURAL JOIN publisher; A) DML operations can only be performed on the columns belonging to the PUBLISHER table. B) No DML operations are allowed. C) DML operations are allowed on both the BOOKS and PUBLISHER tables. D) DML operations can only be performed on the columns belonging to the BOOKS table.

D) DML operations can only be performed on the columns belonging to the BOOKS table.

Based upon the contents of the ORDERS table, which of the following SQL statements will display only those orders shipped to the zip code zone that begins with 323? A) SELECT order#, SUBSTR(shipzip, 1, 323) FROM orders; B) SELECT order#, SUBSTR(shipzip, 1, 323) FROM orders WHERE shipzip = 323; C) SELECT order# FROM orders WHERE shipzip = SUBSTR(shipzip, 1, 323); D) SELECT order# FROM orders WHERE SUBSTR(shipzip, 1, 3) = 323;

D) SELECT order# FROM orders WHERE SUBSTR(shipzip, 1, 3) = 323;

Functions that return one result per group of rows are called ____ functions. A) group B) multiple-row C) aggregate D) all of the above

D) all of the above

Which of the following is a valid comparison operator? A) != B) IN C) ^= D) all of the above

D) all of the above

Which of the following is a valid statement? A) A single-row function can be nested inside a group function. B) Group functions can be nested inside other group functions. C) Group functions can be nested inside single-row functions. D) all of the above

D) all of the above

Which statement is true about the view created with the following command? CREATE VIEW OR REPLACE outstanding AS SELECT customer#, order#, orderdate, shipdate FROM orders WHERE shipdate IS NULL WITH READ ONLY; A) The order# of an order cannot be changed through the view. B) The shipping date of an order cannot be changed through the view. C) No DML operations are permitted through the view. D) all of the above

D) all of the above

A group function can be nested inside a(n)____. A) group function B) single-row function C) order function D) both a and b

D) both a and b

The order in which NULL values appear in the results can be overridden by which of the following keywords? A) NULLS FIRST B) NULLS LAST C) NSEQ D) both a and b

D) both a and b

Which of the following are examples of comparison operators used in the WHERE clause? A) =, >, <, <=, >=, <> B) between ___ and ___ C) in (..,..,.. ) D) like E) is null F) All of the above

F) All of the above

When you add the concept of time to your data model, you are: A) Adding complexity to your model. B) Just changing the model, but this does not change the complexity of it. C) Simplifying your model. D) None of these answers.

A) Adding complexity to your model.

Which of the following is an example of a structural business rule? A) All employees must belong to at least one department B) All overdue payments will have an added 10 % late fee C) All products will have a selling price no less than 30 % greater than wholesale D) Buildings to be purchased by the business must be current with earthquake building code

A) All employees must belong to at least one department

What is the rule of Second Normal Form? A) All non-UID attributes must be dependent upon the entire UID. B) Some non-UID attributes can be dependent on the entire UID. C) No non-UID attributes can be dependent on any part of the UID. D) None of the above

A) All non-UID attributes must be dependent upon the entire UID.

What is the function of logging or journaling in conceptual data models? A) Allows you to track the history of attribute values, relationships, and/or entire entities B) Creates a fixed time for all events in a data model. C) Represents entities as time in the data model. D) Gives a timestamp to all entities.

A) Allows you to track the history of attribute values, relationships, and/or entire entities

Which of the following represents the correct sequence of steps in the Database Development Process? A) Analyze, Design, Build B) Build, Analyze, Design C) Design, Build, Analyze D) Analyze, Build, Design

A) Analyze, Design, Build

Many to many relationships between entities usually hide what? Mark for Review A) Another entity B) Another relationship C) Uniqueness D) More attributes

A) Another entity

In a physical data model, a relationship is represented as a: A) Foreign Key B) Unique Identifier C) Column D) Primary Key

A) Foreign Key

What do you create when you transform a Many-to-Many relationship from your ER diagram into a physical design? A) Intersection table B) Foreign key constraints C) Intersection entity D) Primary key constraints

A) Intersection table

How do you know when to use the different types of time in your design? A) It depends on the functional needs of the system. B) The rules are fixed and should be followed. C) Always model time; you can take it out later if it is not needed. D) You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.

A) It depends on the functional needs of the system.

Foreign keys cannot be null when A) It is part of a primary key B) It refers to another table C) It contains three or more columns

A) It is part of a primary key

What uncommon relationship is described by the statements: "Each LINE must consist of many POINTS and each POINT must be a part of many LINES" A) Many to Many Mandatory B) One to Many Optional C) One to Many Mandatory D) Many to Many Optional

A) Many to Many Mandatory

Which of the following would best be represented by an arc? A) STUDENT ( University, Trade School) B) STUDENT (graduating, non-graduating) C) STUDENT (senior, junior) D) STUDENT (will-attend-university, will-not-attend-university)

A) STUDENT ( University, Trade School)

Business rules are important to data modelers because: A) They capture all of the needs, processes, and required functionality of the business B) They are easily implemented in the ERD diagram C) The data modeler must focus on structural rules, because they are easily represented diagrammatically and eliminate other rules that involve extra procedures or programming D) Both A and C are true

A) They capture all of the needs, processes, and required functionality of the business

A column represents a field in the physical database table. A) True B) False

A) True

A recursive relationship should not be part of a UID. True or False?

A) True

A table does not have to have a primary key. True or False?

A) True

All attributes that are part of the UID are mandatory. True or False?

A) True

All attributes that are part of the UID are mandatory. True or False? A) True B) False

A) True

All instances of a subtype must be an instance of the supertype. True or False?

A) True

All instances of the supertype are also instances of one of the subtypes. True or False

A) True

As a database designer, you have a responsibility to store data in only one place and in the best possible place. True or False?

A) True

If subtypes are listed, a supertype should have at least two subtypes. True or False? A) True B) False

A) True

In an ERD, it is a good idea to group your entities according to the expected volumes. By grouping high volume entities together, the diagrams could become easier to read. True or False?

A) True

In the grid computing model, resources are pooled together for efficiency. True or False? A) True B) False

A) True

Modeling historical data can produce a unique identifier that includes a date. True or False? A) True B) False

A) True

Oracle was one of the first relational database systems available commercially. True or False? A) True B) False

A) True

Relationships can be either mandatory or optional. True or False?

A) True

SELECT *FROM employees;This statement will retrieve all the rows in the employees table. True or False?

A) True

The demand for Information Technology professionals in today's market is increasing. A) True B) False

A) True

The simplest approach to remove a partial dependency is to use each portion of the primary key to create separate tables. A) True B) False

A) True

Two entities can have one or more relationships between them. True or False?

A) True

Two tables can be linked or joined together through a common field. A) True B) False

A) True

A field in the logical design of a database is represented by what in the physical database? A) column B) row C) field D) row

A) column

Which of the following is a logical constraint that could result from considering how time impacts the storage of data? A) End Date must be before the Start Date. B) An ASSIGNMENT may only refer to a COUNTRY that is valid at the Start Date of the ASSIGNMENT. C) Dates have value only with a time component. D) ASSIGNMENT periods can overlap causing the database to crash.

B) An ASSIGNMENT may only refer to a COUNTRY that is valid at the Start Date of the ASSIGNMENT.

If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by A) Creating new attributes. B) Barring the relationships to the original entities. C) Placing the UID attributes from the original entities into the intersection entity. D) None of the above.

B) Barring the relationships to the original entities.

A Matrix Diagram will help you with all of the following except: A) Naming Relationships B) Defining Instances of Entities C) Identifying Entities D) Verifying Relationships Between Entities

B) Defining Instances of Entities

Unique Identifiers: A) Distinguish one entity from another B) Distinguish one instance of an entity from all other instances of that entity C) Distinguish nothing D) Distinguish all entities in a database

B) Distinguish one instance of an entity from all other instances of that entity

A database is a physical storage device for data. A) True B) False

B) False

A foreign key always refers to a primary key in the same table. True or False?

B) False

A unique identifier can only be made up of one attribute. True or False?

B) False

A unique identifier can only be made up of one attribute. True or False? A) True B) False

B) False

An entity can be on 2nd Normal Form even if it has repeated values. True or False? A) True B) False

B) False

An entity can only have one UID. True or False?

B) False

Audit trail attributes cannot be placed in the entities they are auditing, they must be placed in separate, new entities, created just for that purpose. True or False?

B) False

Creating a Matrix Diagram is a mandatory step in Data Modeling. True or False?

B) False

Data Modeling is the last step in the database development process. True or False?

B) False

Data is in second normal form (2NF) if it contains no repeating groups and has a primary key to uniquely identify each record. A) True B) False

B) False

Data redundancy is created through a process known as normalization. A) True B) False

B) False

If the entity CD has the attributes: #number, *title, *producer, *year, o store name, o store address, this entity is in 3rd Normal Form ("no non-UID attribute can be dependent on another non-UID attribute). True or False?

B) False

No database in the world is ever truly on 3rd Normal Form. Everyone always stops after 2nd Normal Form. True or False?

B) False

No formal rules exist for drawing ERD's. The most important thing is to make sure that all entities, attributes, and relationships are documented on the diagram. The Layout is insignificant. True or False?

B) False

Non-transferable relationships can only be mandatory, not optional. True or False?

B) False

One or more columns in a primary key can be null. True or False?

B) False

One-to-One relationships are transformed into Foreign Keys in the tables created at either end of that relationship. True or False?

B) False

Personal computers (PCs) have been in existence since 1950. True or False?

B) False

Personal computers (PCs) have been in existence since 1950. True or False? A) True B) False

B) False

Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?

B) False

The following entity is in 1st normal form: True or False? ENTITY: VEHICLE ATTRIBUTES: REGISTRATION MAKE MODEL COLOR DRIVER PASSENGER 1 PASSENGER 2 PASSENGER 3

B) False

The overall mission of the Oracle Corporation is to use the internet and fast processing servers to build its own network. A) True B) False

B) False

This diagram could also be expressed as a supertype/subtype construction. True or False?

B) False

When reading a relationship between 2 entities, the relationship is only read from left to right. True or False?

B) False

One-to-Many Optional to Mandatory becomes a _______________ on the Master table. A) Mandatory Foreign Key B) Nothing (There are no new columns created on the Master table) C) Optional Foreign Key D) Primary Key

B) Nothing (There are no new columns created on the Master table)

A customized hat sitting on your friend's head is an example of which model--the conceptual model or the physical model? A) Conceptual Model B) Physical Model

B) Physical Model

Which of the following is true about supertypes and subtypes? A) Two subtypes from the same supertype have a one-to-one relationship between them B) Subtypes inherit the relationships and attributes of the supertype C) Subtypes may have no more than 2 levels of nesting D) Supertype and subtype entities must mutually exclude one another

B) Subtypes inherit the relationships and attributes of the supertype

In a physical data model, an entity becomes a/an _____________. A) Constraint B) Table C) Column D) Attribute

B) Table

Why would you want to model a time component when designing a system that lets people buy bars of gold? A) You would not want to model this; it is not important. B) The price of gold fluctuates and, to determine the current price, you need to know the time of purchase. C) Sales people must determine where the gold is coming from. D) The Government of your country might want to be notified of this transaction.

B) The price of gold fluctuates and, to determine the current price, you need to know the time of purchase.

If a relationship can be moved between instances of the entities it connects, it is said to be: A) Recursive B) Transferable C) Committed D) Implicit

B) Transferable

Relationships always exist between A) 3 or more attributes B) 3 or more entities C) 2 attributes D) 2 entities (or one entity and itself)

D) 2 entities (or one entity and itself)

Which of the following is the best scenario for using supertype/subtype entities: A) A grocery store that gives customers a choice of plastic or paper bags B) An ice cream store that sells ice cream in sugar cones and regular cones C) A pet store that sells small animals that need different sized cages and different food D) A vehicle dealership that sells boats on trailers, cars, and trucks

D) A vehicle dealership that sells boats on trailers, cars, and trucks

The data model can be used to __________. A) Communicate and group B) Describe and specify C) Analyze and copy D) All of the Above

D) All of the Above

Which of the following would be a logical constraint when modeling time for a country entity? A) Daily traffic patterns must be monitored to determine which countries are overcrowded. B) People have births and deaths in their countries that must be tracked by the system. C) If you are doing a system for France or Germany, you would need security clearance. D) Countries may change their names and/or borders over a period of time.

D) Countries may change their names and/or borders over a period of time.

A non-transferable relationship is represented by which of the following symbols? A) Heart B) Triangle C) Circle D) Diamond

D) Diamond

Which of the following is the definition for Third Normal Form? A) All attributes are single valued B) All attributes are uniquely doubled and independent C) An attribute must be dependent upon the entity's entire UID D) No non-UID attribute can be dependent on another non-UID attribute

D) No non-UID attribute can be dependent on another non-UID attribute

Examine the following entity and decide which attribute breaks the 2nd Normal Form rule: ENTITY: CLASS ATTRIBUTES: A) CLASS ID B) DURATION C) SUBJECT D) TEACHER NAME AND ADDRESS

D) TEACHER NAME AND ADDRESS

During which phases of the System Development Life Cycle would you roll out the system to the users? A) Build and Transition B) Strategy and Analysis C) Design and Production D) Transition and Production

D) Transition and Production

The explanation below is an example of which constraint type? If the value in the balance column of the ACCOUNTS table is below 100, we must send a letter to the account owner which will require extra programming to enforce. A) Entity integrity B) Referential integrity C) Column integrity D) User-defined integrity

D) User-defined integrity

When are relationships unnecessary? A) When the relationships connect 2 entities and they each have distinct meanings B) When the information does not relate to the model C) When they have the same visual structure but different meaning D) When you can derive the relationship from other relationships in the model

D) When you can derive the relationship from other relationships in the model

A ____ is a group of interrelated files. A) record B) character C) field D) database

D) database

If you want to see just a subset of the columns in a table, you use what symbol? A) & B) % C) * D) instead of using a symbol, you name the columns for which you want to see data.

D) instead of using a symbol, you name the columns for which you want to see data.

In this simple diagram, what comprises the unique identifier for the student class entity? A) student id and class id B) student id, class id, and course id C) course id D) student id and course id

D) student id and course id

Which of the following are examples of data vs. information: A) Student age vs. average age of all students in class B) Bank deposit amount vs. total account balance C) Winning time for a race vs. length of race D) Price of a computer vs. total sales of all computers for a company E) A, B, and D

E) A, B, and D A) Student age vs. average age of all students in class B) Bank deposit amount vs. total account balance D) Price of a computer vs. total sales of all computers for a company

Which of the following are reasons we create conceptual models? A) It facilitates discussion; a picture is worth a thousand words B) It forms important ideal system documentation C) It takes into account government regulations and laws D) It forms a sound basis for physical database design E) All of the above

E) All of the above

Many-to-Many relationships are perfectly acceptable in a finished ERD. There is no need to do any more work on them. True or False?

False

Changes in computing have affected many of our day-to-day activities. Are all of the following activities examples of this change? Yes or No? In the past you used to use the phone system to call directory assistance to get a phone number. Today you can use your PC to look up a phone number online. In the past you used to have to go to the shoe store to buy shoes. Today you can use your PC to order shoes online. In the past you had to use your PC to send a person an email. Today you can use your phone to send a text message. A) No B) Yes

B) Yes

In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'? A) The database does not understand all capital letters B) You cannot have spaces between words in a table name C) JOBS is a reserved word D) EMPLOYEE is a reserved word

B) You cannot have spaces between words in a table name

A foreign key is usually found on which side of a relationship? A) one B) many C) unnormalized D) primary entity

B) many

Which of the following terms represents a collection of fields? A) field B) record C) character D) file

B) record

When you resolve a M:M by creating an intersection entity, this new entity will always inherit: A) The UID's from the entities in the original M:M. B) Nothing is inherited from the original entities and relationship. C) A relationship to each entity from the original M:M. D) The attributes of both related entities.

C) A relationship to each entity from the original M:M.

People are not born with "numbers", but a lot of systems assign student numbers, customer IDs, etc.ﾠA shoe has a color, a size, a style, but may not have a descriptive "number". To be able to uniquely and efficiently identify one instance of the entity SHOE, a/an ______________ UID can be created. A) Unrealistic B) Identification C) Artificial D) Structured

C) Artificial

How do you turn "data" into "information"? A) By testing it B) By storing it on a server C) By querying it or accessing it D) By storing it in a database

C) By querying it or accessing it

Column integrity refers to A) Columns always having values B) Columns always containing positive numbers C) Columns always containing values consistent with the defined data format D) Columns always containing text data less than 255 characters

C) Columns always containing values consistent with the defined data format

What are the major content areas covered in the Oracle Academy? A) SQL, database configuration, and performance tuning. B) Data Modeling, PJava and C+ C) Data Modeling, SQL, and PL/SQL D) Database programming, and Computer repair

C) Data Modeling, SQL, and PL/SQL

What is the benefit to the users of a system that includes "time"; e.g. Start Date and End Date for Employees? A) System becomes 100% unstable; allows users to log on and log off at will. B) Reporting becomes nearly impossible; users enjoy this. C) Increased usability and flexibility of a system; e.g., we can the trace the different managers an employee had over time. D) Users are able to create complex programs in support of this component.

C) Increased usability and flexibility of a system; e.g., we can the trace the different managers an employee had over time.

When data is stored in more than one place in a database, the database violates the rules of ___________. A) Decency B) Normalcy C) Normalization D) Replication

C) Normalization

If the same relationship is represented twice in an Entity Relationship Model, it is said to be: A) Resourceful B) Removable C) Redundant D) Replicated

C) Redundant

The transformation from an ER diagram to a physical design involves changing terminology. Entities in the ER diagram become __________ , and attributes become ____________. A) Foreign Keys, Columns B) Columns, Tables C) Tables, Columns D) Tables, Foreign Keys

C) Tables, Columns

Secondary UID's are A) Always comprised of numbers B) Mandatory in data modeling C) Useful as an alternative means of identifying instances of an entity D) Not permitted in data modeling

C) Useful as an alternative means of identifying instances of an entity

If you are tracking employment dates for an employee, do you need to have an "End Date" attribute? A) No, not if the company likes the employee. B) No, because an end date is usually redundant. C) Yes, if the company wants to track multiple start dates and insure that multiple employment dates for an employee do not overlap. D) Yes, because you always need an end date when you have a start date.

C) Yes, if the company wants to track multiple start dates and insure that multiple employment dates for an employee do not overlap.

How would you model a business rule that states that on a student's birthday, he does not have to attend his classes? A) Use a supertype B) Use a subtype C) You cannot model this. You need to document it D) Make the attribute Birthdate mandatory

C) You cannot model this. You need to document it

Which of the following may contain transitive dependencies, but not partial dependencies? A) unnormalized data B) first normal form (1NF) C) second normal form (2NF) D) third normal form (3NF)

C) second normal form (2NF)