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-
...
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;
ALTER TABLE table_name DROP INDEX index_name;
DROP DATABASE database_name
Count() Syntax Ans- SELECT COUNT(column_name) FROM table_name;
returns # of values in a column
SELECT COUNT(*) FROM table_name; returns number of records in a table
Inner Join Description Ans- Returns all rows when there is at least one match in BOTH tables
Left Join Description Ans- Return all rows from the left table, and the matched rows from the right table
Right Join Description Ans- Return all rows from the right table, and the matched rows from the left
table
Full Join Description Ans- Return all rows when there is a match in ONE of the tables
Join Syntax Ans- SELECT columns
FROM table1
INNER/LEFT/RIGHT/FULL JOIN table2
ON table1.column = table2.column;
IN description & syntax Ans- allows you to specify multiple values in a WHERE clause
SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...);
LIKE description & syntax Ans- Used to search for a specified pattern in a column
SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern
[Show More]
.png)
.png)
