Practice Sql Server Multiple Choice Questions with Answers Quiz-1

Q.1.

What is a field?

A collection of information
A single item of information
A list of information
A group of records

Q.2.

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

COUNT()
NUMBER()
SUM()
COUNT(*)

Q.3.

What does the ALTER TABLE clause do?

The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints
The SQL ALTER TABLE clause is used to insert data into database table
THE SQL ALTER TABLE deletes data from database table
The SQL ALTER TABLE clause is used to delete a database table

Q.4.

What do the letters in CRUD stand for?

Create Read Update Delete
Craft Run Upload Database
Create Run Unrun Data
Crunch Read Uptime Downtime

Q.5.

A UNION query is which of the following?

Combines the output from multiple queries and does not include the same number of columns.
Combines the output from multiple queries and must include the same number of columns.
Combines the output from no more than two queries and does not include the same number of columns.
Combines the output from no more than two queries and must include the same number of columns.

Q.6.

SQL views can be used to hide?

Complicated SQL syntax
Rows
Columns
All of the above

Q.7.

The SQL SELECT statement is capable of

Projection
Selection
Protection & Security
Both A & B

Q.8.

Embedded SQL is which of the following?

The process of making an application capable of generating specific SQL code on the fly.
Hard-coded SQL statements in a trigger.
Hard-coded SQL statements in a program language such as Java.
Hard-coded SQL statements in a procedure.

Q.9.

The arranging of data in a logical sequence is called

Summarizing
Classifying
Sorting
Rearranging

Q.10.

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

Insert Into
Add New
Insert Record
Add Record

Q.11.

A database is used to

store data
modify data
extract data
All of the above

Q.12.

Which of the following statements is true concerning subqueries?

Does not start with the word SELECT.
Involves the use of an inner and outer query.
Cannot return the same result as a query that is not a subquery.
All of the above

Q.13.

AND, OR and NOT are examples of

Clauses
Boolean operators
Conjuctive operators
Exclusive operators

Q.14.

In sql the spaces at the end of the string are removed by

LTrim
Upper
Trim
Lower

Q.15.

What is the correct order of clauses in a SQL statement?

SELECT, FROM, ORDER BY, WHERE
SELECT, FROM, WHERE, ORDER BY
SELECT, WHERE, FROM, ORDER BY
WHERE, FROM, SELECT, ORDER BY

Q.16.

What is Insert command in SQL?

The INSERT INTO statement is used to insert new records in a table.
The INSERT INTO statement is used to insert new column in a table.

Q.17.

How would you display Chairs in the Items table that have a Price greater than £50.

SELECT * FROM Items WHERE Type = 'Chair' AND Price > 50
SELECT * FROM Items WHERE Type = 'Chair' OR Price < 100
SELECT * FROM Iterms WHERE Type = 'Chair' AND Price >= 50
SELECT * FROM Items WHERE Price > 50

Q.18.

The UPDATE SQL clause can _____________

update only one row at a time
update more than one row at a time
delete more than one row at a time
delete only one row at a time

Q.19.

SQL query to find the temperature in increasing order of all cities.

SELECT city FROM weather ORDER BY temperature
SELECT city, temperature FROM weather
SELECT city, temperature FROM weather ORDER BY temperature
SELECT city, temperature FROM weather ORDER BY city

Q.20.

Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70
SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70
SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70
SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70

Support mcqgeeks.com by disabling your adblocker.