Network database has physical pointers to connect related tables.
In relational databases tables are called tuples.
A relational database handles entities such as persons, places or things by storing each
entity in its own table.
DateTimeStart field in JobClient table could be split into two single value fields.
ASP.NET server controls include dynamic versions of typical HTML
tags.
Specialized type of computers processing requests and returning results are called
clients.
Common Tasks is a feature used to setup data server controls.
Communications protocol allows two computers on the network to exchange messages.
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.
Client
In Microsoft SQL Server, the link between Employee and Job tables is established by
right-clicking on JobID field from the Job table, and in associating it with SSN field of
the Employee table.
Disjoint rule means that an instance of the supertype may belong to several subtype
categories.
The best solution for supertype/subtype hierarchies is to just split the table into two or
more tables, with data about each of the subtypes.
Enable paging will create links to records in the data source.
2NF states that each non-key field must be determined by the whole primary key.
Primary key can be duplicated in as many rows of a table as necessary.
An ASP.NET Web Form is divided into the user interface and
programming logic components.
In Oracle, queries are created in iSQL Plus interface accessible over the Web.
4NF applies to any database table.
Attributes are nouns (people, places, things) such as orders and customers.
In Oracle, the workspace is a user interface where SQL commands are typed and
executed.
The selection retrieval process is implemented using Where clause in the Select
statement.
A dynamic Web page is based on the responses to user inputs and
events related to the page.
We can run the query by clicking on the Play button in SQL Query.
A company’s Web page represents a core technology of its organizational system.
The Where clause must consist of only one condition.
A multivalued determinant is a field or group of fields that determines multiple values
of another field.
A conceptual database model is a description of data that depends on the type of
database software product.
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
The JobClient table shown above is normalized.
In Microsoft Access query design view, the bottom pane rows used to order client’s
contacts (A to Z) and their emails would use Field row for Contact and Email fields,
and Ascending under Contact field in Sort row.
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 23-26, please refer to the preceding paragraph.
Configuring the data source to insert a new record into employee table would use Select
* From employee SQL statement.
Today’s organizations use the Internet as their only computer network.
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 17 – 26, please refer to the preceding paragraph.
Employee is an entity that should be included in the database.
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 Access, the link between Employee and Job tables is established by
dragging SSN field from the Employee table onto JobID field of the Job table.
Supervisors and their subordinates are an example of relative relationship.
Each column in the table must have a unique name.
SQL would be best described as doing which of the following?
a) Allowing the end user to communicate with RDBMS
b) Enabling the database to communicate with RDBMS
c) Allowing RDBMS to communicate with the database administrator.
d) Allowing the RDBMS to communicate with database server hardware.
__ columns in JobClient table contain duplicate data.
In a business, which one of the following is an example of an attribute?
a) John’s employment record
b) All the employees
c) Employee’s addresses
d) This week’s orders
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
Customer/order relationship is an example of
a) one-to-one relationship.
b) one-to-many relationship.
c) many-to-many relationship.
d) difficult relationship.
In Microsoft Access, forcing the removal of a record in the parent table to result in
removal of all related records in the child table, 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
Most appropriate data type for a client’s phone number would be which of the
following?
a) CHAR(7)
b) CHAR(13)
c) NUMBER
d) DATE
In Microsoft SQL Server, in order to create an new empty database, which of the
following option would be used?
a) New database
b) New table
c) New view
d) New database diagram
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
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
Which of the following steps in the con%guration process of a
SqlDataSource server control designates a particular SQL Server
database to connect to?
a) Connecting to a database
b) Saving the connection to a %le
c) Creating a new data connection
d) Choosing the data provider
In Microsoft Access, after adding all three tables to the Relationships 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
After correcting 2NF error for JobClient table, which of the following would be true of
the new table?
a) ClientID would be the primary key and JobID the foreign key.
b) ClientID would be the primary key and Phone the foreign key.
c) JobID would be the primary key and ClientID the foreign key.
d) JobID would be the primary key and Phone the foreign key.
A database server can be best described with which of the following?
a) Provides data to software that resides on application servers
b) Requests data from programs that reside on application servers
c) Sends data to network printers
d) Receives and sends email messages to and from client computers
Which of the following best describes the process of creating a database in Microsoft
Access?
a) Specifying database file, designing tables, and entering data
b) Specifying database file, entering data, and designing tables
c) Designing tables, entering data, and specifying database file
d) Entering data, specifying database file, and designing tables
Which one of the following is(are) the core retrieval operation(s) for relational
databases?
a) Selection
b) Projection
c) Joining
d) All of the above
Setting AutoGenerateEditButton property to True will place which of the following into
DetailsView control?
a) New link
b) Update link
c) Edit link
d) Delete link
Denormalized table designs contain duplicate data.
Custom SQL statement window contains which of the following tabs?
a) Select statement tab only
b) Update, insert, and delete tabs
c) Select, update, insert, and delete tabs
d) Select, update, and insert tabs
Which of the following are employees attributes?
a) Social security number
b) Name
c) Birth date
d) All of the above
Attributes (names, phone numbers, addresses) are like
a) nouns.
b) verbs.
c) adjectives.
d) sentences.
Most appropriate data type for an employee’s social security number would be which of
the following?
a) CHAR(5)
b) NUMBER
c) CHAR(11)
d) DATE
The first step in the basic ASP model is which of the following?
a) Server sends Web Form from the Web server.
b) User requests Web Form from the user’s browser.
c) Web server processes data and returns form to the user’s browser.
d) User enters data and returns form to the Web server.
A database management system is a collection of programs that stores, manages, and
uses data.
ER diagrams use which of the following as a symbol for an entity?
a) Diamond
b) Triangle
c) Box
d) Line
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
Large organizations use private networks to engage in EDI, that stands for which of the
following?
a) Electronic Data Interchange
b) Electric Data Insulation
c) Electronic Data Information
d) Easy Dynamic Interface
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
In SQL Query Analyzer, 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”
Selecting a subset of rows meeting certain conditions is accomplished using which of
the following?
a) Select statement
b) From keyword
c) Where clause
d) Condition keyword
In Microsoft Access, each consecutive order number could be automatically assigned
with each new order using which of the following data types?
a) Number
b) Currency
c) AutoNumber
d) Date/Time
Normal forms allow us to systematically detect duplicate data.
Supervisor relationship is an example of a __ recursive relationship between a
supervisor and his/her subordinates.
Complete the design of the product table in an Oracle database using appropriate SQL
script. Make sure to indicate which of the fields is the primary key.
The property of a data connection indicating Microsoft SQL Server as a data provider is
called __.
In Microsoft Access, the statement used to calculate the number of clients from NH,
labeled as “NH Clients”, would be __.
The developer can enhance script documentation by adding __.
The primary key is identified by typing the words __ after the data type of the
appropriate field.
Equipment supertype and its computer and printer subtypes is an example of __
specialization and __ rule.
Using the above paragraph, list all the fields in the customer table. What would you use
for a primary key?
When changing Mountain Coffee’s phone number in a table with normalized design,
you would have to change the phone number exactly __.
Phone field values with more than one phone number in JobClient table violate __
normal form.
