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.

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

Please login to submit your explanation

Start

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

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

Please login to submit your explanation

Start

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

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

Please login to submit your explanation

Start

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

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

Please login to submit your explanation

Start

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

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

Please login to submit your explanation

Start

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

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

Please login to submit your explanation

Start

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

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

Please login to submit your explanation

Start

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

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

Please login to submit your explanation

Start

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

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

Please login to submit your explanation

Start

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

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

Please login to submit your explanation

Start

["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"]

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%

Completed

0/10

Accuracy

0%

Get Prepinsta Prime

Get all 200+ courses offered by Prepinsta

Never Miss an OffCampus Update

Get OffCampus Updates on Social Media from PrepInsta

Follow us on our Media Handles, we post out OffCampus drives on our Instagram, Telegram, Discord, Whatsdapp etc.

Get Hiring Updates
Amazon,Google,Delottie & 30+companies are hiring ! Get hiring Updates right in your inbox from PrepInsta

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 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 PrepInsta Prime Subscription

Get access to all the courses that PrepInsta offers, check the out below -

Companies

TCS, Cognizant, Delloite, Infosys, Wipro, CoCubes, KPMG, Amazone, ZS Associates, Accenture, Congnizant & other 50+ companies

Programming

Data Structures, Top 500 Codes, C, C++, Java Python & other 10+ subjects

Skills

Full Stack Web Development, Data Science, Machine Learning, AWS Cloud, & other 10+ skills and 20+ projects

Comments