SQL Programming MCQ - VIDYA VICHAR

Welcome to your SQL Programming MCQ

Which SQL keyword is used to fetch the first 5 records from a table?

SELECT FIRST

SELECT LIMIT 5

SELECT TOP 5

SELECT FIRST 5

None

Which SQL statement is used to create a view?

MAKE VIEW

CREATE VIEW

NEW VIEW

ADD VIEW

None

What is a primary key?

A field that is a foreign key

A field that uniquely identifies each record in a table

A field that stores the primary data

A field that stores a unique number

None

How do you select all the records from a table named "Employees" where the "LastName" is "Smith"?

SELECT * FROM Employees WHERE LastName IS 'Smith'

SELECT * FROM Employees WHERE LastName IN 'Smith'

SELECT * FROM Employees WHERE LastName = 'Smith'

SELECT * FROM Employees WHERE LastName LIKE 'Smith'

None

Which SQL statement is used to return the maximum value?

MAX

HIGHEST

GREATEST

TOP

None

What is the SQL command to remove duplicates from a result set?

REMOVE DUPLICATES

DELETE DUPLICATES

SELECT DISTINCT

SELECT UNIQUE

None

Which SQL keyword is used to sort the result-set?

SORT

ORGANIZE

ARRANGE

ORDER BY

None

What is a foreign key?

A key used to identify a unique record

A key that is always null

A key used to link two tables together

A key that is always unique

None

What does the SQL BETWEEN operator do?

It selects values outside a given range

It selects values within a given range

It selects values greater than a specified value

It selects values equal to a specified value

None

10.

Which SQL statement is used to return the minimum value?

LOWEST

LEAST

MIN

BOTTOM

None

11.

Which SQL clause is used to filter the results returned by a query?

ORDER BY

WHERE

LIMIT

FILTER

None

12.

Which SQL statement is used to combine the results of two or more SELECT statements?

JOIN

UNION

CONNECT

COMBINE

None

13.

What does SQL stand for?

Simple Query Language

Standard Query Language

Sequential Query Language

Structured Query Language

None

14.

Which SQL function is used to find the total sum of a numeric column?

SUM

ADD

COUNT

TOTAL

None

15.

What does the SQL IN operator do?

It allows you to specify multiple values in a WHERE clause

It checks if a value is null

It selects values that are not in a specified range

It sorts the result set

None

16.

Which SQL statement is used to insert new data into a database?

ADD

APPEND

CREATE

INSERT

None

17.

Which SQL function is used to count the number of rows in a table?

TOTAL

NUMBER

SUM

COUNT

None

18.

How do you return the number of unique values in the "Country" column in a table named "Customers"?

SELECT UNIQUE(Country) FROM Customers

SELECT COUNT(UNIQUE Country) FROM Customers

SELECT DISTINCT COUNT(Country) FROM Customers

SELECT COUNT(DISTINCT Country) FROM Customers

None

19.

Which SQL statement is used to extract data from a database?

SELECT

GET

OPEN

EXTRACT

None

20.

What is the SQL command to join two tables?

COMBINE

LINK

JOIN

UNION

None

21.

Which SQL statement is used to create a stored procedure?

ADD PROCEDURE

CREATE PROCEDURE

NEW PROCEDURE

MAKE PROCEDURE

None

22.

What does the SQL LIKE operator do?

It is used to search for a specified pattern in a column

It is used to check for null values

It is used to check for equality

It is used to sort the result set

None

23.

How can you rename a column in an SQL table?

CHANGE TABLE table_name RENAME COLUMN old_name TO new_name

RENAME TABLE table_name RENAME COLUMN old_name TO new_name

MODIFY TABLE table_name RENAME COLUMN old_name TO new_name

ALTER TABLE table_name RENAME COLUMN old_name TO new_name

None

24.

What is the correct SQL statement to create a new table?

NEW TABLE

MAKE TABLE

CREATE TABLE

ADD TABLE

None

25.

Which SQL statement is used to update data in a database?

CHANGE

MODIFY

UPDATE

EDIT

None

26.

Which SQL statement is used to delete data from a database?

DROP

DELETE

ERASE

REMOVE

None

27.

Which SQL keyword is used to retrieve only unique values?

DISTINCT

UNIQUE

DIFFERENT

ONLY

None

28.

Which SQL statement is used to delete a table?

REMOVE TABLE

ERASE TABLE

DROP TABLE

DELETE TABLE

None

29.

What is the correct syntax to create an index in SQL?

ADD INDEX idx_name TO table_name (column_name)

CREATE INDEX idx_name ON table_name (column_name)

MAKE INDEX idx_name IN table_name (column_name)

NEW INDEX idx_name ON table_name (column_name)

None

30.

Which SQL keyword is used to add a new column to a table?

CHANGE

ADD

ALTER

MODIFY

None

1 out of 3

Thanks for completing SQL Programming MCQ

Full Name

Phone

Time is Up!

Share your love