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/10

Click to flip

10 Cards in this Set

  • Front
  • Back
Enterprise Manager
a.Gives permissions
b.gives group permissions
c. run backups
d. restore
e. register instances
f. instances - named instances i.e. server/instance name Larry/curly
Larry/Moe (Installation)
DTS
Data Transformation Wizard
Server Service Manager
Used to start, stop, or modify SQL Server services
Command Prompt Utilities
OSQL
SCM - Service Manager
BCM - Like DTS
DTSRun - Runs existing DTS packaging
System Databases
Master
Temp
Model
MSDB - used to schedule
Where are all temporary tables and stored procedures created by users, as well as temporary worktables used by the relational database engine itself created?
Tempdb
Model
Serves as a template for new databases
MSDB
SQL Server Agent used for scheduling alerts and jobs
Data types
Integer
Bit
Numeric
Money and small money
Date time and small date
Char/var char
Heap
The table is not indexed