Applications
Create Database Syntax ans: CREATE DATABASE db_name;
Simple SFW query syntax ans: SELECT * FROM db_name WHERE column_name operator value;
Cardinality: Inside or outside? ans: Outside
Modality: Inside or outside? ans: Inside
What commands are used with data definition? ans: create, alter, drop, truncate, comment, rename
What commands are used with data manipulation? ans: Select, Insert, Update, Delete, Merge, Call,
Explain Plan, Lock Table
Create Table Syntax ans: CREATE TABLE table_name
(
column_name1 data_type(size),
column_name2 data_type(size),
);
What does AUTO_INCREMENT attribute do for numeric values? ans: It generates a series of unique
identifier values.
CREATE VIEW SYNTAX ans: CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition
Primary Key Syntax ans: CREATE TABLE table_name
(
column1 data_type(size)
PRIMARY KEY (column1)
);
Create Index Syntax ans: CREATE INDEX index_name
ON table_name(column_name)
Insert syntax ans: INSERT INTO table_name
VALUES (value1,value2,value3,...);
Grant command syntax ans: GRANT privileges ON object TO user;
Drop Syntax: Table, Index, Database ans: DROP TABLE table_name;