HackerRank DBMS & SQL Quiz- 1

Question 1

Time: 00:00:00
Which type of language is savepoint and what it does?

TCL and its commits the aborted transaction

TCL and its commits the aborted transaction

DDL and its save the schema

DDL and its save the schema

TCL and it sets a savepoint within a transaction

TCL and it sets a savepoint within a transaction

DML and it saves the changes

DML and it saves the changes

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

Please login to submit your explanation

Start

Question 2

Time: 00:00:00
Which of the following is true about SDL?

It is used to define internal Schema

It is used to define internal Schema

It defines physical structure of database

It defines physical structure of database

It defines how the record will be accessed

It defines how the record will be accessed

All the above

All the above

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

Please login to submit your explanation

Start

Question 3

Time: 00:00:00
There is a table R1 having 5 attributes P Q R S and T. Based on the following functional dependencies (F), determine the table is in which normal form?

 

F=

{

P->Q

QR->T

ST->P

}

1NF

1NF

2NF

2NF

3NF

3NF

BCNF

BCNF

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

Please login to submit your explanation

Start

Question 4

Time: 00:00:00
Based on following table what is output of sql queries
Table: Teachers







































Id  Name  Age  Salary 
01 Vinit 29 20000
03 Bipin 28 15000
05 Sunil  33 20000
02 Sreyashi  31 35000
04 Angshuman  34 25000

SQL > INSERT INTO Teachers (Id,Salary) VALUES(10,’45000);

Error

Error

It adds value ‘10 Null Null 45000’ to the last row of the table

It adds value ‘10 Null Null 45000’ to the last row of the table

It adds value ‘10 Null Null 45000’ to the first row of the table

It adds value ‘10 Null Null 45000’ to the first row of the table

It doesn't add any value to the table

It doesn't add any value to the table

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

Please login to submit your explanation

Start

Question 5

Time: 00:00:00
a) Drop           1)TCL

b)Update       2)DDL

c)CSS              3)DML

d) Commit     4)Declarative language

a)->1 b)->2 c)->3 d)->4

a)->1 b)->2 c)->3 d)->4

a)->2 b)->3 c)->1 d)->4

a)->2 b)->3 c)->1 d)->4

a)->2 b)->3 c)->4 d)->1

a)->2 b)->3 c)->4 d)->1

a)->3 b)->1 c)->4 d)->2

a)->3 b)->1 c)->4 d)->2

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 statements is true for Drop command but false for the Truncate command?

it is a DDL command

it is a DDL command

We can’t rollback the data after using the command

We can’t rollback the data after using the command

This command doesn’t contain where clause

This command doesn’t contain where clause

It removes table definition and its contents

It removes table definition and its contents

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 table which is already in 3NF shouldn’t have ____

Transitive Dependency

Transitive Dependency

Multivariate dependency

Multivariate dependency

Multivalued dependency

Multivalued dependency

No  transitive partial dependency

No  transitive partial dependency

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

Please login to submit your explanation

Start

Question 8

Time: 00:00:00
Which of the following statements about the wait-die Scheme?

  1. It is a Deadlock prevention mechanism

  2. If the older transaction needs some resource locked by a newer transaction then the older transaction will wait.

  3. If the newer transaction needs some resource locked by an older transaction then the older transaction will wait.

  4. If a younger transaction is waiting for some resource locked by an old transaction then the younger transaction is killed and restarted with a very minute delay with the same timestamp.

1,2,3

1,2,3

1,2,4

1,2,4

2,3,4

2,3,4

1,3,4

1,3,4

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 the log of  a transaction Ti contains <Ti start> and <Ti commit> then which of the following methods should be done to Ti?

Undo

Undo

Redo

Redo

Start

Start

Commit

Commit

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 statements are true about metadata?

It is data about data

It is data about data

It holds information about tables

It holds information about tables

It holds information about Constraints

It holds information about Constraints

All the above

All the above

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

Please login to submit your explanation

Start

Question 11

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

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/0

Accuracy

0%

Prime

Prime Mock

Complete Mock Subscription for HackerRank

For HackerRank
Get Prime Mock

Comments