Advanced Level (A- Level) Computer Science (Databases) Flashcards on Database, created by TS P on 01/01/2016.
|
Created by TS P
over 8 years ago
|
|
Close
|
|
Created by TS P
over 8 years ago
|
|
Drawbacks of file based databases?
How do RDBMS attempt to correct file based systems' weaknesses
What is a logical schema and what is it intended for?
How do data dictionaries in DBMS help address data management issues found in file based systems?
What are developer Interfaces and Query processors and why are they used?
What is referential integrity, secondary key and indexing?
Criterias for 1NF, 2NF and 3NF?
What's the difference between Data Definition Language (DDL) and Data Manipulation Language (DML).
Create database syntax?
Create table syntax?
Changing table definition syntax?
Add a primary key after table definition?
Group by functions?
Syntax for inner join?
what do the fields after the SELECT clause represent?
INSERT INTO syntax
DELETE FROM syntax?
UPDATE syntax?
How do DBMS avoid data clashes
