Questions and answers for exam Preparation

MCQs

Total Questions : 109 | Page 8 of 11 pages

Question 71. The result of a SQL SELECT statement is a ________ .

file
report
table
form

Discuss Question

Answer: Option C. -> table

Question 72. In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

all columns of the table are to be returned.
all records meeting the full criteria are to be returned.
all records with even partial criteria met are to be returned.
None of the above is correct.

Discuss Question

Answer: Option A. -> all columns of the table are to be returned.

Question 73. Which of the following do you need to consider when you make a table in SQL?

Data types
Primary keys
Default values
All of the above.

Discuss Question

Answer: Option D. -> All of the above.

Question 74. The HAVING clause does which of the following?

Acts EXACTLY like a WHERE clause.
Acts like a WHERE clause but is used for columns rather than groups.
Acts like a WHERE clause but is used for groups rather than rows.
Acts like a WHERE clause but is used for rows rather than columns.

Discuss Question

Answer: Option C. -> Acts like a WHERE clause but is used for groups rather than rows.

Question 75. When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

NOT IN only.
LIKE only.
IN only.
Both IN and NOT IN.

Discuss Question

Answer: Option D. -> Both IN and NOT IN.

Question 76. SQL can be used to:

create database structures only.
query database data only.
modify database data only.
All of the above can be done by SQL.

Discuss Question

Answer: Option D. -> All of the above can be done by SQL.

Question 77. The SQL keyword BETWEEN is used:

to limit the columns displayed.
for ranges.
as a wildcard.
None of these is correct.

Discuss Question

Answer: Option B. -> for ranges.

Question 78. Which of the following query is correct for using comparison operators in SQL?

SELECT name, course_name FROM student WHERE age>50 and
SELECT name, course_name FROM student WHERE age>50 and age
SELECT name, course_name FROM student WHERE age>50 and WHERE age
None of these

Discuss Question

Answer: Option B. -> SELECT name, course_name FROM student WHERE age>50 and age

Question 79. How to select all data from student table starting the name from letter 'r'?

SELECT * FROM student WHERE name LIKE 'r%';
SELECT * FROM student WHERE name LIKE '%r%';
SELECT * FROM student WHERE name LIKE '%r';
SELECT * FROM student WHERE name LIKE '_r%';

Discuss Question

Answer: Option A. -> SELECT * FROM student WHERE name LIKE 'r%';

Question 80. Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?

SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;
SELECT name FROM staffinfo WHERE salary IN (10000, 25000);
Both A and B
None of the above

Discuss Question

Answer: Option B. -> SELECT name FROM staffinfo WHERE salary IN (10000, 25000);

← Previous
1
2
...
5
6
7
8
9
10
11
Next →

Latest Videos

Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)

Direction Sense Test Part 1 Reasoning (Hindi)

Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE

Cube & Cuboid Part 1 Reasoning (Hindi)

Data Interpretation (DI) Basic Concept Reasoning (Hindi)

Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)

Sail E0 free webinar Webinars

Real Numbers Part 7 Class 10 Maths

Real Numbers Part 1 Class 10 Maths

Polynomials Part 1 Class 10 Maths

Latest Test Papers

DSP Combined 1 Free Revision Test SAIL JO E-0

GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0

BSP Plant Specific Review Test SAIL JO E-0

BSL Combined 1 Free Revision Test SAIL JO E-0

GFM Combined 1 Free Revision Test SAIL JO E-0