Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

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,
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...,
Whats considered as best practice...
34  cards
Chapter 3: Filtering and Sorting Data
What is a two valued logic,
What is a three valued logic,
Null null
23  cards
Chapter 4: Combining Sets
Does a cross join affect the logi...,
What is a inner join,
What is a outer join
28  cards
Chapter 5: Grouping and Windowing
What is a grouping set,
When a query becomes a grouped query,
What does return a grouped query
27  cards
Chapter 15: Implementing Indexes and Statistics
How long is a page,
How are pages organized,
What is the main difference betwe...
10  cards
Chapter 8: Creating Tables and Enforcing Data Integrity
What is a base table,
What is a temporary table,
Whats a table variable
49  cards
Chapter 7: Querying and Managing XML Data
Whats the difference between attr...,
Which clause i need to use for co...,
Whats the difference between for ...
7  cards
Chapter 9: Designing and Creating Views, Inline Functions, and Synonyms
How to create a view,
What are the view options,
What are the types of view
31  cards
Chapter 10: DML
Why is it recommended to specify ...,
What is the difference between se...,
Its possible insert data with a s...
17  cards
Chapter 12: Manage Transactions, Error Handling & Dynamic SQL
Whats a transaction,
Whats acid,
Why is it important for sql serve...
34  cards
Chapter 13: Implementing T SQL Routines
Whats a scalar function,
Whats a table valued function tvf,
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
Whats the difference between for ...,
What does do the include_null_val...,
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?

Exam 70-461
  • 8 decks
  • 20 flashcards
  • 1 learners
Decks: Joins, Table Designs, Views, And more!
MCSA 70-740
  • 4 decks
  • 220 flashcards
  • 157 learners
Decks: 1 Install Windows Server In Host And Com, 2 Implement Storage Solutions, 3 Implement Hyper V, And more!
RACP Written Exam
  • 22 decks
  • 956 flashcards
  • 148 learners
Decks: Haematology, Statistics, Monoclonal Antibodies Novel Therapy, And more!
Find Flashcards
Make Flashcards
Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions