Term
What does SQL statements start and end with? |
|
Definition
It starts with a KEYWORK and ends with a SEMICOLON (;) |
|
|
Term
|
Definition
Rules and guidelines that are unique for SQL |
|
|
Term
Is the SQL statements case sensitive? |
|
Definition
No, unless using MySQL where the statment needs to match what is written in the database. |
|
|
Term
SQL Statement for creating a new database is? |
|
Definition
|
|
Term
Syntax to drop an existing database into SQL schema |
|
Definition
|
|
Term
Syntax to select any existing database to use is? |
|
Definition
|
|
Term
Syntax to create a new table for the sql database is? |
|
Definition
|
|
Term
1) Constraint to use when fields cannot be empty ?
2) Constraint to use when fields can be empty? |
|
Definition
|
|
Term
What is the SQL syntax statement that is used to remove a table definition and all data, indexes, triggers, constraints, and permission specifications for that table? |
|
Definition
|
|
Term
Syntax to add new rows of data to a table? |
|
Definition
|
|
Term
What are the two basic syntax to use with the INSERT INTO statement? |
|
Definition
INSERT INTO TABLE_NAME
and
INSERT INTO TABLE_NAME VALUES |
|
|
Term
1) What is the SQL syntax statement that is used to fetch the data from a database table which returns data in the form of result table?
2) What is the result tables called? |
|
Definition
|
|
Term
What SQL clause is used to specify a condition while fetching the data from single table or joining with multiple tables. |
|
Definition
|
|
Term
1) What is the SQL syntax to combine multiple conditions to narrow data in an SQL statement.
2) What are these two operators called? |
|
Definition
1) AND / OR
2) Conjuctuve Operators |
|
|