Menu

Question Discussion & Solution

MCQ

Q.

The above command

A

Deletes a particular tuple from the relation

B

Deletes the relation

C

Clears all entries from the relation

D

All of the mentioned

Community Discussion

No discussions yet. Be the first to start!

You must be logged in to participate in the discussion.

Login to Discuss

Similar Questions

MCQ

1.

SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used.

A

Group by

B

With

C

Where

D

Having

Discussion

MCQ

2.

Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause.

A

Where, having

B

Having, where

C

Group by, having

D

Group by, where

Discussion

MCQ

3.

Values of one type can be converted to another domain using which of the following?

A

Cast

B

Drop type

C

Alter type

D

Convert

Discussion

MCQ

4.

Here which one denotes the relation for which index is created?

A

StudentID_index

B

ID

C

StudentID

D

Student

Discussion

MCQ

5.

Which of the following creates a virtual relation for storing the query?

A

Function

B

View

C

Procedure

D

None of the mentioned

Discussion

More Database Management System Topics

Miscellaneous or General

71 MCQs

Relational Algebra

3 MCQs

Database Systems

49 MCQs

Data Models

16 MCQs

The Relational Database Model

58 MCQs

Entity Relationship (ER) Modeling

59 MCQs

Advanced Data Modeling

1 MCQs

Normalization

58 MCQs

Structured Query Language (SQL)

7 MCQs

Advanced SQL

90 MCQs

Database Design

2 MCQs

Transaction and Concurrency

10 MCQs

Data Warehouses

10 MCQs

Database Administration

1 MCQs

Mixed

10 MCQs