preview

Nt1330 Final Paper

Decent Essays

1:
Utilizing SQL Server 2000, which of the accompanying symbols is utilized to demonstrate parameters in stored systems?
A.
! B.
#
C.
$ D.
@
2:
Which of the accompanying is an approach to make and change tables utilizing SQL Server?

A. Write SQL code utilizing either CREATE or ALTER SQL proclamations just.
B. Use the graphical facilities of SQL Server Enterprise Manager just.
C. Both of them will work.
D. Neither of them will work.
3:
SQL Server 2000 put away methods can:
A. never kept inside of the database.
B. be kept inside of the database and conjured by application programs.
C. be put away on the users' PC.
D. support BEFORE, INSTEAD OF and AFTER sorts.
4:
SQL Server automatically makes a list on:
A. primary keys just.
B. foreign …show more content…

A. Differential recovery
B. Complete recovery
C. Simple recovery
D. Bulk-logged recovery
7:
Which of the three possible sorts of triggers does SQL Server support?
A. INSTEAD OF just
B. AFTER just
C. BEFORE just
D. INSTEAD OF and AFTER just
8:
With this kind of index, the information are put away in the base level of the index and in the same request as that index.

A. Nonclustered
B. Clustered
C. Primary
D. None of above
9:
Using SQL Server 2000, which of the accompanying makes a copy of changes that have been made to the database since the last finish backup?
A. Full backup
B. Transaction Log
C. Differential backup
D. None of the above is right.
10:
With which sort of SQL Server recovery model are all database changes logged?
A. Complete recovery
B. Differential recovery
C. Simple recovery
D. Bulk-logged recovery
11:
SQL Server 2000 stored systems can:
A. never kept inside the database.
B. be kept inside the database
C. be stored on user' PC.
D. support BEFORE, INSTEAD OF and AFTER sorts.
12:
1. What number of methods for returning information is available in SQL Server 2000

Get Access