Top Database Flashcards

Cards: 59| Attempts: 0| Last updated: Sep 16, 2015

What Methods Available To Prevent Illegal Acc...

Limit Privileges To Access Date Use Operatin...

What Syntax Is Used To Create An Account?

Created By Using The Command CREATE USER Use...

Authenticated User Means ...

The User Has A Valid Account And Provided The...

Creating User Accounts And Granting Privilege...

The DBA

Subqueries

Cards: 34| Attempts: 0| Last updated: Sep 16, 2015

What Are The 4 Rules To Keep In Mind While Wo...

1. A Subquery Must Be A Complete Query In It...

When Can A Single-row Subquery Be Used?

When The Results Of The Outer Query Are Based...

What Kind Of Subquery Would You Use If Only O...

Single Subquery

Which Query Is Executed First When Using A Su...

The Inner Query Is Returned First And Then Th...

Cards: 17| Attempts: 0| Last updated: Sep 22, 2015

Database Management System (DMBS)

Interface B/w Database & Various Applicat...

Database System

Combo Of Database, DBMS, & App Programs T...

Data Warehouse

Very Large Databases

Data Mining

Process Of Analyzing Data Repositories For Ne...

Cards: 36| Attempts: 0| Last updated: Sep 18, 2015

Spreadsheet

Not As Interactive, Single Themed If The Lis...

Database

Self Describing Collection Of Integrated Rec...

Primary Key

Unique Identifier, Every Table Has A Key

Foreign Key

Same Name Of Primary Key In Another Table