Query Quest - External

TEAM NAME

GM ID

COLLEGE NAME

Which of the following is not a valid SQL type?

• FLOAT
• NUMERIC
• DECIMAL
• CHARACTER

Which of the following are TCL commands?

• COMMIT and ROLLBACK
• UPDATE and TRUNCATE
• SELECT and INSERT
• GRANT and REVOKE

SQL Views are also known as

• Simple tables
• Virtual tables
• Complex tables
• Actual Tables

Which datatype can store unstructured data in a column?

• CHAR
• RAW
• NUMERIC
• VARCHAR

Which of the following is true about the SQL AS clause?

• The AS clause in SQL is used to change the column name in the output or assign a name to a derived column.
• The SQL AS clause can only be used with the JOIN clause.
• The AS clause in SQL is used to defines a search condition.
• All of the mentioned.

Which statement is true regarding routines and triggers?

• Both run automatically.
• Both are stored in the database.
• Both consist of procedural code.
• Both have to be called to operate.

Which of the following is the correct order of a SQL statement?

• SELECT, GROUP BY, WHERE, HAVING
• SELECT, WHERE, GROUP BY, HAVING
• SELECT, HAVING, WHERE, GROUP BY
• SELECT, WHERE, HAVING, GROUP BY