Accounting
Anthropology
Archaeology
Art History
Banking
Biology & Life Science
Business
Business Communication
Business Development
Business Ethics
Business Law
Chemistry
Communication
Computer Science
Counseling
Criminal Law
Curriculum & Instruction
Design
Earth Science
Economic
Education
Engineering
Finance
History & Theory
Humanities
Human Resource
International Business
Investments & Securities
Journalism
Law
Management
Marketing
Medicine
Medicine & Health Science
Nursing
Philosophy
Physic
Psychology
Real Estate
Science
Social Science
Sociology
Special Education
Speech
Visual Arts
Design
Q:
A set of words that cannot be used as names of columns or tables are known as __ words.
Q:
A long distance phone number stored in __ data type would need at least __ characters.
Q:
Hourly pay rate would be best represented as __ data type with __ decimals.
Q:
Last name would be stored in _ _data type and zip code in __ data type.
Q:
Inserting a child record that does not have a matching parent record will generate which of the following errors?a) Orphan Cannot Exist Without Parentsb) Integrity Constraint Violated " Parent Name Not Foundc) Integrity Constraint Violated " Parent Key Not Foundd) Integrity Constraint Violated " Parent Table Does Not Exist
Q:
Omitting a comma between fields in a Create Table statement will generate which of the following errors?
a) Invalid Identifier
b) Missing or Invalid Option
c) Invalid Column Specification
d) Missing Expression
Q:
Oracle tries to identify errors in which of the following ways?
a) It repeats the command that caused the error.
b) It identifies the line in the command that caused the error.
c) It places an asterisk under the first item in the line that it suspects of having generated an error.
d) All of the above
Q:
In Oracle, the command used to change the default date format to "dd-mm-yy" format is which of the following?
a) Change date format to "dd-mm-yy"
b) Format date("dd-mm-yy")
c) Alter session set nls_date_format = "dd-mm-yy"
d) Alter set format date("dd-mm-yy")
Q:
In Oracle, setting the options to feedback each command's execution on the screen is which of the following?
a) Set feedback on
b) Set command on
c) Set screen update on
d) Set echo on
Q:
For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients. In Oracle, the script line used to define the foreign key for the job table in the relationship with the client table would be which of the following?a) Email char(30) refers to client(email)b) Jobid Number refers to client(jobid)c) Email char(30) references client(email)d) Email char(30) links to client(email)
Q:
In Oracle, the script line that would save all the changes to the database would be which one of the following?a) Save changesb) Save all changesc) Commitd) Update changes
Q:
In Oracle, the script line used to display all the data that has been entered into the client table would be which of the following?
a) Describe data from client
b) Select all data from client
c) Select * client
d) Select * from client
Q:
In Oracle, the script line used to enter the first record into the client table would be which of the following?
a) Insert into client ("[email protected]", "Dentist Pros', "James Tucker", "63 Elm Street", "Manchester", "NH", "03308", "(603)774-6698")
b) Insert into client ("[email protected]" "Dentist Pros' "James Tucker" "63 Elm Street" "Manchester" "NH" "03308" "(603)774-6698")
c) Insert ("[email protected]", "Dentist Pros', "James Tucker", "63 Elm Street", "Manchester", "NH", "03308", "(603)774-6698")
d) Insert into client ([email protected], Dentist Pros, James Tucker, 63 Elm Street, Manchester, NH, 03308, (603)774-6698)
Q:
In Oracle, the script line used to describe the fields in the client table that was just created would be which of the following?
a) Describe client fields
b) Describe client
c) Describe table client
d) Client fields describe
Q:
In Oracle, the script line used to design the client table would be which of the following?
a) Design table client
b) Setup table client
c) Create table client
d) Build table client
Q:
In Oracle, the script line used to remove any previous version of the client table, would be which of the following?
a) Remove table client
b) Drop table client
c) Delete table client
d) Clear table client
Q:
For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients.ClientIn Oracle, the script line setting up the primary key, would be which of the following?a) Primary key email char(30)b) Email char(20) as primary keyc) Email char(10) primary keyd) Email char (30) primary key
Q:
The format for a comment in Oracle scripts is which one of the following?a) // Comment goes here //b) {* Comment goes here *}c) /* Comment goes here */d) [* Comment goes here *]
Q:
The command used to save all the changes made to the database is which of the following?
a) Insert
b) Describe
c) Select
d) Commit
Q:
The command used to verify that all the data was properly inserted is which of the following?
a) Insert
b) Describe
c) Select
d) Commit
Q:
The command used to verify that the table fields were properly created is which of the following?
a) Insert
b) Describe
c) Select
d) Commit
Q:
The advantage(s) of a well-designed script file is(are) which of the following?
a) Errors can be quickly located and corrected.
b) A corrupt database can be easily recreated.
c) A script file documents the creation process.
d) All of the above
Q:
A series of SQL commands designed to automate tasks is called a(n)
a) command set.
b) sequence.
c) script.
d) auto task.
Q:
Oracle's SQL interface allows the user to do which of the following?
a) Type SQL commands
b) Save a series of SQL commands
c) Retrieve a series of SQL commands
d) All of the above
Q:
Oracle's Web-based SQL interface is called which one of the following?
a) SQL*Plus
b) iSQL*Plus
c) SQL*iPlus
d) SQL script
Q:
Which of the following is true about the Insert statement?
a) Insert statement adds another column to the table.
b) One Insert statement can be used for the entire table.
c) Each record must have a separate Insert statement.
d) Each column must have a separate Insert statement.
Q:
The data for numeric fields must be enclosed in which of the following?
a) Single quotes
b) Double quotes
c) Parentheses
d) Numeric data does not need to be contained in quotes.
Q:
The data for all character string fields must be enclosed in which of the following?
a) Single quotes
b) Double quotes
c) Parentheses
d) Brackets
Q:
The SQL statement used to enter the data into a table is which of the following?
a) Enter
b) Data
c) Insert
d) Input
Q:
The SQL statement used to build a table is which of the following?
a) Build Table
b) Create Table
c) Set up Table
d) Construct Table
Q:
Common reserved word(s) in SQL is(are) which of the following?
a) Number
b) Column
c) Select
d) All of the above
Q:
Describe any possible use for supertype/subtype hierarchies in the Exposures case.
Q:
Exposures is a specialty retailer of fine gifts, picture frames, albums, scrapbooks, as well as occasional gift ideas. Visit their Web site at www.exposureonline.com, and using the registration, billing, catalog, and shopping cart screens below, go through each of the five ER design steps.Describe any possible use for recursive relationships in the Exposures case.
Q:
Draw all tables with the relationships, fields, indicating primary and foreign keys (when necessary) for all the tables.
Q:
Draw all tables with relationships and list the most important fields for each table.
Q:
Draw all tables with all the relationships, including any recursive and/or subtype/supertype relationships.
Q:
Describe the nature of supertype/subtype hierarchy in this case (if any) and discuss how it would be modeled in the ER diagram for this database.
Q:
Steve, the owner of Custom Furniture Inc., started with a small furniture shop building tables, chairs, and educational accessories for his daughter's grade school, and has since expanded to other small businesses and midsize companies in the state. Each of his products has several components, with components in the same group (e.g. tables) shared among different products. Further, within some of the larger product groups (tables, chairs), there are specialized categories such as office tables/chairs with its own set of attributes (reclining, number of lift positions for chairs, AC plug, data ports, cable management). Apart from the product-related tables, Steve is keeping track of customers, part suppliers, and other entities relevant for his business.For questions 87 - 91, please refer to the preceding paragraph.Describe the nature of recursive relationship in this case (if any) and discuss how it would be modeled in the ER diagram for this database.
Q:
Draw all tables with the relationships, fields, indicating primary and foreign keys (when necessary) for all the tables.
Q:
Draw all tables with relationships and list all the fields for each table.
Q:
Draw all tables with all the relationships, including any recursive and/or subtype/supertype relationships.
Q:
Describe the nature of supertype/subtype hierarchy in this case (if any) and discuss how it would be modeled in the ER diagram for this database.
Q:
Plymouth Car Rental (PCR) started in with two compact cars and has expanded its fleet of vehicles with several sedans and trucks. When a customer books a rental, his/her age has to be at least 18 for compact cars and sedans, which are rented by the day and must be returned the following morning by 11 AM. Trucks are rented for a maximum of six hours. The owner requires a deposit on the reservation to be paid within seven days of booking. Vehicle records consist of the makes and types (Honda sedan), color, seating capacity, required deposit, rental rate and rental limit (in hours). Customer data consists of customer's names, addresses, phone numbers, and birth dates. Bookings identify the customer, vehicle, as well as the time rented and returned. There can be several payments up until the reservation date. Payments must reflect the payment status for each booking, including deposit, when the deposit was made, then each of the payments made, and when the entire payment was completed.In addition, PCR decided to reward their customers who refer other customers with gas coupons on their future rentals (which also servers the purpose of retaining those customers). Because the business is booming, PCR added several other vehicles, both trucks and sedans and wants to expand information gathered on these. In particular, PCR wants to track several truck-related attributes such as towing capacity and whether it has a snow plow or not. For the sedans, geared towards nature explorers, it wants to track the type and capacity of bike racks, and whether it has a canoe rack.For questions 82 - 86, please refer to the preceding paragraph.Describe the nature of recursive relationship in this case (if any) and discuss how it would be modeled in the ER diagram for this database.
Q:
If we could have a client with two tax returns that have an identical general portion and different specialized portion, this would be an example of the __.
Q:
The fact that the specialized part of the return retains the attributes of the general part is called __.
Q:
If client's type (based on ownership, for example) was determining the type of specialized portion of tax returns, this field would be called a ___.
Q:
The specialized part of a client's tax return that is specific for this particular group of clients is called a __ entity.
Q:
A tax return can have __ tax forms, and a tax form can appear in __ returns.
Q:
The relationship between a tax return and all of its component tax forms is a __ recursive relationship.
Q:
A set of tax forms used in building a tax return could be viewed as tax return's __.
Q:
In the consultant mentor and mentored relationship, employee/consultant table is both a __ table and a __ table.
Q:
The foreign key in employee/consultant table establishing the recursive relationship between consultant mentors and mentored would be denoted as __.
Q:
For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients. In addition, each of the consultants (employees) has a senior consultant as a mentor to help with some of the more challenging jobs and to evaluate employee's performance. In turn, a particular employee (consultant) that has a senior employee as a mentor, can be a mentor himself to a more junior employee. Further, each of the jobs the company deals with has some things that are in common, starting with ID, date/time started/ended, and so forth. Also, there are some tax forms that must be filed with every client, regardless of specifics of a business situation. On the other hand, there are some specific forms that apply to certain types of business situations, but are different or simply not required for other clients.For questions 72-81, please refer to the preceding paragraph.The recursive relationship between consultant mentors and mentored has a __ cardinality.
Q:
In equipment supertype and computer subtype example, the computer subtype is said to __ all the attributes of the equipment supertype.
Q:
Equipment supertype and its computer and printer subtypes is an example of __ specialization and __ rule.
Q:
Total specialization means that all instances of __ must also belong to at least one __ category.
Q:
Specialized entities with different attribute lists are often called __ entities.
Q:
The general entity that contains a list of common attributes is often called a __ entity.
Q:
Supertype/subtype hierarchies are also called __ hierarchies.
Q:
Generalization/specialization hierarchies are also called __ hierarchies.
Q:
Supervisor relationship is an example of a __ recursive relationship between a supervisor and his/her subordinates.
Q:
In a recursive relationship, the entity involved is both a __ and a __.
Q:
Bill of materials is an example of a __ recursive relationship between a product and its components.
Q:
A recursive relationship between a product and its components is called __.
Q:
Modeling many-to-many recursive relationships requires a(n) __ table.
Q:
Supervisor relationship is an example of a __ relationship between a __ and his/her __.
Q:
Relationship between an instance of an entity and another instance of the same entity is called a __ relationship.
Q:
Recursive relationship is a relationship between an __ of an entity and __ of that same entity.
Q:
Specialized portions of the tax return that are different for different types of clients would be called which of the following?a) General entityb) Subtype entityc) Supertype entityd) Sublime entity
Q:
The general portion of the tax return common to all the returns would be called which of the following?
a) Specialized entity
b) Subtype entity
c) Supertype entity
d) Sublime entity
Q:
The fact that all specialized portions of returns retain common set of attributes from a general portion of the return is known as which of the following?
a) Subset
b) Superset
c) Inheritance
d) Overlap
Q:
Having all client's tax returns belong to at most one specialized sub-type category would be an example of which of the following?
a) Partial specialization
b) Total specialization
c) Disjoint rule
d) Overlap rule
Q:
Having all client's tax return belong to at least one specialized sub-type category would be an example of which of the following?
a) Partial specialization
b) Total specialization
c) Disjoint rule
d) Overlap rule
Q:
Having some client's tax return that do not contain specialized attributes would be an example of which of the following?
a) Partial specialization
b) Total specialization
c) Disjoint rule
d) Overlap rule
Q:
Viewing client's tax return with some common attributes and some specialized attributes, which of the following characterizations would be most accurate?
a) Partial specialization and disjoint rule
b) Partial specialization and overlap rule
c) Total specialization and disjoint rule
d) Total specialization and overlap rule
Q:
Recognizing that all the client's tax returns have some attributes in common, and that some are specific to the client's business situation (industry, ownership structure, etc.) would be represented in a database using which of the following?
a) One-to-many recursive relationship
b) Many-to-many recursive relationship
c) Supertype/subtype hierarchy
d) One table with a special field
Q:
Modeling the relationship between client's tax returns and tax forms requires which of the following?
a) Separating tax returns and tax forms into two tables
b) Listing all the required tax forms for a given return in a single table using several different fields
c) Listing all the required tax forms for a given return in a single table using a single additional field
d) Modeling this relationship does not require any action at all
Q:
The relationship between tax returns and tax forms used to build it can be viewed as which of the following?
a) One-to-many retroactive relationship
b) One-to-many recursive relationship
c) Many-to-many retroactive relationship
d) Many-to-many recursive relationship
Q:
For the employee (consultant) entity, which of the following is true?
a) Consultant is the parent but not the child entity.
b) Consultant is both the parent and the child entity.
c) Consultant is the child but not the parent entity.
d) Consultant is neither the parent nor the child entity.
Q:
Modeling consultant mentors and consultant being mentored requires which of the following?
a) Separating mentors and mentored into two separate tables
b) Another non-key Mentored? yes/no indicator field
c) Another foreign-key CONSULTANT$Mentored field
d) No action is needed to model this relationship.