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 _.
Storing one client phone number in a client table and the same phone number in an
employee table will cause ___.
In Microsoft Access, setting up a state or city field in the customer table for a database
user to choose from would be best accomplished using which of the following data
types?
a) Text
b) Yes/No
c) OLE Object
d) Lookup Wizard
Modeling consultant mentors and consultant being mentored requires which of the
following?
a) Separating mentors and mentored into two separate tables
b) Another non-key Mentored? yes/no indicator field
c) Another foreign-key CONSULTANT$Mentored field
d) No action is needed to model this relationship.
In a client/server architecture, server is a computer that
a) initiates requests for printing of a document.
b) presents the content of a shopping cart.
c) returns the data needed to display a Web page.
d) performs the search of a local hard drive.
In Microsoft SQL Server creating a table structure is accomplished using which of the
following?
a) Diagrams
b) Tables
c) Views
d) Stored procedures
Databases are designed as a group of related
a) entities.
b) attributes.
c) relationships.
d) fields.
Which one of the following is a typical Web Form control and an
associated event?
a) Button, Update
b) Drop-down list, Delete
c) Text box, Change
d) Label, Click
In Oracle, the script line used to design the client table would be which of the
following?
a) Design table client
b) Setup table client
c) Create table client
d) Build table client
RDBMS can be described as doing which of the following?
a) Provides end user with unrestricted access to data and procedures
b) Prevents authorized end users from accessing data and procedures
c) Provides authorized end users with restricted access to data and procedures
d) Provides unauthorized users with restricted access to data and procedures
In SQL Query Analyzer, 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.jobdate, job.timestart, job.timeend From employee, job
Where employee.ssn = job.jobid
b) Select employee. name, job. jobdate, job. timestart, job. timeend From employee
Inner Join job On employee.ssn = job.ssn
c) Select employee. name, job. jobdate, job. timestart, job. timeend From employee.ssn
Inner Join On job.ssn
d) Select employee. name, job. jobdate, job. timestart, job. timeend From employee
Inner Join job On employee = job
The server control used to access a Microsoft SQL Server database is
which of the following?
a) SqlDataSource
b) AccessDataSource
c) ObjectDataSource
d) XmlDataSource
Oracle’s Web-based SQL interface is called which one of the following?
a) SQL*Plus
b) iSQL*Plus
c) SQL*iPlus
d) SQL script
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 Oracle, the script line used to define the foreign key for the job table in the
relationship with the client table would be which of the following?
a) Email char(30) refers to client(email)
b) Jobid Number refers to client(jobid)
c) Email char(30) references client(email)
d) Email char(30) links to client(email)
In Oracle, the statement used to show all employees’ social security numbers and names
that don”t have jobs assigned to them, would be _
In Microsoft Access, the statement used to display employee names together with all of
their job dates and times would be which one of the following?
a) Select Employee.Name, Job.Date, Job.TimeStart, Job.TimeEnd From Employee, Job
Where Employee.SSN = Job.SSN
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
In the relationship between Employee and Job tables, which of the following fields in
Job table is the foreign key?
a) JobID
b) Email
c) SSN
d) Date
GridView task used to associate the grid with the existing data source
is which of the following?
a) New data source
b) Open data source
c) Choose data source
d) Con0gure data source
An email program is an example of a software that does which of the following?
a) Initiates request for incoming email
b) Sends your email to appropriate address
c) Stores all your deleted emails
d) Sends emails to your inbox
The most appropriate data type used to store social security numbers would be which of
the following?
a) Varchar(9)
b) Char(9)
c) Number(9,2)
d) Date
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 __.
Which one of the following is not likely to appear on Amazon’s order screen.
a) Customer name
b) Order detail
c) Credit card info
d) Item inventory
Child table must have
a) its own primary key.
b) a foreign key connecting it to the parent table.
c) a common field with the parent table.
d) all of the above.
Which of the following is an example of a primary key?
a) Customer’s last name
b) Vehicle identification number
c) Vendor’s zip code
d) Product’s inventory level
Which of the following data sources typically does not require user
authentication?
a) Microsoft SQL Server
b) Microsoft Access Database
c) Oracle Database
d) Microsoft ODBC Data Source
Having multiple phone numbers in a Phone field violates which of the following normal
forms?
a) 1NF
b) 2NF
c) 3NF
d) BCNF
Setting DetailsView control AutoGenerateEditButton property to True will enable us to
do which of the following?
a) Add a new record.
b) Update an existing record.
c) Add a new field.
d) Delete a column.
In Microsoft Access, the most appropriate data type for a field indicating whether the
order has been shipped or not would be which of the following?
a) Text
b) Yes/No
c) OLE Object
d) Lookup Wizard
For years, QuickTax, Inc. has helped small businesses manage their taxes. The
management has 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 employees’ 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 44 – 56, please refer to the preceding paragraph.
In a relational database for QuickTax, data on all the clients would be stored in a
a) record.
b) field.
c) table.
d) primary key.
Which of the following is an example of a many-to-many recursive relationship?
a) Students and courses they are taking
b) Courses and their prerequisites
c) Products and their components
d) Orders and products that are purchased
The data for all character string fields must be enclosed in which of the following?
a) Single quotes
b) Double quotes
c) Parentheses
d) Brackets
DBA is the person who
a) runs the RDBMS.
b) grants database access to end users.
c) maintains the database using RDBMS.
d) All of the above.
__ operation retrieves a subset of rows.
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.
List all foreign keys in appropriate tables.
Describe the nature of supertype/subtype hierarchy in this case (if any) and discuss how
it would be modeled in the ER diagram for this database.
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 __.
Use __ SQL statement to configure the data source to insert a new record into employee
table.
List and/or construct primary keys for each of the tables.
Complete the design of the order table in an Oracle database using appropriate SQL
script. Assume that any necessary parent tables have been created. Make sure to
indicate which of the fields is the primary key and which fields are the foreign keys.
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 __.
Entities are like __; they are persons, places, or things.
In Oracle, the statement used to show all the different client zip codes, would be __ .
Bill of materials is an example of a __ recursive relationship between a product and its
components.
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 __.
List all foreign keys in appropriate tables.