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:
Which of the following would be used in order to create Select * From client code in SQL Query Analyzer?
a) Execute button
b) Object browser
c) Query pane
d) Results pane
Q:
In Microsoft SQL Server Enterprise Manager, which of the following Tools menu items allows you to create and execute SQL statements?
a) SQL Query Analyzer
b) SQL Profiler
c) Generate SQL Script
d) Manage SQL Server Messages
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.For questions 33-56, please refer to the preceding paragraph.In SQL Query Analyzer, the statement used to retrieve all the data from the job table, would be which of the following?a) Select job From *b) Select * From jobc) From job Select *d) From * Select job
Q:
In order to perform a multiple join, the Where clause is used together with Or operator.
Q:
We can run the query by clicking on the Play button in SQL Query.
Q:
In SQL Query Analyzer, the statement used to display all the employees, sorted first by their names, and then by birth dates would be: Select * From employee Order by birthdate, name.
Q:
In SQL Query Analyzer, the bottom pane shows the query results.
Q:
In SQL Query Analyzer, the top pane shows the SQL script.
Q:
The only required elements of an SQL statement are: (1) the Select statement (followed by a list of tables), and (2) the From keyword (followed by a list of columns).
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 92-95, please refer to the preceding paragraph, web screens, and the table relationships below.Design the query that lists all the products based on the total quantity sold. The list should include the product name, price, and the amount sold in decreasing order.
Q:
Design the query that calculates the order totals for each of the customers, sorted descending by the totals. Include the customer names, order dates, as well any other information you deem necessary.
Q:
Design the query that calculates the number of customers using a particular credit card, sorted by card type.
Q:
List all the customers from zip codes 03223 and 03264 alphabetically by their last names. Include their first and last names, street addresses, city, state, and zip codes.
Q:
Create the query that calculates the "Average Time to Delivery" from lowest to highest, grouped by supplier, and only for the flowers delivered in good condition.
Q:
Design the query that will calculate total revenue for each of the flower groups, labeled as "Total Revenue".
Q:
Design the query that calculates which flower groups are ordered the most, displayed as "Best Sellers", and display them from highest to the lowest, including their price.
Q:
Design the query that retrieves the flowers (from A to Z) that bloom in early spring, and last more than three days.
Q:
Jerry, the owner of Exotic Flower 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 87-91, please refer to the preceding paragraph and diagram relationships below.Design the query that retrieves flower group and price for flowers that have any kind of sun storage need.
Q:
Design the query that shows all the vehicles not currently booked. Include vehicle ID, make, type, and rental rate.
Q:
Design the query that retrieves all the customer names and phone numbers, and calculates the total number of bookings as "Num Bookings", only for the repeat customers (more than one booking).
Q:
Design the query that retrieves all the customer names and phone numbers, only for the customers born in the 1960s, that made the reservations between 7/1/06 and 7/15/06, sorted by rental date.
Q:
Design the query that calculates the average rental rate, labeled "Avg Rate", for different vehicle types sorted from A to Z.
Q:
Plymouth Car Rental (PCR) 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 A.M. 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-86, please refer to the preceding paragraph and diagram relationship below.Design the query that retrieves customer names, addresses, and birth dates, born after 1/1/1970, and from zip codes 03223 and 03264.
Q:
In SQL Query Analyzer, the statement used to show all employee social security numbers and names that don"t have jobs assigned to them, would be __.
Q:
In SQL Query Analyzer, the statement used to show all client emails and contacts for whom jobs have been done, would be __.
Q:
In SQL Query Analyzer, the statement used to display employee and client names together with all of the jobs for 3/14/06, sorted alphabetically by client name, would be __.
Q:
In SQL Query Analyzer, the statement used to display client emails and contacts, together with job dates and times, for the jobs that start at either 8 A.M. or 10 A.M., would be __.
Q:
In SQL Query Analyzer, the statement used to display client emails and contacts, together with job dates and times from 3/13/06 to 3/15/06, would be __.
Q:
In SQL Query Analyzer, the statement used to display client emails and contacts, together with all of their job dates and times would be __.
Q:
In SQL Query Analyzer, the statement used to calculate the number of clients, labeled "Zip Clients", from each zip code in states with at least three clients, would be __.
Q:
In SQL Query Analyzer, the statement used to show all the different client zip codes, would be __.
Q:
In SQL Query Analyzer, the statement used to calculate the number of clients from each zip code, labeled "Zip Clients", would be __.
Q:
In SQL Query Analyzer, the statement used to calculate the number of clients from NH, labeled as "NH Clients", would be __.
Q:
In SQL Query Analyzer, the statement used to retrieve client's contact with emails that end in "net", from zip codes 03223 and 03264, would be __.
Q:
In SQL Query Analyzer, the statement used to retrieve client's contacts with emails that are not from zip codes 03223 and 03264, would be _.
Q:
In SQL Query Analyzer, the statement used to retrieve client's contacts with emails from zip codes 03223 and 03264 only, would be __.
Q:
Establish the relationships between the tables in exposures Microsoft SQL Server database. Make sure to indicate the correct cardinality.
Q:
Complete the design of the order table in exposures Microsoft SQL Server database. Make sure to indicate which of the fields is the primary key.
Q:
Complete the design of the LineItem table in exposures Microsoft SQL Server database. Make sure to indicate which of the fields is the primary key.
Q:
Complete the design of the product table in exposures Microsoft SQL Server database. 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 91"95, please refer to the preceding paragraph and web pages.Complete the design of the customer table in exposures Microsoft SQL Server database. Make sure to indicate which of the fields is the primary key.
Q:
Establish the relationships between the tables in flower Microsoft SQL Server database. Make sure to indicate the correct cardinality.
Q:
Complete the design of the order table in flower Microsoft SQL Server database. Make sure to indicate which of the fields is the primary key.
Q:
Complete the design of the supplier table in flower Microsoft SQL Server database. 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 87-90, please refer to the preceding paragraph.Complete the design of the flower table in flower Microsoft SQL Server database. Make sure to indicate which of the fields is the primary key.
Q:
Establish the relationships between the tables in rental Microsoft SQL Server database. Make sure to indicate the correct cardinality.
Q:
Complete the design of the payment table in rental Microsoft SQL Server database. Make sure to indicate which of the fields is the primary key.
Q:
Complete the design of the booking table in rental Microsoft SQL Server database. Make sure to indicate which of the fields is the primary key.
Q:
Complete the design of the vehicle table in rental Microsoft SQL Server database. 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-86, please refer to the preceding paragraph.Complete the design of the customer table in rental Microsoft SQL Server database. Make sure to indicate which of the fields is the primary key.
Q:
Establish the relationships between the tables in quick_tax Microsoft SQL Server database. Make sure to indicate the correct cardinality.
Q:
Complete the design of the employee table in quick_tax Microsoft SQL Server database. Make sure to indicate which of the fields is the primary key.
Q:
Complete the design of the job table in quick_tax Microsoft SQL Server database. Make sure to indicate which of the fields is the primary key.
Q:
Complete the design of the client table in quick_tax Microsoft SQL Server database. Make sure to indicate which of the fields is the primary key.
Q:
In Microsoft SQL Server, a concatenated primary key is created in design view by _ all the component fields and clicking on __ button.
Q:
In Microsoft SQL Server, right-clicking on the Employee table and choosing _ will open the Employee table in __ view.
Q:
In Microsoft SQL Server Edit Diagram window, the link between Employee and Job tables will show __ next to SSN in Employee table and __ next to SSN in Job table.
Q:
In Microsoft SQL Server Edit Diagram window for Employee and Job tables, in order for the change in SSN in Employee table to be reflected in Job table, requires turning on __ check box.
Q:
In Microsoft SQL Server Edit Diagram window, making sure that the values in the foreign key match the values in the primary key, requires turning on _ check box.
Q:
In Microsoft SQL Server, the relationship between two tables is established by dragging the __ from the __ table onto the __ in the __ table.
Q:
In Microsoft SQL Server, the primary key is defined by right-clicking on the field and selecting __ from the list.
Q:
In Microsoft SQL Server, Validation rule restricting area code field entries to either 603 or 802, would be specified as __.
Q:
In Microsoft SQL Server, a check constraint restricting pay rate field entries to be between 10 and 15 dollars per hour, would be specified as __.
Q:
In Microsoft SQL Server, a check constraint restricting order quantity field entries to positive numbers, would be specified as __.
Q:
In Microsoft SQL Server, __ are constraints that can be applied to restrict values in a column.
Q:
In Microsoft SQL Server, __ are procedural programs that are stored as a part of the database.
Q:
Creating a table structure In Microsoft SQL Server is done in __ view.
Q:
Microsoft SQL Server uses __ to graphically show the database structure.
Q:
Microsoft SQL Server's uses _ to create temporary tables.
Q:
In Microsoft SQL Server, from the standpoint of a user entering data into the client table, the most efficient way of implementing State field would be using __.
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 Microsoft SQL Server, the most appropriate data type and size for Telephone field would be __.
Q:
In Microsoft SQL Server, a social-security number field stored in __ data type would need at least __ characters.
Q:
In Microsoft SQL Server, hourly pay rate would be best represented as __ data type with __ decimals.
Q:
In Microsoft SQL Server, a long distance phone number field stored in __ data type would need at least __ characters.
Q:
In Microsoft SQL Server, forcing the removal of a record in the parent table to result in removal of all related records in the child table, is provided by which of the following?a) Enforce Relationship for INSERTs and UPDATEsb) Cascade Update Related Fieldsc) Cascade Delete Related Fieldsd) Change Join Type
Q:
In Microsoft SQL Server, forcing a change on the primary key to also occur in the foreign key in a relationship, is provided by which of the following?
a) Enforce Relationship for INSERTs and UPDATEs
b) Cascade Update Related Fields
c) Cascade Delete Related Fields
d) Change Joint Type
Q:
In Microsoft SQL Server, assurance that the values of primary and foreign key in a relationship will match, is provided by which of the following?
a) Enforce Relationship for INSERTs and UPDATEs
b) Cascade Update Related Fields
c) Cascade Delete Related Fields
d) Change Join Type
Q:
In Microsoft SQL Server, inserting links between Client and Job tables, as well as Employee and Job table, establishes which other relationship?
a) One-to-one Client-Employee relationship
b) One-to-many Client-Employee relationship
c) Many-to-many Client-Employee relationship
d) No additional relationship is established
Q:
In Microsoft SQL Server, after adding all three tables to the Edit Diagram window, the link between Client and Employee tables is established by doing which of the following?
a) Dragging SSN field from Employee table onto Name field in Client table
b) Dragging SSN field from Employee table onto SSN field in Job table and dragging Email field from Client table onto Email field in Job table
c) Dragging SSN field from Employee table onto Email field in Client table
d) Nothing, there is no relationship between Client and Employee tables
Q:
In Microsoft SQL Server, after adding all three tables to the Edit Diagram window, the link between Employee and Job tables is established by doing which of the following?
a) Dragging SSN field from Employee table onto JobID field in Job table
b) Dragging JobID from Job table onto SSN field in Employee table
c) Dragging Email field from Client table onto Email field in Job table
d) Dragging SSN field from Employee table onto SSN field in Job table