Quiz - XII CS

您的瀏覽器尚未啟用 JavaScript，因此無法開啟檔案。請於啟用後重新載入頁面。

Quiz - XII CS

Chapter 9 - Structured Query Language(SQL)

登入 Google 即可儲存進度。瞭解詳情

1. Which of the following command is used to view the structure of a table ? *

1 分

SHOW TABLES

DESC

SELECT

DISPLAY

2. Which is the keyword used with SELECT command to avoid duplication of rows in the selection *

1 分

DISTINCT

WHERE

FROM

3. Pick the odd one out *

1 分

WHERE

ORDER BY

GROUP BY

UPDATE

4. The SQL statement, DELETE FROM Employee; *

1 分

deletes the 'employee' field value

delete all the tuples from the relation 'employee'

delete some specific tuples from the relation 'employee'

delete some attributes from the relation 'employee'

5. MODIFY clause is used with ALTER command *

1 分

for altering the definition of an existing column

for adding the definition of a new column

for modifying the data value of an existing column

for deleting the data value of an existing column

6. The command used to edit the structure of a table is *

1 分

UPDATE

ALTER TABLE

DROP TABLE

DELETE

7. Which of the following operator is used to check for NULL value in a column ? *

1 分

NOT

8. The operator used for checking pattern matching is .......... *

1 分

NOT

9. Which statement is used to insert new data into a table? *

1 分

ADD RECORD

INSERT RECORD

INSERT INTO

INSERT ROW

10. Which command is used to delete the table *

1 分

DELETE TABLE

DROP TABLE

DELETE FROM

DROP FROM

11. ................. command is used to make a database active. *

1 分

SHOW

DESC

USE

STRUCT

12. Which statement is used to extract data from a database? *

1 分

SELECT

EXTRACT

GET

SHOW

13. With SQL how can you return all items in the 'Items' table sorted from the lowest price to the highest price? *

1 分

SELECT * FROM Items ORDER BY Price ASCENDING;

SELECT * FROM Items ORDER BY Price ;

SELECT * FROM Items BY Price LOWEST TO HIGHEST;

SELECT * FROM Items ORDER BY Price DESC;

14. Choose the correct one *

1 分

Table constraints can be used only on individual columns

Table constraints can be used on a group of columns

Table constraints cant not be used with columns

All of these

15. Examples of DML commands are *

1 分

INSERT

DELETE

UPDATE

all of these

16. A HAVING clause place conditions on ..................... in contrast to WHERE clause that places conditions on ......... *

1 分

groups, individual rows

individual rows, groups

single row, single column

single column,single row

17. The default sort order for ORDER BY clause is *

1 分

Descending

Ascending

no default order

none of these

18. NOT NULL constraint specifies that *

1 分

a column can have NULL values

a column can never have NULL values

a column can have UNIQUE values

a column can never have UNIQUE values

19. The SQL statement, SELECT name from STUDENT WHERE name LIKE '%Kumar' ; *

1 分

gives a list of names in STUDENT table that start with the substring 'Kumar'

gives a list of names in STUDENT table that end with the substring 'Kumar'

gives a list of names in STUDENT table that contains 'Kumar'

none of these

20.Which of the following is the correct order of clauses for the SELECT command ? *

1 分

SELECT,FROM,WHERE,ORDER BY

SELECT, FROM, ORDER BY, WHERE

SELECT, WHERE, FROM, ORDER BY

SELECT, ORDER BY, FROM , WHERE

21. When a VIEW is dropped, it..............................the base table *

1 分

will affect

will not affect

may affect

none of these

22. A VIEW is a virtual table that does not really exist in the database, but can be operated like any other table *

1 分

True

False

23. ......................... clause is used with ALTER TABLE command to renaming a table. *

1 分

RENAME

RENAME TO

MODIFY

CHANGE

24. Generally aggregate functions take a collection of values and return *

1 分

a set of values

a subset

a single value

nothing

25. ____ is an SQL data type which is used to represent variable length string. *

1 分

CHAR

VARCHAR

STRING

DECIMAL

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

提交

清除表單

Google 並未認可或建立這項內容。檢舉濫用情形 - 服務條款 - 隱私權政策

表單