Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Exam 70-461

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

By: Alfonso Hernandez
Start Studying

Decks in this class (15)

Chapter 1: Foundations of Querying
How sql server attempts to repres...,
What math areas are based sql 2,
What is the difference between t ...
12  cards
Chapter 2: Getting Started with the SELECT Statement
What are the roles of the from cl...,
Is a good practice type the table...,
What s considered as best practic...
34  cards
Chapter 3: Filtering and Sorting Data
What is a two valued logic 1,
What is a three valued logic 2,
Null null 3
23  cards
Chapter 4: Combining Sets
Does a cross join affect the logi...,
What is a inner join 2,
What is a outer join 3
28  cards
Chapter 5: Grouping and Windowing
What is a grouping set 1,
When a query becomes a grouped qu...,
What does return a grouped query 3
27  cards
Chapter 15: Implementing Indexes and Statistics
How long is a page 1,
How are pages organized 2,
What is the main difference betwe...
10  cards
Chapter 8: Creating Tables and Enforcing Data Integrity
What is a base table 1,
What is a temporary table 2,
What s a table variable 3
49  cards
Chapter 7: Querying and Managing XML Data
What s the difference between att...,
Which clause i need to use for co...,
What s the difference between for...
7  cards
Chapter 9: Designing and Creating Views, Inline Functions, and Synonyms
How to create a view 1,
What are the view options 2,
What are the types of view 3
31  cards
Chapter 10: DML
Why is it recommended to specify ...,
What is the difference between se...,
It s possible insert data with a ...
17  cards
Chapter 12: Manage Transactions, Error Handling & Dynamic SQL
What s a transaction 1,
What s acid 2,
Why is it important for sql serve...
34  cards
Chapter 13: Implementing T SQL Routines
What s a scalar function 1,
What s a table valued function tvf 2,
What are the types of table value...
3  cards
Chapter 6: Querying Full Text Data
How many full text catalogs can h...,
How many full text indexes can ha...
2  cards
JSON
What s the difference between for...,
What does do the include nullvalu...,
What does do the root string subc...
10  cards
Temporal Tables (SQL Server 2016)
What does need a table to be cons...
1  cards

More about
Exam 70-461

  • Class purpose General learning

Learn faster with Brainscape on your web, iPhone, or Android device. Study Alfonso Hernandez's Exam 70-461 flashcards for their INTEC class 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.

Learn more about spaced repetition

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?

70-461
  • 17 decks
  • 934 flashcards
  • 76 learners
Decks: Chapter 1 Foundations Of Querying, Chapter 2 Using The From And Select Clau, Chapter 3 Filtering And Sorting Data, And more!
.DENTAL BOARD EXAM REVIEWER
  • 38 decks
  • 5295 flashcards
  • 1770 learners
Decks: 1 Cellular Anatomy, 2 Cellular Division, 3 Cellular Transport, And more!
Find Flashcards
Make Flashcards
Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions