Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
15 Cards in this Set
- Front
- Back
Which clause in the CREATE CERTIFICATE statement specifies the password that will be used to encrypt private key of the certificate?
|
ENCRYPTION BY PASSWORD
|
|
What is the syntax for specifying the four-part name to qualify an object presnt on a linked server?
|
linked_server_name.catalog.schema.object
|
|
On which editions of Win 2003 can you install SQL 2005 Enterprise?
|
Windows Small Business Server 2003 Premium SP1, Small Business Standard, Datacenter, Enterprise, Windows 2003 Server SP1
|
|
Which protocol is enabled by default?
|
TCP/IP
|
|
How should trans logs files and filegroups by placed to minimize contention?
|
on different disks
|
|
Which wizard will be used to move or copy databases and their objects from one server to another?
|
The COPY Database wizard
|
|
Which stored procedure is used to map a local user account to an account on a remote server?
|
The sp_AddLinkedSrvLogin
|
|
Which SQL Server 2005 edition can be installed on Win 2003 web edition?
|
Express
|
|
Which clause in the CREATE CERTIFICATION statement specifies the user who owns the certificate?
|
AUTHORIZATION clause
|
|
Which recovery model logs minimum data into transaction log in a bulk-import operation?
|
Bulk-logged Recovery model
|
|
Which sql version cannot be installed on XP?
|
Enterprise
|
|
Which type of encryption is faster and best for frequent data transfer?
|
symmetric encryption
|
|
Which encryption uses only one key for both encryption and decryption?
|
symmetric encryption
|
|
Which port does sql listen on for incomming connections by default?
|
1433
|
|
Which protocol was developed specially for LANs?
|
Named Pipes
|