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)