Menu

Question Discussion & Solution

MCQ

Q.

a _______ query that is nonrecursive and a __________ query.

A

Base, recursive

B

Recursive, Base

C

Base, Redundant

D

View, Base

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.

Which of the following invokes functions in sql?

A

Prepared Statements

B

Connection statement

C

Callable statements

D

All of the mentioned

Discussion

MCQ

2.

A ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.

A

Index

B

Reference

C

Assertion

D

Timestamp

Discussion

MCQ

3.

Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause?

A

With

B

Check

C

With check

D

All of the mentioned

Discussion

MCQ

4.

a)

A

Create table

B

Modify table

C

Alter table

D

Drop table

Discussion

MCQ

5.

Triggers ________ enabled or disabled

A

Can be

B

Cannot be

C

Ought to be

D

Always

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