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:
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 Access, the data type and size for Email field would be Text(10).
Q:
Social security number is stored in Text data type.
Q:
Zip code is stored in Number data type.
Q:
Text data type cannot contain numerical digits.
Q:
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:
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 and Web screens.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, 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.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 1960's, 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 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.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 Oracle, the statement used to show all employees' social security numbers and names that don"t have jobs assigned to them, would be _
Q:
In Oracle, the statement used to show all clients' emails and contacts for whom jobs have been done, would be __.
Q:
In Oracle , 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 Oracle, 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 Oracle, 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 Oracle, the statement used to display client emails and contacts, together with all of their job dates and times would be __.
Q:
In Oracle, 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 Oracle, the statement used to show all the different client zip codes, would be __.
Q:
In Oracle, the statement used to calculate the number of clients from each zip code, labeled "Zip Clients", would be __.
Q:
In Oracle, the statement used to calculate the number of clients from NH, labeled as "NH Clients", would be __.
Q:
In Oracle, the statement used to retrieve client's contact with emails that end in "net", from zip codes 03223 and 03264, would be __.
Q:
In Oracle, the statement used to retrieve client's contacts with emails that are not from zip codes 03223 and 03264, would be _.
Q:
In Oracle, the statement used to retrieve client's contacts with emails from zip codes 03223 and 03264 only, would be __.
Q:
In Oracle, the statement used to retrieve client's contacts with emails ending in "net", and from area code 603, would be __.
Q:
In Oracle, the statement used to retrieve client's contacts with emails ending in "net", would be __.
Q:
In Oracle, the statement used to retrieve an employee name and birth date, for employee with social security number 261284363, would be __.
Q:
In Oracle, the statement used to retrieve all the jobs with jobid over 5, displaying only jobids and associated dates, would be __.
Q:
In Oracle, the statement used to retrieve all the client data, ordered first by state and then by zip code would be __.
Q:
In Oracle, the statement used to retrieve all of the client's names, sorted A to Z, with city, state, and zip code would be __.
Q:
In Oracle, the statement used to retrieve all of the client's contacts and emails would be __.
Q:
In Oracle SQL script, the __ statement is used to select the columns to be included in the query.
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 60-81, please refer to the preceding paragraph.In Oracle, the statement used to retrieve all of the data from the employee table would be ____.
Q:
__ operation combines data from two tables.
Q:
__ operation retrieves a subset of columns.
Q:
__ operation retrieves a subset of rows.
Q:
In Oracle, the statement used to display employees' social security numbers and names that don"t have any jobs assigned to them, would be which of the following?a) Select employee.ssn, employee.name From job Where employee.ssn Not In (Select Distinct job.ssn From job)b) Select employee.ssn, employee.name From job Where employee.ssn Not In (Select Distinct Employee.ssn From employee)c) Select employee.ssn, employee.name From employee Where employee.ssn Not In (Select Distinct job.ssn From job)d) Select employee.ssn, employee.name From employee Where employee.ssn In (Select Distinct job.ssn From job)
Q:
For subqueries, which of the following statements is correct?
a) Inner queries execute last and outer queries execute first.
b) Inner queries execute at the same time as outer queries.
c) Inner queries execute first and outer queries execute last.
d) Inner queries execute independently of outer queries.
Q:
Correcting an ambiguous name problem requires which of the following?
a) Changing the name in the SQL statement
b) Preceding the name with the table name
c) Following the name with the table name
d) Separating the name from the table name
Q:
In Oracle, the statement used to display employee and client names together with all of the job dates, sorted from earliest to latest, would be which one of the following?
a) Select employee.name, client.name, job.date From employee Inner Join (client Inner Join job On client.email = job.jobid) On employee.ssn = job.jobid Order by job.date
b) Select employee.name, client.name, job.date From employee, client, job Order by job.date
c) Select employee.name, client.name, job.date From employee, client, job Where client.email = employee.ssn And employee.ssn = job.jobid Order by job.date
d) Select employee.name, client.name, job.date From Where client.email = job.email And employee.ssn = job.ssn Order by job.date
Q:
In Microsoft Access, the statement used to display employee names together with job dates and times, for all jobs starting on either 3/12/06 or at 8 A.M., would be which of the following?
a) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job On employee.ssn = job.ssn Where job.date = "3/12/06" And job.timestart = "8:00 AM"
b) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job On employee.ssn = job.jobid Where job.date = "3/12/06" Or job.timeend = "8:00 AM"
c) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job On employee.ssn = job.ssn Where job.date = "3/12/06" Or job.timestart = "8:00 AM"
d) Select employee.name, job.date, job.timestart, job.timeend From employee, job On employee.ssn = job.ssn Where job.date = "3/12/06" Or job.timestart = "8:00 AM"
Q:
In Oracle, the statement used to display employee names together with job dates and times, for all jobs starting at 8 A.M., would be which of the following?
a) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job On employee.ssn = job.ssn Where job.timestart = "8:00 AM"
b) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job On employee.ssn = job.ssn Where job.timeend = "8:00 AM"
c) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job Where job.timestart = "8:00 AM"
d) Select employee.name, job.date, job.timestart, job.timeend From employee, job On employee.ssn = job.ssn Where job.timestart = "8:00 AM"
Q:
In Microsoft Access, the statement used to display employee names together with all of their job dates and times would be which of the following?
a) Select employee.name, job.date, job.timestart, job.timeend From employee, job Where employee.ssn = job.jobid
b) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job On employee.ssn = job.ssn
c) Select employee.name, job.date, job.timestart, job.timeend From employee.ssn Inner Join On job.ssn
d) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job On employee = job
Q:
In Oracle, the statement used to calculate the number of clients from each NH zip code, labeled "Zip Clients", would be which of the following?
a) Select zipcode, Count(email) From client Group by zipcode Where state != "NH"
b) Select zipcode, Count(email) As "Zip Clients' From client Group by zipcode
c) Select zipcode, Count(email) As "Zip Clients' From client Group by zipcode Where state = "NH"
d) Select zipcode, Count(email) As "Zip Clients' From client Group by zipcode Where state is "NH"
Q:
Count function does which of the following?
a) Returns the total of the values in the column for the selected rows
b) Returns the average of the values in the column for the selected rows
c) Returns the number of values in the column for the selected rows
d) Returns the highest value in the column for the selected rows
Q:
In Oracle, the statement used to retrieve all the jobs with jobid greater than 5 and less than 8, displaying only jobids and associated dates, would be which of the following?
a) Select jobid, date From Job Where jobid between 5 and 8
b) Select jobid, date From Job Where jobid >5 And <8
c) Select jobid, date From Job Where jobid >=5 and <=8
d) Select jobid, date From Job Where jobid 5 and 8
Q:
In Oracle, which of the following statements would result in contacts, emails, and zip codes for the clients whose emails end in "net", and who live in 03264 zip code?
a) Select contact, email, zipcode From client Where email Not Like "net" And zipcode != "03264"
b) Select contact, email, zipcode From client Where email Like "*net" Or zipcode = "03264"
c) Select contact, email, zipcode From client Where email Like "net" Or zipcode = "03264"
d) Select contact, email, zipcode From client Where email Like "*net" And zipcode = "03264"
Q:
In Oracle, which of the following statements would result in contacts, emails, and zip codes for the clients whose emails either end in "net", or who live in 03264 zip code?
a) Select contact, email, zipcode From client Where email Not Like "net" And zipcode != "03264"
b) Select contact, email, zipcode From client Where Email Like "*net" Or zipcode = "03264"
c) Select contact, email, zipcode From client Where Email Like "net" Or zipcode = "03264"
d) Select contact, email, zipcode From client Where Email Like "*net" And zipcode = "03264"
Q:
Complex Where clauses typically involve several conditions and use which of the following logical operators?
a) +, -, *, /
b) =, <, >, <=, >=, !=
c) And, Or
d) Like, Unlike
Q:
In Oracle, which of the following statements would result in contacts and emails only for the clients in 603 area code?
a) Select contact, email From client Where phone Not Like "603*"
b) Select contact, email From client Where phone Like "603"
c) Select contact, email From client Where phone Like "603*"
d) Select contact, email From client Where phone Like "*603*"
Q:
In Oracle, which of the following statements would result in contacts and emails only for the clients in the state of New Hampshire?
a) Select contact, email From client Where state equals "NH"
b) Select contact, email From client Where state != "NH"
c) Select contact, email From client Where state = "NH"
d) Select contact, email From client Where state is "NH"
Q:
Which of the following are referred to as conditional operators?
a) +, -, *, /
b) =, >, <, >=, <=, !=
c) %, &, @, #
d) (, [, {, ), ], }
Q:
In Oracle SQL script, the condition restricting jobs to those with jobid of 5 or more, would go into which of the following commands?
a) Select
b) From
c) Order by
d) Where
Q:
Which of the following conditions would result in a list of jobs with jobid of 5 or more?
a) jobid > 5
b) jobid >= 5
c) jobid != 5
d) jobid <=5
Q:
Selecting a subset of rows meeting certain conditions is accomplished using which of the following?
a) Select statement
b) From keyword
c) Where clause
d) Condition keyword
Q:
Sorting on multiple columns in Oracle SQL script involves which of the following?
a) Placing the fields in order in which they should be sorted in Order by command
b) Placing keyword desc at the end of Order by command for Z->A sort or leaving it blank for ascending sort
c) Listing all the fields that need to be shown in Select command
d) All of the above
Q:
In Microsoft Access, which of the following would be used to sort the client list consisting of contacts and emails, alphabetically from Z to A, by contact?
a) Select * From Client Order by Contact
b) Select Contact, Email From Client Order by Contact desc
c) Select Contact, Email From Client Order by Contact
d) Select Contact, Email Order by Contact desc
Q:
Which of the following would be selected in order to display client contacts and their emails only?
a) Select contact and email From client
b) Select * From client
c) Select contact, email From client
d) Select From client Fields contact, email
Q:
In Oracle, which of the following environments allows you to create and execute SQL statements?
a) iSQL*Plus workspace
b) SQL*Plus workspace
c) SQL workspace
d) Web workspace
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 Oracle, 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:
SQL implements selection, projection, and joining operations using which of the following?a) SQL statementb) Select statementc) From keywordd) Retrieval statement
Q:
The only required element(s) for an SQL statement is(are) which of the following?
a) Select statement
b) From keyword
c) Select statement and From keyword
d) Select and SQL statements
Q:
Projection operation does which of the following?
a) Retrieves a subset of rows
b) Retrieves a subset of columns
c) Combines data from two tables
d) Makes a link between two tables
Q:
Selection operation does which of the following?
a) Retrieves a subset of rows
b) Retrieves a subset of columns
c) Combines data from two tables
d) Makes a link between two tables
Q:
Joining operation does which of the following?
a) Retrieves a subset of rows
b) Retrieves a subset of columns
c) Combines data from two tables
d) Makes a link between two tables
Q:
Which one of the following is(are) the core retrieval operation(s) for relational databases?
a) Selection
b) Projection
c) Joining
d) All of the above
Q:
In a query with a subquery, outer subquery always executes first.
Q:
Instead of using where clause to perform a join, Oracle uses the inner join keyword.
Q:
To perform a join, a Where clause specifies that the value of the primary key in a parent table equals to the value of the foreign key in a child table.
Q:
Cartesian product is a temporary table that combines all rows in one table with all rows in another table.
Q:
The types of joins most widely used are the so-called outer joins.
Q:
Combining data from different tables into a single result set is called performing a join.
Q:
Distinct keyword would be used to find out how many different values there are in a particular field.