Question Discussion & Solution

MCQ

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

Function

View

Procedure

None of the mentioned

Community Discussion

No discussions yet. Be the first to start!

You must be logged in to participate in the discussion.

Similar Questions

MCQ

In an employee table to include the attributes whose value always have some value which of the following constraint must be used?

Null

Not null

Unique

Distinct

Discussion

MCQ

Which of the following closely resembles Create view?

Create table . . .like

Create table . . . as

With data

Create view as

Discussion

MCQ

Use group by or group functions

Retrieve data from a table different from the one in the outer query

Join tables

Appear in select, update, delete, insert statements.

Discussion

MCQ

In rank() function if one value is shared by two tuples then

The rank order continues as counting numbers

The rank order continues by leaving one rank in the middle

The user specifies the order

The order does not change

Discussion

MCQ

The __________ function that does not create gaps in the ordering.

Intense_rank

Continue_rank

Default_rank

Dense_rank

Discussion

Banking

Engineering

General

Medical

Question Discussion & Solution

Report Error

Community Discussion

Similar Questions

Report Error

Report Error

Report Error

Report Error

Report Error

More Database Management System Topics

Miscellaneous or General

Relational Algebra

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER) Modeling

Advanced Data Modeling

Normalization

Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction and Concurrency

Data Warehouses

Database Administration

Mixed

Banking

Engineering

General

Medical

Question Discussion & Solution

report Report Error

forum Community Discussion

auto_awesome Similar Questions

report Report Error

report Report Error

report Report Error

report Report Error

report Report Error

category More Database Management System Topics

Miscellaneous or General

Relational Algebra

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER) Modeling

Advanced Data Modeling

Normalization

Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction and Concurrency

Data Warehouses

Database Administration

Mixed

Report Error

Community Discussion

Similar Questions

Report Error

Report Error

Report Error

Report Error

Report Error

More Database Management System Topics