The command used to verify that all the data was properly inserted is which of the
following?
a) Insert
b) Describe
c) Select
d) Commit
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
In Oracle, the script line that would save all the changes to the database would be which
one of the following?
a) Save changes
b) Save all changes
c) Commit
d) Update changes
After all appropriate columns are checked off, which of the following appears next to
these columns in the query grid of an Update SQL statement?
a) Table from which each column originates
b) Set column with checked or unchecked boxes
c) New Value column with question marks
d) All of the above
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
Setting DetailsView control AutoGenerateDeleteButton property to True will enable us
to do which of the following?
a) Add a new record.
b) Update an existing record.
c) Delete an existing record.
d) Delete an existing column.
Which of the following server controls displays the data in the form of
a table?
a) TableView
b) GridView
c) DataList
d) FormView
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
All of the table maintenance activities performed with DetailsView control can be made
with GridView control, except
a) inserting new records.
b) updating existing records.
c) deleting existing records.
d) All the activities performed with DetailsView can be made with GridView.
The most appropriate data type used to store 349.82 would be which of the following?
a) Number(3,2)
b) Number(4,2)
c) Number(5,2)
d) Varchar(6)
The relationship between an instance of an entity and another instance of the same
entity is an example of which of the following?
a) Relative relationship
b) Recursive relationship
c) Robust relationship
d) Retroactive relationship
The relationship between clients and jobs is which of the following?
a) One-to-one
b) One-to-many
c) Many-to-many
d) Many-to-one
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
ASP Web page is constructed using which of the following?
a) Text and graphics
b) User input and events
c) Data from a database
d) All of the above
Removing a record for a particular job in a normalized design would result in which of
the following?
a) Loss of the job information
b) Loss of the client information
c) Loss of both job and client information
d) Loss of employee information
In Microsoft Access, 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)
Which of the following fields in JobClient table would most likely be split into two
fields?
a) ClientID
b) Name
c) Phone
d) DateTimeStart
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
Omitting a comma between fields in a Create Table statement will generate which of
the following errors?
a) Invalid Identifier
b) Missing or Invalid Option
c) Invalid Column Specification
d) Missing Expression
Which of the following steps in the configuration process of a SqlDataSource server
control represents the main difference between connecting to an Oracle vs. an SQL
Server data source?
a) Connecting to a database
b) Saving the connection to a file
c) Choosing the data provider
d) Configuring the select statement
In Microsoft Access, forcing a change on the primary key to also occur in the foreign
key in a relationship, is provided by which of the following?
a) Enforce Referential Integrity
b) Cascade Update Related Fields
c) Cascade Delete Related Fields
d) Change Joint Type
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
Field value 5/23/2005 most likely belongs to which of the following?
a) Employee birth date
b) Job unique ID
c) Job date
d) Client unique ID
In Microsoft Access, 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”
Number of items left in stock for a particular product displayed on an ASP Web page
most likely come from a(n) __.
In Microsoft Access, the statement used to retrieve an employee name and birth date,
for an employee with social security number 261284363, would be __.
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 __.
In SQL Query Analyzer query design view, the __ is used to enter SQL queries.
In SQL Query Analyzer, the statement used to display client emails and contacts,
together with all of their job dates and times would be __.
Normalized design would place client’s work, home, and cell phone numbers in a __,
together with the ClientID.
List all the attributes in shopping cart table.
__ operation retrieves a subset of columns.
Specialized entities with different attribute lists are often called __ entities.
In Microsoft Access, a concatenated primary key is created in design view by _ all the
component fields and clicking on __ button.
In SQL Query Analyzer, the statement used to retrieve client’s contacts with emails that
are not from zip codes 03223 and 03264, would be _.
In Microsoft Access, validation rule restricting order quantity field entries to positive
numbers, would be specified as __.
In Microsoft Access, the statement used to show all clients’ emails and contacts for
whom jobs have been done, would be __.
In Microsoft Access, the statement used to retrieve client’s contacts with emails that are
not from zip codes 03223 and 03264, would be _.
In Microsoft Access, the statement used to retrieve all of the client’s contacts and emails
would be ___.