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:
In Microsoft SQL Server, after adding all three tables to the Edit Diagram window, the link between Client and Job tables is established by doing which of the following?
a) Dragging Email field from Client table onto JobID field in Job table
b) Dragging Email field from Client table onto Email field in Job table
c) Dragging JobID field from Job table onto Email field in Client table
d) Dragging SSN field from Employee table onto SSN field in Job table
Q:
In the relationship between Client and Job tables, which of the following fields in Job table is the foreign key?a) JobIDb) Emailc) SSNd) Date
Q:
In Microsoft SQL Server, data is entered into a table using which of the following?a) Design viewb) Datasheet viewc) Database diagramd) Open view
Q:
In Microsoft SQL Server design view of the client table, the primary key would be specified by doing which one of the following?
a) Right-clicking on email row and selecting Indexes/Keys
b) Right-clicking on email row and selecting Set Primary Key
c) Right-clicking on email row and selecting Task
d) Right-clicking on email row and selecting Relationships
Q:
In Microsoft SQL Server, Create Database Diagram Wizard is used to create which of the following?
a) Database structure
b) Table structure
c) Relationships between tables
d) All of the above
Q:
In Microsoft SQL Server, a check constraint for State field with Nvarchar(2) data type in the client table, would most likely be which of the following?
a) "states'
b) state "NH"
c) state in ("NH", "VT")
d) state not in ("VT")
Q:
In Microsoft SQL Server, which one of the following is used to save sets of instructions for retrieving database data?
a) Views
b) User forms
c) Stored procedures
d) User defined functions
Q:
In Microsoft SQL Server, which of the following is used to create interactive screens that allow end user to work with database data?
a) Views
b) User forms
c) Stored procedures
d) User defined functions
Q:
In Microsoft SQL Server, a set of database users allowed certain type of access to the database can be defined using which of the following?
a) Views
b) Stored procedures
c) Roles
d) Users
Q:
In Microsoft SQL Server, the functions that can be used to automate tasks are created using which of the following?
a) Views
b) Stored procedures
c) Roles
d) Users
Q:
In Microsoft SQL Server creating a table structure is accomplished using which of the following?
a) Diagrams
b) Tables
c) Views
d) Stored procedures
Q:
In the Microsoft SQL Server Enterprise Manager initial window, which of the following items is used for creating databases?
a) Databases
b) Management
c) Replication
d) Security
Q:
Which of the following best describes the process of creating a database In Microsoft SQL Server?
a) Specifying database name, designing tables and entering data
b) Specifying database name, entering data and designing tables
c) Designing tables, entering data and specifying database name
d) Entering data, specifying database name and designing tables
Q:
In Microsoft SQL Server, in order to create an new empty database, which of the following option would be used?
a) New database
b) New table
c) New view
d) New database diagram
Q:
The most appropriate candidate for the primary field in the client table would be which of the following?
a) Email
b) Zip Code
c) Phone
d) Name
Q:
In Microsoft SQL Server, the most appropriate data type and size for State field would be which of the following?
a) Nvarchar(2)
b) Nvarchar(20)
c) Nvarchar(30)
d) Ntext
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 Email field would be which of the following?a) Nvarchar(2)b) Nvarchar(20)c) Nvarchar(30)d) Ntext
Q:
In Microsoft SQL Server, the most appropriate data type to store the order quantity would be which of the following?a) Numericb) Decimalc) Smallintd) Int
Q:
In Microsoft SQL Server, the most appropriate data type for a field indicating whether the order has been shipped or not would be which of the following?
a) Tinyint
b) Bit
c) Numeric
d) Decimal
Q:
In Microsoft SQL Server, the most appropriate data type to store order dates is which of the following?
a) Nvarchar
b) Nchar
c) Datetime
d) Smalldatetime
Q:
In Microsoft SQL Server, the most appropriate data type to store product prices is which of the following?
a) Numeric
b) Decimal
c) Money
d) Float
Q:
In Microsoft SQL Server, the most appropriate data type to store product pictures is which of the following?
a) Nvarchar
b) Ntext
c) Image
d) Float
Q:
In Microsoft SQL Server, the most appropriate data type to store product descriptions is which of the following?
a) Nvarchar
b) Ntext
c) Image
d) Float
Q:
In Microsoft SQL Server, in order to remove the table from the database, any relationships with other tables have to be deleted first.
Q:
In Microsoft SQL Server Relationships window for two related tables, there is an option for changing the name of the relationship.
Q:
In Microsoft SQL Server Relationships window for Client and Job tables, the Selected Relationship status would read ∞ FK_Job_Client.
Q:
In Microsoft SQL Server Relationships window, if Cascade Delete Related Fields is checked, deleting an employee from primary table would result in removal of all jobs performed by that employee in Job table.
Q:
In Microsoft SQL Server Relationships window, if Cascade Update Related Fields is checked, a change in Email address in Client table, would result in changes for all corresponding Email values in Job table.
Q:
In Microsoft SQL Server Relationships window, there is a direct association between Client and Employee tables.
Q:
In Microsoft SQL Server, the relationship between two tables is established by right-clicking the primary key in the parent table, and under Relationships tab of Properties window, associating it with the foreign key in the child table.
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 Microsoft SQL Server, the link between Employee and Job tables is established by right-clicking on JobID field from the Job table, and in associating it with SSN field of the Employee table.
Q:
In Microsoft SQL Server, "Email Address" entered into the Description property of Email field would appear as a label for Email field in datasheet view.
Q:
Enterprise Manager's tree pane shows the structure of the SQL Server environment.
Q:
Microsoft SQL Server databases are created through the Enterprise Manager.
Q:
In Microsoft SQL Server, the check constraint setting ([state] in ("NH", "VT")) for State field in the client table contains one constant and two operators.
Q:
In Microsoft SQL Server, the table status bar displays the number of records in the table, as well as which record and column are currently selected.
Q:
In Microsoft SQL Server, check constraint setting is used to restrict entries for a particular column to a set of specific values.
Q:
In Microsoft SQL Server, each Column in table design view will correspond to a record in table's datasheet view.
Q:
In Microsoft SQL Server, if State field was defined using Nvarchar(2) data type, the most appropriate Default Value for the client table would be NH.
Q:
In Microsoft SQL Server table design view, the Default Value of Nvarchar data type is one of several properties.
Q:
In Microsoft SQL Server, the best way to start creating a new table is by entering data in datasheet view.
Q:
In Microsoft SQL Server, main database window contains a list of available databases, including several system and example databases.
Q:
In Microsoft SQL Server, creating a blank database file for the above case involves starting the server and selecting Databases and choosing quick_tax database.
Q:
In Microsoft SQL Server, the data type for Zip Code field would be Numeric.
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 data type and size for Email field would be Nvarchar(10).
Q:
Social security number is stored in Nvarchar data type.
Q:
Zip code is stored in Numeric data type.
Q:
Nvarchar 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, web screens, and the table relationships below.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:
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 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 Microsoft Access, the statement used to show all employees' social security numbers and names that don"t have jobs assigned to them, would be __.
Q:
In Microsoft Access, the statement used to show all clients' emails and contacts for whom jobs have been done, would be __.
Q:
In Microsoft Access, 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 Microsoft Access, 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 Microsoft Access, 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 Microsoft Access, the statement used to display client emails and contacts, together with all of their job dates and times would be __.
Q:
In Microsoft Access, 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 Microsoft Access, the statement used to show all the different client zip codes, would be __.
Q:
In Microsoft Access, the statement used to calculate the number of clients from each zip code, labeled "Zip Clients", would be __.
Q:
In Microsoft Access, the statement used to calculate the number of clients from NH, labeled as "NH Clients", would be __.
Q:
In Microsoft Access, the statement used to retrieve client's contact with emails that end in "net", from zip codes 03223 and 03264, would be __.
Q:
In Microsoft Access, the statement used to retrieve client's contacts with emails that are not from zip codes 03223 and 03264, would be _.
Q:
In Microsoft Access, the statement used to retrieve client's contacts with emails from zip codes 03223 and 03264 only, would be __.
Q:
In Microsoft Access, the statement used to retrieve client's contacts with emails ending in "net", and from area code 603, would be __.
Q:
In Microsoft Access, the statement used to retrieve client's contacts with emails ending in "net", would be __.
Q:
In Microsoft Access, the statement used to retrieve an employee name and birth date, for an employee with social security number 261284363, would be __.
Q:
In Microsoft Access, the statement used to retrieve all the jobs with JobID over 5, displaying only JobIDs and associated dates, would be __.
Q:
In Microsoft Access, the statement used to retrieve all the client data, ordered first by state and then by zip code would be __.