IBM DBMS Quiz-1

Question 1

Time: 00:00:00
When a primary key is define in the table, DBMS automatically creates a ____ on a primary key column.

Unique index

Unique index

Sequence

Sequence

Trigger

Trigger

Synonym

Synonym

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
Which normal form is the partial dependency removed?

First

First

Second

Second

Third

Third

BCNF

BCNF

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
An attribute or combination of attributes in one table whose values must either match the primary key in another table or be null is called __________.

Secondary Key

Secondary Key

Super key

Super key

Candidate Key

Candidate Key

Foreign Key

Foreign Key

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
A transaction state changes from active to______, after the transaction has been rolled back and the database restored to its state prior to the start of the transaction.

Partially committed

Partially committed

Committed

Committed

Aborted

Aborted

Failed

Failed

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
The way a particular application views the data from the database that the application uses is a

Module.

Module.

Relational model.

Relational model.

Schema.

Schema.

Sub schema.

Sub schema.

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
Which of the operations constitute a basic set of operations for manipulating relational data?

Predicate calculus

Predicate calculus

Relational calculus

Relational calculus

Relational algebra

Relational algebra

None of the above

None of the above

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-one of the following statements about normal forms is FALSE?

BCNF is stricter than 3 NF

BCNF is stricter than 3 NF

Lossless, dependency -preserving decomposition into 3 NF is always possible

Lossless, dependency -preserving decomposition into 3 NF is always possible

Loss less, dependency – preserving decomposition into BCNF is always possible

Loss less, dependency – preserving decomposition into BCNF is always possible

Any relation with two attributes is BCNF

Any relation with two attributes is BCNF

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
Which is a bottom-up approach to database design that design by examining the relationship between attributes:

Functional dependency

Functional dependency

Database modeling

Database modeling

Normalization

Normalization

Decomposition

Decomposition

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
Which forms has a relation that possesses data about an individual entity:

2NF

2NF

3NF

3NF

4NF

4NF

5NF

5NF

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 command allows the user to change multiple fields?

Modify

Modify

Lookup

Lookup

Update

Update

Change

Change

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!","Keep trying!","Not bad!","Good work!","Perfect!"]
×

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

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

November 29, 2019