T-SQL Transaction

This class was created by Brainscape user Shawn Peronto. Visit their profile to learn more about the creator.

Decks in this class (14)

Chapter 5 Grouping and Windowing
What is a window function,
What does count col1 return when ...,
What is the general form for a pi...
71  cards
Chapter 7 Querying and Managing XML Data
What is xquery,
What are elements,
What are tags
81  cards
Chapter 8 Creating Tables and Enforcing Data Integrity
What is the main method used for ...,
How do tables work with the sql s...,
What are the system tables
77  cards
Chapter 9 Designing and Creating Views, Inline Functions, and Synonyms
What are views,
How do you create a view,
Does the create view statement ha...
46  cards
Chapter 10 Inserting, Updating, and Deleting Data
What are the 4 ways to insert dat...,
What is the insert values statement,
With insert values why should you...
37  cards
Chapter 11 Other Data Modification Aspects
What is the identity property,
What do you do when you want to s...,
What are the functions that you c...
57  cards
Chapter 12 Implementing Transactions, Error Handling, and Dynamic SQL
What is a transaction,
What do the terms commit and roll...,
What does the acid acronym stand for
98  cards
Chapter 13 Designing and Implementing T-SQL Routines
What is a stored procedure,
What types of stored procedures d...,
What are the important features o...
50  cards
Chapter 14 Using Tools to Analyze Performance
What is the relational engine,
What is the storage engine,
What are the 4 query execution ph...
43  cards
Chapter 15 Implementing Indexes and Statistics
What is a page,
What is an extent,
What are the two types of logical...
61  cards
Chapter 16 Understanding Cursors, Sets, and Temporary Tables
What is meant by the term set based,
What is meant by the term iterati...,
Why are set based solutions gener...
25  cards
Chapter 17 Understanding Further Optimization Aspects
What are iterators,
If a table is organized as a heap...,
What is a table scan
44  cards
XML
What are the four modes of xml,
What is the difference between xm...,
What is well formed xml
23  cards
Temporal Tables
When were temporal tables impleme...,
What table elements are necessary...,
Recite a table create statement f...
10  cards

More about
T-SQL Transaction

  • Class purpose General learning

Learn faster with Brainscape on your web, iPhone, or Android device. Study Shawn Peronto's T-SQL Transaction flashcards now!

How studying works.

Brainscape's adaptive web mobile flashcards system will drill you on your weaknesses, using a pattern guaranteed to help you learn more in less time.

Add your own flashcards.

Either request "Edit" access from the author, or make a copy of the class to edit as your own. And you can always create a totally new class of your own too!

What's Brainscape anyway?

Brainscape is a digital flashcards platform where you can find, create, share, and study any subject on the planet.

We use an adaptive study algorithm that is proven to help you learn faster and remember longer....

Looking for something else?

T-SQL
  • 1 decks
  • 27 flashcards
  • 2 learners
Decks: Beginning T Sql, And more!
MSSQL Exam 70-461: Querying Microsoft...
  • 17 decks
  • 934 flashcards
  • 120 learners
Decks: Chapter 1 Foundations Of Querying, Chapter 2 Using The From And Select Clau, Chapter 3 Filtering And Sorting Data, And more!
T Level Health
  • 20 decks
  • 682 flashcards
  • 116 learners
Decks: A1, A2, A3, And more!
T-SQL
  • 5 decks
  • 89 flashcards
  • 3 learners
Decks: Data Modification, Temporal Tables, Transactions, And more!
Make Flashcards