Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/15

Click to flip

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