Each Microsoft SQL Server 2000 database is compsed of two types of files. These files are
A -
Data file and Transaction log file
B -
Primary data file and Secondary data file
C -
Data File and File Group
D -
None of these answers
2-
For which task in SQL would you use an IN clause
A -
To query the database for a character pattern
B -
To query the database for a range of value
C -
To query the database for unknown values
D -
To query the database for values in a specified list
3-
For database systems needing to support approximately 2 trillion bytes of data within an
organization, which type of database would be appropriate?
A -
workgroup database
B -
Internet database
C -
personal database
D -
organizational database
4-
Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements
would be used to add new student data to the STUDENT table?
A -
INPUT DATA STUDENT SET StudentID=123, Name=’Jones’.Advidor =’Smith’:
B -
INSERT DATA STUDENT VALUES (123, ’Jones’. ’Smith’):
C -
INPUT DATA STUDENT (123, ’Jones’, ’Smith’):
D -
INSERT DATA STUDENT SET StudentID=123, Name=’Jones’.Advidor =’Smith’:
5-
Given the New Whatcom Library Checkout List shown above, if Some Good Fiction is lost and
must be removed from the list, all information about Sara Jones will also be removed.
This is an example of a ____.
A -
data inconsistency problem
B -
data deletion problem
C -
missing data problem
D -
data addition problem
6-
Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements
would be used to change the value of the Advisor field to ’Smith’ for all rows in the STUDENT table?
A -
UPDATE STUDENT SET Advisor = ’Smith’:
B -
MODIFY Advisor SET STUDENT = ’Smith’:
C -
UPDATE Advisor = ’Smith’:
D -
MODIFY STUDENT SET Advisor = ’Smith’:
7-
Given the New Whatcom Library Checkout List shown above, if a new book named Still
MoreGood Fiction is purchased by the library it will not appear in the list until it is checked out.
This is an example of a ____.
A -
missing data problem
B -
data deletion problem
C -
data inconsistency problem
D -
data addition problem
8-
Given the New Whatcom Library Checkout List shown above, is Sam Archer’s card is lost and the
card number shown must be replaced we must be careful to change each occurrence of the number or else
we will have a ____.
A -
data deletion problem
B -
data inconsistency problem
C -
data deletion problem
D -
data addition problem
9-
Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance), what is the standard SQL
query phrase to retrieve data for cusromers with an account balance greater than 50?
A -
HAVING AcctBalance > 50
B -
WHERE CUSTOMER-AcctBalance > 50
C -
WHERE AccBalance > 50
D -
WHERE(CUSTOMER-AcctBalance > 50)
10-
How do you find out what triggers have already been created?
