Computer-SQL (NCO- Cyber Olympiad (SOF) Class 12): Questions 6 - 10 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: 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

Question number: 10

» Computer » SQL

Edit
MCQ▾

Question

In DBMS, which of the following is NOT a DML command?

Choices

Choice (4) Response

a.

Select

b.

Insert

c.

Create

d.

Delete

Developed by: