This class was created by Brainscape user Cody Smith. Visit their profile to learn more about the creator.
By:
Cody Smith
- decks
- flashcards
- learners
Decks in this class (22)
Temporary Tables and Table Variables
Create a temporary table based on...,
Does a temporary table exist afte...,
Find the name of a temporary tabl...
58
cards
Exercises
Create a computed column in a tab...,
Alter an existing computed column...,
Create a filegroup 3
12
cards
Table Partitions
How is data partitioned in a table 1,
Does the partition key column hav...,
What is the best column to use wh...
19
cards
In Memory OLTP Tables & Natively Compiles SPs
When is it beneficial to use an i...,
When is it beneficial to use a na...,
Do in memory oltp tables have pag...
16
cards
Database Collation
Ci cs 1,
Ai as 2,
Sc 3
9
cards
Columnstores and Sparse Columns
What are columnstore indexes used...,
What is a column store 2,
What is a rowgroup 3
19
cards
Data Control Language Statements
What is the statement to give acc...,
What is the statement to remove a...,
What is the statement to make sur...
3
cards
Execute As
Why use execute as 1,
What is the syntax to execute as 2,
What if you don t want the execut...
4
cards
Security
What is public key cryptography 1,
How do you set up sql server to u...,
What is a loginless user used for 3
20
cards
Design Locking and Granularity levels
What does lock escalation always ...,
What does lock escalation never e...,
What happens if a transaction att...
7
cards
Indexes
How do you force the system to us...
1
cards
Database Normalization
1nf 1,
2nf 2,
3nf 3
11
cards
Database Performance
Performance counter acceptance ov...,
Performance counter acceptance ov...,
Performance counter acceptance ov...
10
cards
CLR
What are the permissions you can ...,
What is safe permission_set 2,
What is external access permissio...
7
cards
Index Creation Errors and Deterministic Functions
Can an index be created on a comp...,
Can an index be created on a comp...,
What is the only string function ...
3
cards
Extra Notes
What is the difference in creatin...,
What is the suitable fillfactor s...,
When should you use pad_index off 3
18
cards
Extra Notes 2
What is necessary to be able to c...,
What are the steps in order to cr...,
What datatype is generated with e...
12
cards
Extra notes 3
How can you use a symmetric key a...,
Can a scalar user defined functio...,
What monitoring application would...
25
cards
Hash Indexes
Where are hash indexes used 1,
What is a hash index 2,
How does a hash index work 3
16
cards
Query Hints
With nowait 1,
With paglockx 2,
With readpast 3
10
cards
Log backups
Backup log database to device no ...,
Backup log database to device wit...,
Backup log database to device wit...
8
cards
Partitioned Views
What is a partitioned view 1,
What version of sql server is tab...,
What can be done in standard edit...
13
cards
More about
70-464 Certification
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study Cody Smith's 70-464 Certification 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?
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!
Examen de certification
- 43 decks
- 2237 flashcards
- 13 learners
Decks:
Semaine 1 Pre Analytique, Semaine 1 Organisation Generale Du Labo, Semaine 2 Affection Hepatobiliaire, And more!
National Medical Interpreter Certific...
- 58 decks
- 2468 flashcards
- 849 learners
Decks:
General Medical Terms Related Useful Ter, Common Non Medical Terms Used In Healthc, Symptomatology, And more!
