SQL Programming MCQ - VIDYA VICHAR

Welcome to your SQL Programming MCQ

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

ERASE

DELETE

DROP

REMOVE

None

How can you rename a column in an SQL table?

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

CHANGE TABLE table_name RENAME COLUMN old_name TO new_name

None

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

SELECT * FROM Employees WHERE LastName = 'Smith'

SELECT * FROM Employees WHERE LastName IN 'Smith'

SELECT * FROM Employees WHERE LastName IS 'Smith'

SELECT * FROM Employees WHERE LastName LIKE 'Smith'

None

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

ORGANIZE

SORT

ORDER BY

ARRANGE

None

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

TOTAL

NUMBER

SUM

COUNT

None

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 sorts the result set

It selects values that are not in a specified range

None

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

EDIT

UPDATE

CHANGE

MODIFY

None

What is a foreign key?

A key used to identify a unique record

A key that is always unique

A key that is always null

A key used to link two tables together

None

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

SELECT TOP 5

SELECT LIMIT 5

SELECT FIRST

SELECT FIRST 5

None

10.

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

ALTER

CHANGE

ADD

MODIFY

None

11.

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

MAKE INDEX idx_name IN table_name (column_name)

NEW INDEX idx_name ON table_name (column_name)

ADD INDEX idx_name TO table_name (column_name)

CREATE INDEX idx_name ON table_name (column_name)

None

12.

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

CREATE TABLE

MAKE TABLE

NEW TABLE

ADD TABLE

None

13.

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

INSERT

ADD

CREATE

APPEND

None

14.

Which SQL keyword is used to retrieve only unique values?

UNIQUE

DIFFERENT

ONLY

DISTINCT

None

15.

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

SELECT DISTINCT

SELECT UNIQUE

DELETE DUPLICATES

REMOVE DUPLICATES

None

16.

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 a unique number

A field that stores the primary data

None

17.

Which SQL statement is used to create a stored procedure?

NEW PROCEDURE

ADD PROCEDURE

MAKE PROCEDURE

CREATE PROCEDURE

None

18.

What does the SQL BETWEEN operator do?

It selects values greater than a specified value

It selects values outside a given range

It selects values equal to a specified value

It selects values within a given range

None

19.

Which SQL statement is used to create a view?

CREATE VIEW

MAKE VIEW

NEW VIEW

ADD VIEW

None

20.

What does the SQL LIKE operator do?

It is used to check for null values

It is used to check for equality

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

It is used to sort the result set

None

21.

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

EXTRACT

OPEN

GET

SELECT

None

22.

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

JOIN

UNION

CONNECT

COMBINE

None

23.

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

ADD

TOTAL

COUNT

SUM

None

24.

What is the SQL command to join two tables?

LINK

JOIN

UNION

COMBINE

None

25.

What does SQL stand for?

Simple Query Language

Structured Query Language

Sequential Query Language

Standard Query Language

None

26.

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

WHERE

FILTER

ORDER BY

LIMIT

None

27.

Which SQL statement is used to return the minimum value?

LOWEST

LEAST

BOTTOM

MIN

None

28.

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(DISTINCT Country) FROM Customers

SELECT COUNT(UNIQUE Country) FROM Customers

SELECT DISTINCT COUNT(Country) FROM Customers

None

29.

Which SQL statement is used to return the maximum value?

GREATEST

HIGHEST

MAX

TOP

None

30.

Which SQL statement is used to delete a table?

DROP TABLE

DELETE TABLE

ERASE TABLE

REMOVE TABLE

None

1 out of 3

Thanks for completing SQL Programming MCQ

Full Name

Phone

Time is Up!

Share your love