VMware RDBMS Questions and Answers Quiz-1

Question 1

Time: 00:00:00
create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0), primary key (ownerID));

Choose the correct option regarding the above statement

The statement is syntactically wrong

The statement is syntactically wrong

It creates a relation with three attributes ownerID, ownername, floor in which floor cannot be null.

It creates a relation with three attributes ownerID, ownername, floor in which floor cannot be null.

It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null.

It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null.

It creates a relation with three attributes ownerID, ownername, floor in which ownername must consist of at least 25 characters.

It creates a relation with three attributes ownerID, ownername, floor in which ownername must consist of at least 25 characters.

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Question 2

Time: 00:00:00
Choose the correct command to delete an attribute A from a relation R

alter table R delete A

alter table R delete A

alter table R drop A

alter table R drop A

alter table drop A from R

alter table drop A from R

delete A from R

delete A from R

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Question 3

Time: 00:00:00
The ________ clause is used to list the attributes desired in the result of a query

select

select

from

from

where

where

create

create

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Question 4

Time: 00:00:00
The attributes of a relationship are called as _________ attributes

Relational

Relational

Conjunctive

Conjunctive

Descriptive

Descriptive

None of the mentioned

None of the mentioned

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Question 5

Time: 00:00:00
What are composite attributes?

They are those attributes which cannot be further divided into other attributes

They are those attributes which cannot be further divided into other attributes

They are those attributes which can further be divided into other attributes

They are those attributes which can further be divided into other attributes

They are those attributes which are essentially the primary keys of the relation

They are those attributes which are essentially the primary keys of the relation

None of the mentioned

None of the mentioned

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Question 6

Time: 00:00:00
Let E be an entity set in a relationship set R. If only some entities in E participate in relationships in R, Then the participation of E in R is __________

Partial

Partial

Total

Total

Complete

Complete

Incomplete

Incomplete

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Question 7

Time: 00:00:00
Which of the following is a good database management practice?

Adding redundant attributes

Adding redundant attributes

Removing redundant attributes

Removing redundant attributes

Not specifying primary keys

Not specifying primary keys

None of the mentioned

None of the mentioned

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Question 8

Time: 00:00:00
We say that a decomposition having the property F’+ = F+ is a __________ decomposition.

Dependency losing

Dependency losing

Dependency preserving

Dependency preserving

Lossless

Lossless

None of the mentioned

None of the mentioned

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Question 9

Time: 00:00:00
If a system has entered and undesirable state due to which it is unable to continue with normal execution, it is called as _________

Logical error

Logical error

System error

System error

System crash

System crash

None of the mentioned

None of the mentioned

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Question 10

Time: 00:00:00
Which of the following is included in the operational mechanism of the index locking protocol?

Every transaction must have at least one index

Every transaction must have at least one index

A transaction that performs a lookup must acquire a shared lock on all the index leaf nodes that it accesses

A transaction that performs a lookup must acquire a shared lock on all the index leaf nodes that it accesses

The rule of the two phase locking mechanism must be observed

The rule of the two phase locking mechanism must be observed

All of the mentioned

All of the mentioned

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

["0","40","60","80","100"]
["Need more practice! \r\n","Keep trying! \r\n","Not bad! \r\n","Good work! \r\n","Perfect! \r\n"]
×

Please login to report

Personalized Analytics only Availble for Logged in users

Analytics below shows your performance in various Mocks on PrepInsta

Your average Analytics for this Quiz

Rank

-

Percentile

0%

Start Preparing
Detailed performance

Get over 200+ Courses under One Subscription

Get Prime Course List
mute
Limitless Learning

One Subscription access everything

Job Assistance

Get Access to PrepInsta Prime

Top Faculty

from FAANG/IITs/TOP MNC's

Get Prime

Don’t settle Learn from the Best with PrepInsta Prime Subscription

manish-prepinsta

Manish Agarwal

Ex- Accenture

Trained 3.2L+ students

Rushikesh-prepinsta

Rushikesh Konapure

Data Science & Full Stack Mentor

Trained 35k+ students

atulya-prepinsta

Atulya Kaushik

Ex- Google & Instamojo

Trained 3.2L+ students

Aashay-prepinsta

Aashay Mishra

Ex- Sapient

Trained 83k+ students

Janvi-prepinsta

Janvi Jain

Lead Verbal Mentor

Trained 46k+ students

Learn from Top 1%
Get Prime
prepinsta
prepinsta
prepinsta
prepinsta
prepinsta
prepinsta
prepinsta

One Subscription, For Everything

The new cool way of learning and upskilling -

Limitless Learning

One Subscription access everything

Job Assistance

Get Access to PrepInsta Prime

Top Faculty

from FAANG/IITs/TOP MNC's

Get Prime →

Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others.

Get Prime Course List
Get Prime Course List

Comments

June 24, 2019