Combining data from different tables into a single result set is called performing a join.
Updating records could be a problem caused by denormalized design.
Today’s organizations are heavily dependent on computer systems.
The Like operator could be used to retrieve all the clients in a particular area code.
Partial specialization means that some instances of supertype do not belong to any of
the subtype categories.
DetailsView control property AutoGenerateInsertButton should be set to False in order
to be able to insert records into the data source.
A family of products with a number of common attributes and a number of
product-specific properties is an example of supertype/subtype hierarchy.
The relationship between a client’s tax return and all of its required tax forms is a
many-to-many recursive relationship.
Zip code is stored in Number data type.
Inserting new client information without an actual job assignment is possible in the
denormalized design.
Setting AutoGenerateDeleteButton property to True will place __ link into DetailsView
control.
Conguring data source is done by specifying an appropriate SQL
statement.
In a query with a subquery, outer subquery always executes first.
Cartesian product is a temporary table that combines all rows in one table with all rows
in another table.
Object-oriented databases are easier to use than relational databases.
Bill of materials is an example of a generalization/specialization hierarchy.
Setting AutoGenerateEditButton property to True will place __ link into DetailsView
control.
Fourth-Generation Languages like SQL
a) are procedural and record oriented.
b) require significant amount of looping.
c) are nonprocedural and table oriented.
d) are oriented towards processing binary code.
In Microsoft Access, 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#
ASP.NET is the Microsoft development environment that allows us to
do which of the following?
a) Develop static Web pages that consist of text and graphics.
b) Develop dynamic Web applications that interact with the user.
c) Design Web databases and manage their content.
d) Design desktop-based applications that interact with databases.
The extension of the programming logic Web Form component le is
which one of the following
a) aspx
b) asp.net
c) aspx.vb
d) vb.net
ASP.NET Web Form is built using which of the following?
a) Standard HTML tags
b) ASP.NET server controls
c) HTML tags and ASP.NET server controls
d) Text boxes, tables, radio buttons and list boxes
For the employee (consultant) entity, which of the following is true?
a) Consultant is the parent but not the child entity.
b) Consultant is both the parent and the child entity.
c) Consultant is the child but not the parent entity.
d) Consultant is neither the parent nor the child entity.
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 53-56, please refer to the preceding paragraph.
Configuring the data source to select all the fields from employee table would use
which SQL statement?
a) Select * From employee
b) Insert Into employee (ssn, name, bdate) Values (?,?,?)
c) Update employee Set name = ?, bdate = ? Where ssn = ?
d) Delete From employee Where ssn = ?
Major components of Web Developer is(are) which of the following?
a) An ASP page
b) Solution Explorer
c) Properties window
d) All of the above
Students registering for courses is an example of
a) one-to-one relationship.
b) one-to-many relationship.
c) many-to-many relationship.
d) many-to-one relationship.
The relationship between employees and clients is which of the following?
a) One-to-one
b) One-to-many
c) Many-to-many
d) Many-to-one
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.
Inserting a child record that does not have a matching parent record will generate which
of the following errors?
a) Orphan Cannot Exist Without Parents
b) Integrity Constraint Violated ” Parent Name Not Found
c) Integrity Constraint Violated ” Parent Key Not Found
d) Integrity Constraint Violated ” Parent Table Does Not Exist
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
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”
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
When Edit link is tested in the browser, DetailsView control does which of the
following?
a) Displays a list of empty textboxes for all fields except the primary key
b) Displays the Update link that executes the Update SQL statement
c) Displays the Cancel link that allows us to stop the update operation
d) All of the above
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.
JobClient table design is which of the following?
a) Normalized
b) Denormalized
c) Centralized
d) Decentralized
In SQL Query Analyzer, 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.jobdate, 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.jobdate, 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.jobdate, job.timestart, job.timeend From employee Inner
Join job Where job.timestart = #8:00 AM#
d) Select employee. name, job.jobdate, job.timestart, job.timeend From employee, job
On employee.ssn = job.ssn Where job.timestart = #8:00 AM#
In Microsoft Access, which one of the following is used to save sets of instructions for
retrieving database data?
a) Queries
b) Forms
c) Macros
d) Modules
Enable paging property of DetailsView control allows us to do which of the following?
a) Browse through the columns of the data source.
b) Browse through the fields of the data source.
c) Browse through the records of the data source.
d) Browse through the files of the current record.
Deleting the record with JobID 7 in the JobClient table would result in which of the
following?
a) Loss of the job information
b) Loss of the client information
c) Loss of the job and client information
d) Loss of the employee information
Query builder allows us to create queries using which of the following?
a) Only by writing SQL statements
b) Only by graphically designing the query
c) Both by writing SQL statements or by graphically designing the query
d) By going through a query wizard that builds the query for us
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*”
A company’s organizational system core technology is(are) its
a) Web pages.
b) database system.
c) fax machine.
d) personal computer.
All the information we want to store about QuickTax clients will become a
a) record in a database.
b) field in a database.
c) table in a database.
d) primary key in a database.
Which of the following fields in JobClient table violates 3NF?
a) JobID
b) ClientID
c) Name
d) Phone
SQL implements selection, projection, and joining operations using which of the
following?
a) SQL statement
b) Select statement
c) From keyword
d) Retrieval statement
In Microsoft Access, after adding all three tables to the Relationships 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
Each field in a table takes values from a certain permissible set of values. This set is
often referred to as
a) data type.
b) cardinality.
c) foreign key.
d) domain.
In Microsoft Access, assurance that the values of primary and foreign key in a
relationship will match, is provided by which of the following?
a) Enforce Referential Integrity
b) Cascade Update Related Fields
c) Cascade Delete Related Fields
d) Change Join Type
SQL implements selection, projection, and joining operations using which of the
following?
a) SQL statement
b) Select statement
c) From keyword
d) Retrieval statement
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
The foreign key in employee/consultant table establishing the recursive relationship
between consultant mentors and mentored would be denoted as __.
The foreign key in jobs table in relation to client table should be __.
In Oracle, the statement used to retrieve client’s contacts with emails from zip codes
03223 and 03264 only, would be __.
A relationship where one record in a primary table corresponds to several records in
another table is called __ relationship.
Information systems include people, policies, computers, and __.
Each child table must have a __ that relates it to its parent table.
Query grid helps us by placing a skeleton __ into the query grid.
In Oracle, the statement used to retrieve an employee name and birth date, for employee
with social security number 261284363, would be __.
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.
In a relational database, entities are represented as __.
In Oracle, the statement used to calculate the number of clients from each zip code,
labeled “Zip Clients”, would be __.
Discuss how the violation of BCNF might potentially occur in this example.
In the Create Table statement, each of the field names is followed by the appropriate __
and separated from other fields by a __.
In Microsoft Access query design view, the __ row is used to select the columns to be
included in the query.
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.
List all the entities for Exotic Flower, and describe their relationships with other
entities.
The server control used to access a Microsoft SQL Server database qtax is _.