Computer Applications (Commerce) - XII Chapter 9 : Structured QueryLanguage

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Student Name *

School name *

1. Which is not a Components of SQL *

1 point

Data Definition Language (DDL)

Data Manipulation language (DML

Programming Language (PL)

Data Control Language (DCL)

2. SQL is *

1 point

programming language.

an operating system

data sublanguage.

DBMS

3. ______ command is used to open a database *

1 point

OPEN

CREATE

USE

SELECT

4. _________ represents variable length strings *

1 point

VARCHAR

STRING

CHAR

VCHAR

5. The rules enforced on data that are entered into the column of a table *

1 point

Query

Key

Constraints

Relation

6. Which constraint ensures that no two rows have the same value in the column ? *

1 point

AUTO_INCREMENT

NOT NULL

UNIQUE

DEFAULT

7. _____ keyword is used in SELECT query to eliminate duplicate values in a column *

1 point

UNIQUE

DISTINCT

NOT NULL

PRIMARY

8. ____ clause of SELECT query is used to apply condition to group of records. *

1 point

order by

having

group by

where

9. ____ command in SQL is used to display the structure of a table *

1 point

LIST

STRUCT

DESCRIBE

SHOW

10. Which of the following is used to add row into a table? *

1 point

INSERT INTO

MAKE

CREATE

ADD

11. which is an essential key word with SELECT command *

1 point

Set

Value

From

12. The _____operator is used to specify the range of values *

1 point

BETWEEN...AND

13.SELECT name FROM student WHERE name LIKE '%ar'; the o/p will be *

1 point

Selecting all names starting with 'ar'

Selecting all names ending with 'ar'

Selecting all names contains 'ar''

None of these

14. Which operator is used to check for NULL value in a column? *

1 point

NOT

15. Which clause is used for sorting ? *

1 point

SORT BY

ORDER BY

ASC

ORDER

16. What is the default sort order of the ORDER BY clause? *

1 point

ascending order

descending

None

17. The ____ aggregate functions to find average values in the column . *

1 point

AVG()

SUM()

MIN()

COUNT()

18. The _______ command changes the values in one or more columns of specified rows *

1 point

SELECT

UPDATE

CREATE

ALTER TABLE

19. DDL command ______ used to modify the structure of a table *

1 point

CREATE

MODIFY

UPDATE

ALTER TABLE

20. Which clause is used to remove an existing column from a table, *

1 point

REMOVE

DELETE

DROP

MODIFY

21. Name the command used to remove table from a database . *

1 point

DROP

REMOVE

DELETE FROM

DROP TABLE

22 Pick odd one out *

1 point

SELECT

DELETE FROM

ALTER TABLE

INSERT INTO

23. _____is a virtual table that does not really exist in the database *

1 point

DATABASE

RECORD

RELATION

VIEW

24. The SQL operator ________ is used with pattern matching. *

1 point

None of these

25. Which of the following is the correct order of clauses for the SELECT statements? *

1 point

SELECT , FROM , ORDER BY , WHERE

SELECT , FROM , WHERE , ORDER BY

SELECT , WHERE , FROM , ORDER BY

SELECT , WHERE , ORDER BY , FROM

Type your valuable Suggestion about this Quiz

After Selecting answer of all question,press "SUBMIT" button and press "View Score" Button to know your Score and correct answers

Submit

Clear form

Never submit passwords through Google Forms.

This content is neither created nor endorsed by Google. - Terms of Service - Privacy Policy

Does this form look suspicious? Report

Forms