Introduction to SQL Quiz

Which of the following is not an example of RDBMS?

• SQLite

• PostgreSQL

• Oracle

• MySQL

___________ is the most popular query language used by major relational database management systems.

• Database Query Language

• Query Language

• SQL Language

• Structured Query Language

SQL is a case sensitive language. (T/F)

• Not applicable

• Depends on the implementation

• False

• True

Which of the following symbol is used to end SQL statements?

• Comma (,)

• Colon (:)

• Semi Colon (;)

• Period (.)

Identify the odd one out in reference to data type in MySQL.

• Integer

• Char (5)

• Varchar (5)

• String (5)

Which of the following is not correct about data type in MySQL?

• Data type of at least two attributes in a table should be same.

• Arithmetic operations can be performed on numeric data but not on character data.

• The data type of an attribute decides the operations that can be performed on the data of that attribute.

• Data type indicates the type of data value that an attribute can have.

Which of the following is fixed length data type?

• Text

• Varchar(5)

• Char(5)

• Blob

Which of the following is variable length data type?

• None of the above

• Char(5)

• Varchar(5)

• Both of the above

Char(n) specifies character type data of length n where n could be any value from ________.

• 0 to 254

• 0 to 256

• 0 to 255

• 0 to 257

Varchar(n) specifies character type data of length ‘n’ where n could be any value from ____________.

• 0 to 656

• 0 to 65536

• 0 to 65535

• 0 to 655