Databases - SQL 1

What is the full form of SQL?

• Structured Query List

• Structure Query Language

• Sample Query Language

• None of these.

Which of the following is not a valid SQL type?

• FLOAT

• NUMERIC

• DECIMAL

• CHARACTER

Which of the following is not a DDL command?

• TRUNCATE

• ALTER

• CREATE

• UPDATE

Which of the following are TCL(Transaction Control Commands) command?

• COMMIT and ROLLBACK

• UPDATE and TRUNCATE

• SELECT and INSERT

• GRANT and REVOKE

Which statement is used to delete all rows in a table without having the action logged?

• DELETE

• REMOVE

• DROP

• TRUNCATE

SQL Views are also known as

• Simple tables

• Virtual tables

• Complex tables

• Actual Tables

How many Primary keys can have in a table?

• Only 1

• Only 2

• Depends on no of Columns

• Depends on DBA

Which datatype can store unstructured data in a column?

• CHAR

• RAW

• NUMERIC

• VARCHAR

Which of the following is not Constraint in SQL?

• Primary Key

• Not Null

• Check

• Union

Which of the following is not a valid aggregate function?

• COUNT

• COMPUTE

• SUM

• MAX