User are complaining about the lag time when they run a particular query against Sales database.
After analyzing the query, you find that the data being requested is the sales figures for each client.
What type of object could you create to decrease the query execution time?
A -
view
B -
identifier
C -
index
D -
alert
2-
Using the product operator, if table A has 4 rows and table B has 4 rows, the number of rows in
the product # these two tables is:
A -
4
B -
20
C -
16
D -
8
3-
What is not one of the functions of a database application?
A -
Create Queries
B -
Create Forms
C -
Create Tables
D -
Create Reports
4-
What element of a database is a collection of data in rows and columns?
A -
Datatype
B -
Extents
C -
Table
D -
Pages
5-
What must be installed along with SQL Server 2000 so that Web page developers can access data
by using Xpath query?
A -
SMTP service
B -
IIS service
C -
IPX/SPX
D -
Named pipes
6-
What is the query used to expose when you access data sources over OLE DB?
A -
Rowsets
B -
Columns
C -
Triggers
D -
Indexes
7-
When data changes in multiple lists and all lists are not updated, this causes:
A -
data redundancy
B -
duplicate data
C -
data inconsistency
D -
information overload
8-
When two or more tables are joined, how many times must the keyword WHERE be used?
A -
twice
B -
once
C -
once for each table
D -
not used at all
9-
When primary key of one relation is placed into a second relation, it is called a:
A -
relocated key
B -
candidate key
C -
foreign key
D -
referential integrity
10-
When more than one attribute is used to determine unique tuples within a table, it is called a: