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
Humanities
Q:
All the data for a table can be entered with a single Insert statement.
Q:
All the fields in the Create Table statement are separated by commas, except for the last field.
Q:
Using a reserved word "level" as a column name is not allowed.
Q:
Social security number would be stored in Char data type.
Q:
Phone number would be stored in Number data type.
Q:
Varchar data type cannot contain numerical digits.
Q:
Complete the design of the line item table in an Oracle database using appropriate SQL script. Make sure to indicate which of the fields is the primary key.
Q:
Complete the design of the order table in an Oracle database using appropriate SQL script. Assume that any necessary parent tables have been created. Make sure to indicate which of the fields is the primary key and which fields are the foreign keys.
Q:
Complete the design of the product table in an Oracle database using appropriate SQL script. Make sure to indicate which of the fields is the primary key.
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.For questions 89"92, please refer to the preceding paragraph and Web pages.Complete the design of the customer table in an Oracle database using appropriate SQL script. Make sure to indicate which of the fields is the primary key.
Q:
Complete the design of the order table in an Oracle database using appropriate SQL script. Assume that any necessary parent tables have been created. Make sure to indicate which of the fields is the primary key and which fields are the foreign keys.
Q:
Complete the design of the supplier table in an Oracle database using appropriate SQL script. Make sure to indicate which of the fields is the primary key.
Q:
Jerry, the owner of Exotic Flower's Inc., built a small greenhouse to store several types of exotic flowers that he purchases from wholesale suppliers around the world. Each exotic flower Jerry buys and resells falls into one of several flower groups that differ with respect to their storage needs, duration, time in bloom, price, etc. Each of the orders placed by customers specifies the type of exotic flower, the supplier it came from, the date of order, expected delivery date, flower condition on delivery, as well as the quantity ordered. Customer's data contain all the standard information needed to collect payment and deliver the flowers.For questions 86"88, please refer to the preceding paragraph.Complete the design of the flower table in an Oracle database using appropriate SQL script. Make sure to indicate which of the fields is the primary key.
Q:
Complete the design of the payment table in an Oracle database using appropriate SQL script. Make sure to indicate which of the fields is the primary key.
Q:
Complete the design of the booking table in an Oracle database using appropriate SQL script. Assume that any necessary parent tables have been created. Make sure to indicate which of the fields is the primary key and which fields are the foreign keys.
Q:
Complete the design of the vehicle table in an Oracle database using appropriate SQL script. Make sure to indicate which of the fields is the primary key.
Q:
Plymouth Car Rental started 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.For questions 82"85, please refer to the preceding paragraph.Complete the design of the customer table in an Oracle database using appropriate SQL script. Make sure to indicate which of the fields is the primary key.
Q:
In Oracle, using Number for a column name, would generate an _ error.
Q:
In Oracle, an extra comma at the end of the column list in the Insert statement will generate an __ error.
Q:
In Oracle, omitting a comma between fields in the Create Table statement will generate a __ error message.
Q:
A children table without a reference to a parent table is called a(n) __.
Q:
In Oracle, if the primary key for the job table was client's email, employee's social security number, and job date, the script line defining this concatenated key would be: __.
Q:
In Oracle, the script line used to define the foreign key in job table, creating a relationship with client table, would be: __.
Q:
In Oracle, the script line used to define the foreign key in job table, creating a relationship with client table, would be: __.
Q:
In Oracle, after all the data has been inserted into the client table, the script line used to check that the correct data was entered, would be: __.
Q:
In Oracle, the script line used to enter the first record into the client table, would be: __
Q:
In Oracle, the script line used to describe the fields in the client table that was just created, would be: __.
Q:
In Oracle, the script line used to create the client table, would be: __.
Q:
In Oracle, the script line used to remove any previous version of the client table, would be: __.
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 setting Email as the primary key, would be: __.
Q:
Oracle workspace screen can be customized using __ link.
Q:
In Oracle, previously executed scripts during the current session can be viewed using _ link.
Q:
In Oracle, saved scripts are retrieved using __ button.
Q:
The command __ is used to verify that the tables were properly created.
Q:
The developer can enhance script documentation by adding __.
Q:
The command __ is used to destroy the database.
Q:
In the Create Table statement, each of the field names is followed by the appropriate __ and separated from other fields by a __.
Q:
The primary key is identified by typing the words __ after the data type of the appropriate field.
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.