Save
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account. Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

IST-278 Unit1

Unit 1 Flashcards for 278

TermDefinition
Model Database DP Serves as a template for any other database, a required database. Any future database created has to be at least as large as the model. DP
tempdb database DP One of the key working areas for SQL Server, storage for temp tables DP
Transaction log DP Place where initial changes to a database are written in serial order. The log accumulates changes that are deemed as having been committed. DP
Checkpoint DP The point in time that all changes in the log are propagated to the actual database file(s) and the log is cleared. DP
Actual database file or Physical database file DP After checkpoint is issued changes from the log are propagated here. DP
Index DP An object that exists only within the framework of a particular table or view. An index works much like the index does in the back of a book. DP
Cluster index DP Can only have one per table; a table with a clustered index is physically sorted according to that index. DP
Trigger DP An object that exists only within the framework of a table (database object). Triggers are pieces of code that are executed when certain things happen to the table (database object) that they are associated with. The things that can trigger triggers to
Secondary files DP 32,000 files that can be added to the primary filegroup. Secondary data files are optional, are user-defined, and store user data. Secondary files can be used to spread data across multiple disks by putting each file on a different disk drive. Additionall
View DP Sometimes called a virtual table. It is basically a stored query (a preplanned mapping and representation of the data stored in tables). DP
Stored procedure DP An ordered series of transact - SQL statements bundled into a single logical unit. They allow for variables and parameters as well as selection and looping constructs. They offer several advantages over just sending individual statements to the server (l
User defined functions DP Similar to stored procedures except that it can return a value and cannot have "side effects". Can return a value of most SQL Server data types. DP
User DP Equivalent of logins; object represents an identifier for someone to login into the SQL server. DP
Role DP Users belonging to a group that are granted rights to perform certain actions in SQL server. A user can belong to one or more roles. DP
Constraint DP Restriction information about what can go into a table. DP
[ ] (square brackets) DP Are used for any names that are the same as SQL Server keywords or contain embedded spaces. DP
Query analyzer DP A tool that existed in SQL Server 2000. It provided a user interface in which T-SQL statements could be written and executed. DP
Management Studio DP A tool introduced with SQL Server 2005 that replaced query analyzer and enterprise manager. It is where you can execute T-SQL statements and perform numerous database management tasks. DP
Query Optimizer DP Part of SQL Server that figures out best way to run a query to balance fast results with minimum impact to other users. DP
Created by: phillipsdr
Popular Computers sets

 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards