SQL Quiz 5 Copy Copy Copy

Which of the following statements are true?

both update and delete are part of DDL
both update and delete can impact the structure of the table
both update and delete are part of DML
both update and delete cannot impact the structure of the table

alter table <table name> drop column <column name>; this query deletes a column

True
False

Which of the following statements are true?

alter and drop are the part of DML
alter and drop cannot impact the structure of the table
alter and drop are the part of DDL
alter and drop can impact the structure of the table

Truncate clause is used to delete complete data from an existing table

True
False

Which of the following statements are correct?

Truncate is a part of DDL
Truncate is same as delete
Truncate is a part of DML
Truncate operations drop and re-create the table

What is the role of operators?

used to review conditions in an SQL statement
used to specify conditions in an SQL statement
both reviewing and specifying the conditions in an SQL statement
none of the above

Which of the following fall under arithmetic operators?

+
–
*
/

“%” is a arithmetic operator

True
False

what is the outcome of the query “Select 5+2”;

Error
5+2
7
#VALUE!

Which of the following is a comparison operator >

!>
+
–
/

Which of the following are comparison operators?

=
>
<=
^

What is the symbol used to specify not in SQL?

$
!
#
*

Which of the following are logical operators?

And
Or
Not
non

Logical operators define what kind of relation the variable have with one another

True
False

Which of the following are valid operators?

Between
is null
Distinct
exists

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

14. Question

15. Question

Leave a Comment Cancel reply