Which of the following is not a basic component of a database system?
A -
User
B -
Database
C -
ERD
D -
DBMS
2-
Which utility can be used to transfer data from an Access database to SQL Server?
A -
BCP.EXE
B -
BULK INSERT with a format file
C -
DTS
D -
BULK INSERT
3-
Which of the following is the correct technique for representing a MSS:N relationship in the
relational model?
A -
An intersection relation is created and the key of either entity is placed as a key in both the intersection relation and in the other relation
B -
An intersection relation in created and the keys of both parent entities are placed as a composite key in the intersection relation
C -
An intersection relation is created with a surrogate key, which is placed in each of the parent entities
D -
The key from either relation is placed as a foreign key in the other relation
4-
The catalog maintained by
A -
the DBMS
B -
the database administrator
C -
the author of the tables in the database
D -
the user
5-
Why is the option WITH ENCRYPTION useful for triggers?
A -
It requires a password to use the trigger
B -
None of these answers
C -
It gives the user the option of using encryption on the table data via the triggers
D -
It causes the triggers text to be encrypted when placed in syscomments so that any user selecting off syscomments or using sp_helptext cannot view the triggers script
6-
You are comparing Windows authentication and SQL Server authentication. Which one of the
following statements about SQL Server authentication is false?
A -
Complex passwords cannot be enforced
B -
User names and passwords are always transmitted in clear text
C -
No account lockout policies can be set
D -
A maximum password age cannot be set
7-
The component of a databse that makes it self-describing is the:
A -
data set
B -
metadata
C -
related tables
D -
library
8-
You are building a rent-a-car tracing #
A -
Add the CarID attribute to the Agreements entity with a FOREIGN KEY constraint referencing the Cars entity
B -
Add an INSERT trigger to the rental entity
C -
Add a CHECK constraint to the AgreementID attribute
D -
Add the AgreementID attribute to the Cars entity with a FOREIGN KEY constraint referencing the Agreements entity
