Computer-SQL (NCO- Cyber Olympiad (SOF) Class 12): Questions 1 - 5 of 28

Access detailed explanations (illustrated with images and videos) to 520 questions. Access all new questions we will add tracking exam-pattern and syllabus changes. Subscription can be renewed yearly absolutely FREE! View Sample Explanation or View Features.

Rs. 350.00 or

How to register?

Question number: 1

» Computer » SQL

Edit
MCQ▾

Question

In SQL, the HAVING clause is used to ________.

Choices

Choice (4) Response

a.

Refine the query and the tuples returned by the GROUP BY clause.

b.

Store the result of the query in a new table with the indicated name.

c.

Refine the query and tuples returned by the WHERE clause.

d.

Sort the tuples alphabetically.

Question number: 2

» Computer » SQL

Edit
MCQ▾

Question

Which of the following SQL commands is CORRECT, if you want to display name and section of those students whose section is either A or C?

Choices

Choice (4) Response

a.

SELECT name, section FROM students WHERE section IN (‘A’, ‘C’);

b.

SELECT name, section FROM students WHERE section BETWEEN ‘A’ AND ‘C’;

c.

SELECT name, section FROM students WHERE section LIKE ‘A’ and ‘C’;

d.

SELECT name, section FROM students WHERE section BETWEEN (‘A’, ‘C’);

Question number: 3

» Computer » SQL

Edit
MCQ▾

Question

Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?

Choices

Choice (4) Response

a.

DDL

b.

DML

c.

Query

d.

Relational Schema

Question number: 4

» Computer » SQL

Edit
MCQ▾

Question

Which of the following is true for TRUNCATE in SQL?

Choices

Choice (4) Response

a.

There is no comparison between DELETE & TRUNCATE

b.

Truncate command can be rolled back

c.

It is usually faster than DELETE command

d.

It is usually slower than DELETE command

Question number: 5

» Computer » SQL

Edit
MCQ▾

Question

In an SQL SELECT Statement Querying a single table, According to the SQL-92 Standard the (*) Asterisk Means that:

Choices

Choice (4) Response

a.

All columns of the table are to be returned

b.

All records meeting the full criteria are to be returned.

c.

All records with even partial criteria met are to be returned.

d.

None of the above

Developed by: