A Custom setup type is required to enable Microsoft SQL Server 2000 to use which one of the
following options?
A -
Code samples
B -
Full-text search
C -
SQL Authentication Mode
D -
Local system account
3-
A modern database system (DBS) consists of software, called a database management system
(DBMS), and one or more databases that it manages. A relational database system is composed of: *
A -
Databases
B -
Data Dictionary, tables, rows
C -
Databases, SQL, and tables
D -
Databases, servers, clients, and if needed a network
4-
ABC Manufacturing Corporation is a highly automated industrial company. Most assembly lines
automatically report information to your SQL Server database. Which tools can you use to ectract this
information for reporting to the manufacturing supervisors?
A -
DTS
B -
All of these answer
C -
BCP.EXE
D -
None of these answers
5-
All of the following are advantages of using a database, EXCEPT:
A -
data integrity
B -
data redundancy
C -
flexible use of data
D -
information sharing
6-
An attribute(s) which uniquely determines a tuple within a relation is called a:
A -
Candidate key and Primary key
B -
Foreign key
C -
Candidate key
D -
Primary key
7-
An update trigger typically accesses which of the following?
A -
The inserted and deleted tables
B -
The updated table
C -
Deleted table only
D -
The inserted table only
8-
An online database upgrade allows you to perform which of the following tasks?
A -
Change database locations
B -
Move databases
C -
Copy databases
D -
Change database names
9-
As an independent SQL Server expert, you have been chosen to explain the ER modeling that the
developers will to use to model the needed data and business processes to users of the future loyalty
management system. You decide to define the basic objects of the ER model.
What are they?
A -
Relationship
B -
Attribute
C -
Entity
D -
All of these answers
10-
As a DBA, you want to prevent all the users in the Accounts Receivable department from changing
any data in the Invoice table, but they must still be able to view this data. All these users belong to the
Account role that has SELECT, INSERT, UPDATE, and DELETE reights on the Invoice table.
What can you do?
A -
Excute a GRANT statement that only includes the SELECT permission for these users
B -
Execute a DENY statement to remove all modification rights from these users
C -
Execute a REVOKE statement to remove all rights from these users
