PreTrainingSQL

What does SQL stand for?

• Structured Question Language

• Storage Qualifier Language

• Structured Query Language

• Storage Quantity Limit

Which commands are part of the TCL sublanguage?

• INSERT

  UPDATE

  DELETE

• CREATE

  ALTER

  DROP

• COMMIT

  ROLLBACK

  SAVEPOINT

• GRANT

  REVOKE

  AUDIT

Which commands are part of the DML sublanguage?

• INSERT

  UPDATE

  DELETE

• CREATE

  ALTER

  DROP

• COMMIT

  ROLLBACK

  SAVEPOINT

• GRANT

  REVOKE

  AUDIT

Which commands are part of the DDL sublanguage?

• INSERT

  UPDATE

  DELETE

• CREATE

  ALTER

  DROP

• COMMIT

  ROLLBACK

  SAVEPOINT

• GRANT

  REVOKE

  AUDIT

Which of the following is NOT an SQL sublanguage?

• DDL

• DML

• TCL

• DCL

• TCP

SELECT * FROM employees;

What does the above statement return?

• nothing

• all records from the employees table

• the * column from the employees table

• a list of column names from the employees table

which of the following is NOT true about Primary Keys?

• Primary Keys are Unique

• Primary Keys are not nullable

• Primary Keys identify a specific table

• Primary Keys identify a specific entry in a table