3NF states that none of the non-key fields can determine another non-key field.
Web browser is an example of a software that performs server processes.
GridView server control is used to display data in the form of a table.
For each particular record that is being examined, the Where clause evaluates either to
True or False.
In Microsoft Access, the validation rule “NH” Or “VT” for State field in the client table
contains one constant and two operators.
DBA stands for database authorization.
Application servers hold application software that implements the business logic of an
organization.
In Microsoft SQL Server, main database window contains a list of available databases,
including several system and example databases.
In Oracle, each complete statement ends in a semicolon.
Selection, projection, and joining are the three core data retrieval operations for
relational databases.
For each particular record that is being examined, the Where clause evaluates either to
True or False.
The selection retrieval process is implemented using Where clause in the Select
statement.
There are six normal forms, with each of the lower normal forms encompassing the
higher normal forms.
Email field would be set as the primary field for the client table.
Social security number is the primary key for employee table.
Crow’s feet at the both ends of a line represent a many-to-many relationship.
Aggregate functions operate on a set of fields rather than a single field.
Primary key from parent table and foreign key from child table do not have to have the
same data type.
The types of joins most widely used are the so-called outer joins.
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.
In Oracle, the script line used to enter the first record into the client table would be:
insert into client (“dentpro@comcast.net”, “Dentist Pros’, “James Tucker”, “63 Elm
Street”, “Manchester”, “NH”, “03308”, “(603)774-6698”)
There are four entities that should be modeled in the ER diagram.
When the Delete link in DesignView is tested, the links to records at the bottom of the
control will decrease by one.
2NF violation can only occur on tables that have primary keys defined using a single
field.
Database design is a model of the data items and their interrelationships.
Senior consultant mentors and the more junior consultants that are being mentored
should be separated in two different tables.
Microsoft SQL Server databases are created through the Enterprise Manager.
Entities are adjectives (name, address, phone number) that describe an attribute such as
a customer.
Set Echo On statement is used to display script results.
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).
Drop Table command is typically placed at the bottom of the script.
Job date is the primary key for job table.
Values of numeric fields must be enclosed in single quotation marks.
Tables designed to be free of duplicate data are called association tables.
Query builder allows us to use either graphical interface when building a query or a
place to write SQL statements to accomplish the same.
In Microsoft Access Relationships window, there is a direct link between Client and
Employee tables.
In the Microsoft Access main database window, which of the following is used for
creating questions and getting answers out of the database?
a) Tables
b) Queries
c) Forms
d) Reports
Which of the following is the most appropriate candidate for primary key in job table?
a) Job unique ID
b) Job date
c) Job description
d) Employee social security number
The size of character (text) data type is measured in
a) number of significant digits.
b) number of decimal places.
c) number of characters.
d) number of words.
A Web Form is divided into which of the following?
a) Visual and graphical components
b) Visual and programming logic components
c) Server and programming logic components
d) Code and programming logic components
Configure data source step of configuring DetailsView server control allows us specify
how to retrieve data using which of the following?
a) A custom SQL statement or stored procedure
b) Specifying columns from a table
c) Specifying columns from a query
d) All of the above
Recognizing that all the client’s tax returns have some attributes in common, and that
some are specific to the client’s business situation (industry, ownership structure, etc.)
would be represented in a database using which of the following?
a) One-to-many recursive relationship
b) Many-to-many recursive relationship
c) Supertype/subtype hierarchy
d) One table with a special field
A list of QuickTax employee birth dates would be an example of a
a) record.
b) primary key.
c) field.
d) table.
Which of the following would be true of the new table with phone client’s phone
numbers?
a) ClientID would be the primary key and Phone the foreign key.
b) Phone would be the primary key and ClientID the foreign key.
c) ClientID and Phone would combine to form a primary key.
d) ClientID and Phone would combine to form a foreign key.
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.ID 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#
For subqueries, which of the following statements is correct?
a) Inner queries execute last and outer queries execute first
b) Inner queries execute at the same time as outer queries
c) Inner queries execute first and outer queries execute last
d) Inner queries execute independently of outer queries
Clients, employees, and jobs are all examples of
a) people.
b) records.
c) entities.
d) fields.
In SQL Query Analyzer, 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 __.
Inserting new client information into the JobClient table is not possible without
specifying which of the following?
a) JobID
b) ClientID
c) DateTimeStart
d) DateTimeEnd
Supervisor relationship is an example of which of the following?
a) One-to-many relationship
b) One-to-many recursive relationship
c) Many-to-many relationship
d) Many-to-many recursive relationship
In SQL Query Analyzer, 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)
In the relationship between Client and Job tables, which of the following fields in Job
table is the foreign key?
a) JobID
b) Email
c) SSN
d) Date
Modeling the relationship between client’s tax returns and tax forms requires which of
the following?
a) Separating tax returns and tax forms into two tables
b) Listing all the required tax forms for a given return in a single table using several
different fields
c) Listing all the required tax forms for a given return in a single table using a single
additional field
d) Modeling this relationship does not require any action at all
A series of SQL commands designed to automate tasks is called a(n)
a) command set.
b) sequence.
c) script.
d) auto task.
Which of the following would be selected in order to display Select Client * From
Client code in Microsoft Access?
a) Query design view
b) Query datasheet view
c) Query SQL view
d) Form design view
Complex Where clauses typically involve several conditions and use which of the
following logical operators?
a) +, -, *, /
b) =, <, >, <=, >=, !=
c) And, Or
d) Like, Unlike
Complex Where clauses typically involve several conditions and use which of the
following logical operators?
a) +, -, *, /
b) =, <, >, <=, >=, !=
c) And, Or
d) Like, Unlike
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
For subqueries, which of the following statements is correct?
a) Inner queries execute last and outer queries execute first.
b) Inner queries execute at the same time as outer queries.
c) Inner queries execute first and outer queries execute last.
d) Inner queries execute independently of outer queries.
Many-to-many relationships are represented by a
a) parent table.
b) child table.
c) sibling table.
d) third table.
Computer applications enable organizations to achieve which of the following?
a) Hit required profit margins
b) Replace workers with computers
c) Streamline business processes
d) Eliminate operational expenses
In Microsoft Access, inserting links between Client and Job tables, as well as Employee
and Job table, establishes which other relationship?
a) One-to-one Client-Employee relationship
b) One-to-many Client-Employee relationship
c) Many-to-many Client-Employee relationship
d) No additional relationship is established
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
Correcting 2NF violation in JobClient table would involve which of the following?
a) Just deleting one of the inconsistent records
b) Creating Job table with a record for each job date/time
c) Creating a Phone table with a record for each phone
d) Doing nothing at all
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
__.
The relationship between employees and jobs is which of the following?
a) One-to-one
b) One-to-many
c) Many-to-many
d) Many-to-one
The command __ is used to verify that the tables were properly created.
Discuss how the violation of BCNF might potentially occur in this example.
The command __ is used to destroy the database.
In Oracle, the statement used to retrieve all the client data, ordered first by state and
then by zip code would be __.
In Microsoft Access, the statement used to show all the different client zip codes, would
be __ .
The relationship between a tax return and all of its component tax forms is a __
recursive relationship.
In SQL Query Analyzer, the statement used to retrieve client’s contacts with emails
from zip codes 03223 and 03264 only, would be __.
In a relational database, rows in a table are called __.
Complete the design of the vehicle table in an Oracle database using appropriate SQL
script. Make sure to indicate which of the fields is the primary key.
Relationships are like __; they are acts of possession.
Design the query that retrieves the flowers (from A to Z) that bloom in early spring, last
more than three days.
__ operation retrieves a subset of rows.
According to the Web screens provided, describe how a typical transaction might occur.
RDBMS is a software that prevents unauthorized access to a__.
SQL is a command language that allows __ to communicate with a database.
Complete the design of the line item table in an Oracle database using appropriate SQL
script. Make sure to indicate which of the fields is the primary key.