RegularPython|regular python|Python Theory|Python Videos|Python News|Python Blog|Python Interview Questions

1). What keyword is used to select all columns from a table??

A) SHOW ALL

B) GET ALL

C) SELECT *

D) FETCH *

2). Which SQL statement is used to retrieve data from a database??

A) GET

B) SELECT

C) RETRIEVE

D) EXTRACT

3). How do you sort the results of a query in ascending order??

A) GROUP BY column

B) ORDER BY column ASC

C) SORT BY column

D) ARRANGE column ASC

4). Which clause is used to filter the results of a query??

A) FILTER

B) WHERE

C) HAVING

D) LIMIT

5). What is the default sorting order if not specified??

A) Descending

B) Ascending

C) Alphabetical

D) Numerical

6). Which SQL statement is used to delete all records from a table??

A) DROP table_name

B) TRUNCATE table_name

C) DELETE FROM table_name

D) REMOVE FROM table_name

7). What is the purpose of the JOIN clause??

A) Delete rows from a table

B) Combine rows from two or more tables

C) Update rows in a table

D) Create a new table

8). How can you update data in a specific column of a table??

A) ALTER table_name SET column = value

B) UPDATE table_name SET column = value

C) CHANGE table_name SET column = value

D) MODIFY table_name SET column = value

9). What keyword is used to add a new row to a table??

A) APPEND TO

B) ADD ROW

C) INSERT INTO

D) UPDATE INTO

10). Which statement is used to create a new table in SQL??

A) ADD TABLE

B) NEW TABLE

C) CREATE TABLE

D) MAKE TABLE

11). What is the purpose of the DISTINCT keyword??

A) Sort data

B) Remove duplicate values

C) Limit results

D) Add new columns

12). Which SQL clause is used to limit the number of rows returned??

A) ROW_COUNT

B) LIMIT

C) TOP

D) FETCH

13). How do you find the maximum value of a column??

A) MAX(column_name)

B) HIGHEST(column_name)

C) LARGEST(column_name)

D) TOP(column_name)

14). Which function is used to count the number of rows in a table??

A) SUM(*)

B) COUNT(*)

C) TOTAL(*)

D) NUM(*)

15). What does the SQL statement 'ALTER TABLE' do??

A) Create a new table

B) Modify the structure of an existing table

C) Insert new rows into a table

D) Delete an existing table

16). Which clause is used to sort the results of a query??

A) GROUP BY

B) ORDER BY

C) ARRANGE

D) SORT BY

Online Test