Exam 70-461: Querying Microsoft SQL Server 2012 Flashcards

Decks in this Class (17):

• Chapter 1 Foundations Of Querying

  Chapter 1 Foundations Of Querying

  Sample Cards:

  what are the mathematical branches th...,

  what is the difference between t sql and,

  what is a predicate
  22 Cards
  Preview Flashcards
• Chapter 2 Using The From And Select Claus

  Chapter 2 Using The From And Select Clauses

  Sample Cards:

  what is implicit schema name resolution,

  how do you alias a queried table,

  why is the asterisks a bad practice a...
  88 Cards
  Preview Flashcards
• Chapter 3 Filtering And Sorting Data

  Chapter 3 Filtering and Sorting Data

  Sample Cards:

  what are the 3 query clauses that enable,

  what is two valued logic,

  what is three valued logic
  44 Cards
  Preview Flashcards
• Chapter 4 Combining Sets

  Chapter 4 Combining Sets

  Sample Cards:

  what is database normalization,

  what is a cross join,

  in a self join is table aliasing mand...
  54 Cards
  Preview Flashcards
• Chapter 5 Grouping And Windowing

  Chapter 5 Grouping and Windowing

  Sample Cards:

  what is a data analysis function,

  when does a query become a grouped query,

  what happens when you invoke a group ...
  71 Cards
  Preview Flashcards
• Chapter 6 Querying Full Text Data

  Chapter 6 Querying Full-Text Data

  Sample Cards:

  what is full text search,

  what are the prerequisites before you...,

  what does full text search allow you ...
  39 Cards
  Preview Flashcards
• Chapter 7 Querying And Managing Xml Data

  Chapter 7 Querying and Managing XML Data

  Sample Cards:

  what is xquery,

  what are elements,

  what are tags
  81 Cards
  Preview Flashcards
• Chapter 8 Creating Tables And Enforcing D

  Chapter 8 Creating Tables and Enforcing Data Integrity

  Sample Cards:

  what is the main method used for storing,

  how do tables work with the sql serve...,

  what are the system tables
  78 Cards
  Preview Flashcards
• Chapter 9 Designing And Creating Views In

  Chapter 9 Designing and Creating Views, Inline Functions, and Synonyms

  Sample Cards:

  what are views,

  how do you create a view,

  does the create view statement have t...
  41 Cards
  Preview Flashcards
• Chapter 10 Inserting Updating And Deletin

  Chapter 10 Inserting, Updating, and Deleting Data

  Sample Cards:

  what are the 4 ways to insert data in...,

  what is the insert values statement,

  with insert values why should you spe...
  37 Cards
  Preview Flashcards
• Chapter 11 Other Data Modification Aspect

  Chapter 11 Other Data Modification Aspects

  Sample Cards:

  what is the identity property,

  what do you do when you want to speci...,

  what are the functions that you can u...
  57 Cards
  Preview Flashcards
• Chapter 12 Implementing Transactions Erro

  Chapter 12 Implementing Transactions, Error Handling, and Dynamic SQL

  Sample Cards:

  what is a transaction,

  what do the terms commit and rollback...,

  what does the acid acronym stand for
  98 Cards
  Preview Flashcards
• Chapter 13 Designing And Implementing T S

  Chapter 13 Designing and Implementing T-SQL Routines

  Sample Cards:

  what is a stored procedure,

  what types of stored procedures does sql,

  what are the important features of a ...
  51 Cards
  Preview Flashcards
• Chapter 14 Using Tools To Analyze Perform

  Chapter 14 Using Tools to Analyze Performance

  Sample Cards:

  what is the relational engine,

  what is the storage engine,

  what are the 4 query execution phases
  43 Cards
  Preview Flashcards
• Chapter 15 Implementing Indexes And Stati

  Chapter 15 Implementing Indexes and Statistics

  Sample Cards:

  what is a page,

  what is an extent,

  what are the two types of logical str...
  61 Cards
  Preview Flashcards
• Chapter 16 Understanding Cursors Sets And

  Chapter 16 Understanding Cursors, Sets, and Temporary Tables

  Sample Cards:

  what is meant by the term set based,

  what is meant by the term iterative s...,

  why are set based solutions generally...
  25 Cards
  Preview Flashcards
• Chapter 17 Understanding Further Optimiza

  Chapter 17 Understanding Further Optimization Aspects

  Sample Cards:

  what are iterators,

  if a table is organized as a heap wha...,

  what is a table scan
  44 Cards
  Preview Flashcards