Quiz-1

June 23, 2019

Hello PrepSter,

If you find any errors in the quiz below kindly comment in the comment section and we will make it our priority to fix it.

Also if you have a better of the solution to the questions, please do comment them below and if we find it better than ours, we will post it in our website.

Question 1

Time: 00:00:00
The minimal set of a super key is?

candidate key

candidate key

primary key

primary key

foreign key

foreign key

secondary key

secondary 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

Start

Question 2

Time: 00:00:00
car(car_number,car_type,mfd)
owner(name,age,car_number,number)
Akshay has 2 tables namely - car and owner (given in the passage), with a common column car_number. Which of the following queries will retrieve car_ type where owner name Is ‘Nikhil’?

SELECT car_type FROM car WHERE car_number IN (SELECT car_number FROM owner WHERE name=’Nikhil’);

SELECT car_type FROM car WHERE car_number IN (SELECT car_number FROM owner WHERE name=’Nikhil’);

SELECT car_type FROM car WHERE car_number=(SELECT * FROM owner WHERE name= ‘NikhiI’);

SELECT car_type FROM car WHERE car_number=(SELECT * FROM owner WHERE name= ‘NikhiI’);

SELECT car _type FROM car WHERE car _number LIKE (SELECT * FROM owner WHERE name=’NikhiI’);

SELECT car _type FROM car WHERE car _number LIKE (SELECT * FROM owner WHERE name=’NikhiI’);

SELECT car_type FROM car WHERE car_number BETWEEN(SELECT car_number FROM owner WHERE name=’Nikhil’);

SELECT car_type FROM car WHERE car_number BETWEEN(SELECT car_number FROM owner WHERE name=’Nikhil’);

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 3

Time: 00:00:00
Which of the following is a fundamental operation in relational algebra ?

Set intersection

Set intersection

Natural join

Natural join

Assignment

Assignment

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

Start

Question 4

Time: 00:00:00
Which of the following is not a unary operator?

where

where

select

select

rename

rename

min

min

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 5

Time: 00:00:00
If in JOIN operation, conditions of JOIN operation are not satisfied then results of operation is

Zero tuples and empty relation

Zero tuples and empty relation

zero tuples from two relation

zero tuples from two relation

one tuple from one relation saying null

one tuple from one relation saying null

two tuples from empty relations

two tuples from empty relations

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 6

Time: 00:00:00
Which of the following is not a DML statement?

Select

Select

Insert

Insert

Create

Create

Delete

Delete

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 7

Time: 00:00:00
A ________ in a table represents a relationship among a set of values.

Column

Column

Key

Key

Row

Row

Entry

Entry

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 8

Time: 00:00:00
A relational database consists of a collection of

Tables

Tables

Fields

Fields

Records

Records

Keys

Keys

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 9

Time: 00:00:00
The term _______ is used to refer to a row.

Attribute

Attribute

Tuple

Tuple

Field

Field

Instance

Instance

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
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! \n \n \n","Keep trying! \n \n \n","Not bad! \n \n \n","Good work! \n \n \n","Perfect! \n \n \n"]
×

Please login to report