SQL Quiz 3 Copy

1. Question

Which of the following are numeric data types?

Int
Money
Decimal
Char

2. Question

Which of the following are character data types?

Char
Float
Varchar
Text

3. Question

Which of the following is a date and time data type?

XML
Datatimesmall
Timestamp
Datetime

4. Question

Vertical portions in SQL tables are known as

Range
Column
Row
None of the Above

5. Question

Horizontal portions in SQL tables are known as

Sheet
Column
Row
None of the Above

6. Question

Which of the following is the correct syntax to create a database named “cars”

Create DB cars;
Make DB cars,
Create database cars;
make database cars,

7. Question

“Create” is the keyword which is used to make a database and it is a part of data manipulation language

True
False

8. Question

After creating a database named “cars” what is the syntax that has to be used to access the database

deploy cars;
alter database cars;
use cars;
use database cars;

9. Question

In SQL every query ends with?

;
:
,
.

10. Question

Queries are to be typed in?

Administrator
Navigator
History and output
Query editor

11. Question

What is query used to display entire content of a table?

select * ;
select * from table_name;
select all from table_name;
select * from table_name in database_name;

12. Question

Which of the following about keyword Char?

represents a logical type
stores variable-length string data
stores only fixed-length character string data
significant or memorable word or term in the title

13. Question

Which of the following about keyword Varchar?

represents a logical type
stores variable-length string data
stores only fixed-length character string data
significant or memorable word or term in the title

14. Question

What kind of database management system does SQL fall under

Hierarchical DBMS
Network DBMS
Relational DBMS
Object oriented DBMS

15. Question

Which of the following is true about SQL?

SQL has a interactive interface
SQL creates visuals
SQL is object oriented program language
SQL is a domain specific language

Quiz Summary

Information

Results