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 that,

  what is the difference between t sql and,

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

  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 as 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 mandato
  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 fun
  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 st,

  what does full text search allow you to
  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

  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 server b,

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

  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 to c
  41 Cards
  Preview Flashcards
• Chapter 10 Inserting Updating And Deleti

  Chapter 10 Inserting, Updating, and Deleting Data

  Sample Cards:

  what are the 4 ways to insert data into,

  what is the insert values statement,

  with insert values why should you specif
  37 Cards
  Preview Flashcards
• Chapter 11 Other Data Modification Aspec

  Chapter 11 Other Data Modification Aspects

  Sample Cards:

  what is the identity property,

  what do you do when you want to specify,

  what are the functions that you can use
  57 Cards
  Preview Flashcards
• Chapter 12 Implementing Transactions Err

  Chapter 12 Implementing Transactions, Error Handling, and Dynamic SQL

  Sample Cards:

  what is a transaction,

  what do the terms commit and rollback me,

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

  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 t s
  51 Cards
  Preview Flashcards
• Chapter 14 Using Tools To Analyze Perfor

  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 Stat

  Chapter 15 Implementing Indexes and Statistics

  Sample Cards:

  what is a page,

  what is an extent,

  what are the two types of logical struct
  61 Cards
  Preview Flashcards
• Chapter 16 Understanding Cursors Sets An

  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 solu,

  why are set based solutions generally re
  25 Cards
  Preview Flashcards
• Chapter 17 Understanding Further Optimiz

  Chapter 17 Understanding Further Optimization Aspects

  Sample Cards:

  what are iterators,

  if a table is organized as a heap what i,

  what is a table scan
  44 Cards
  Preview Flashcards