All of the table maintenance activities performed with DetailsView control can be
accomplished with GridView control except __ records.
Using the above Web screens, list all the fields in shopping cart table. Make sure to
correctly identify the primary key.
__ operation retrieves a subset of columns.
Forms are used to __ data into a database.
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.
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 ____.
In JobClient table, 1NF is violated by __ field.
List all foreign keys in appropriate tables.
_ servers provide data to the software that resides on __ servers.
Generalization/specialization hierarchies are also called __ hierarchies.
Design the query that shows all the vehicles not currently booked. Include vehicle ID,
make, type, and rental rate.
In Microsoft SQL Server, a concatenated primary key is created in design view by _ all
the component fields and clicking on __ button.
When using the New link button to insert a new record, another screen is presented with
__ and __ links.
In Oracle, the script line used to enter the first record into the client table, would be: __
An __ table is a child of two parent tables that are in a many-to-many relationship.
Applications servers hold application software that implements the __ of an
organization.