Computer-SQL [NCO- Cyber Olympiad (SOF) Class 12]: Questions 5 - 9 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. Unlimited Access for Unlimited Time!

View Sample Explanation or View Features.

Rs. 350.00 or

How to register?

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

Question number: 6

» Computer » SQL

Edit
MCQ▾

Question

To Remove a Relation from an SQL Database, we use the ________ Command.

Choices

Choice (4)Response

a.

Remove

b.

Drop table

c.

Purge

d.

Delete

Question number: 7

» Computer » SQL

Edit
MCQ▾

Question

Which of the following is CORRECT query to fetch common records between two tables?

Choices

Choice (4)Response

a.

SELECT * INOT Employee FROM Manager;

b.

SELECT * FROM Employee INTERSECT SELECT * FROM Manager;

c.

SELECT * FROM Employee MINUS SELECT * FROM Manager;

d.

None of the above

Question number: 8

» Computer » SQL

Edit
MCQ▾

Question

In SQL, ________ is a table that does not really exist in its own right but is instead derived from one or more underlying base tables.

Choices

Choice (4)Response

a.

View

b.

Select

c.

Cardinal

d.

Candidate

Question number: 9

» Computer » SQL

Edit
MCQ▾

Question

Which of the following is the correct outcome of the SQL query below?

SELECT student. name, enrolled. grade FROM student, enrolled WHERE student. sid = enrolled. sid AND enrolled. cid = ‘015 - 15’ AND enrolled. grade IN (‘A’, ‘B’)

Choices

Choice (4)Response

a.

Returns the name, grade of the students who took the course ‘015 - 15’ but didn’t get grade ‘A’ or ‘B’ in that course

b.

Error

c.

Returns the name, grade of the students who took course ‘015 - 15’ and got a grade ‘A’ or ‘B’ in that course

d.

Question does not provide sufficient data or is vague

Developed by: