Tag: databases

Successful

Results in error

Depends on condition

None

Class object

Schema object

Both

None of the above

It is query with alias name

It is subquery with alias name

Both

None of the above

Unique key

Primary key

Foreign key

All of the above

To get automatic values

For esay access

For fast access

All of the above

A column contains large no of values

A column contains large no of null values

Table is small

When table is not updated frequently

Deletes rows from table

Removes storage space

Removes table structure

All of the above

Candidate key

Member key

Both of above

None of the above

show user

get user

display user

display

set sqlprompt “Ravi Kishore > “

set prompt “Ravi Kishore > “

set sql “Ravi Kishore > “

set sqlpromt “Ravi Kishore > “