InfyTQ DBMS Questions 2024

InfyTQ Database Management Syllabus

InfyTQ Database Management System Question and Answer:-

Analysis

  • Number of Questions:-10 (qualifier round)
  • Time Limit:-180 minutes shared with other sections

InfyTQ DBMS Questions with Solutions

DBMS Topics Number of Questions Difficulty Importance
Introduction to DBMS 0 - 1 Medium Medium
SQL Basics 1 - 2 High High
DDL Statements 0 - 1 Medium Medium
DML Statements 0 - 1 Medium Medium
SQL Functions , Sorting and Grouping Data 1 - 2 High High
Joins 0 - 2 Medium High
Subquery 1 - 2 Medium High
Transactions 0 - 1 Medium High
Normalization 1 - 2 Medium High
Performance 0 - 1 Medium Medium
NoSQL Databases 1 - 2 Medium High

Preparation Section

Use Coupon Code “CT10” and get flat 10% OFF on PrepInsta Prime, additionally get:

    • 1 month extra on 3 & 6 months plans
    • 2 months extra on 12 & 24 months plans
    • 3 months extra on 36 & 48 months plans

Use Coupon Code "CT10" to get Flat 10% OFF on PrepInsta Prime

0%
0%
0%
0%
0%
0%
0%
0%
0%
0%

1. What will be the output of the following SQL query?

SELECT floor(‘b’);

Zero(0)

Zero(0)

36.74%

a

a

7.1%

98

98

15.54%

Error

Error

40.62%

Floor of a string gives the value 0 in mysql.

Good Job! Did you know? : With $8.5 billion in their kitty, Wipro is the 4th largest Indian IT company in terms of revenue.

Oops!

2. What will be the output of the following query?

SELECT Concat(‘Sql ‘,’ql’);

Sql

Sql

5.51%

ql

ql

3.03%

Sql ql

Sql ql

80.79%

None of these

None of these

10.67%

Concat function concatenates 2 strings

Good Job! Did you know? : With $8.5 billion in their kitty, Wipro is the 4th largest Indian IT company in terms of revenue.

Oops!

3. What will the following query return?

SELECT *
FROM Players
WHERE Goals BETWEEN 1 AND 10
EXCEPT
SELECT *
FROM Players
WHERE Goals BETWEEN 5 AND 7;

Unique records

Unique records

16.15%

Records that have (1<= goals<5) or (5

Records that have (1<= goals<5) or (5

62.15%

Error

Error

8.75%

None of the mentioned

None of the mentioned

12.95%

SELECT *
FROM Players
WHERE Goals BETWEEN 1 AND 10
This query will find all the players from the players table who have more than equals to 1 goal and less than equals to 10 goals
SELECT *
FROM Players
WHERE Goals BETWEEN 5 AND 7;
This query will find all the players from the players table who have more than equals to 5 goal and less than equals to 7 goals And Except will not take the tuples generated by the first query which are also present in the tuples generated by the second query So, it will show the records that have (1<=goals<5) or (5

Good Job! Did you know? : With $8.5 billion in their kitty, Wipro is the 4th largest Indian IT company in terms of revenue.

Oops!

4. Which normal form is a table "players" in, if it has the following characteristics?

  • It has no transitive dependencies.
  • There are no partial dependencies in it
  • There is no column with redundancy in it.
  • A->B dependency is present, where A is a non-prime attribute and B is a prime attribute.

1NF

1NF

18.4%

2NF

2NF

17.19%

3NF

3NF

40.27%

BCNF

BCNF

24.13%

As there is no transitive, no partial and no column with redundancy in it so the table is in 3NF.
As A->B dependency is present, where A is a non-prime attribute and B is a prime attribute.
So, the table can’t be in BCNF. Hence the answer is 3NF

Good Job! Did you know? : With $8.5 billion in their kitty, Wipro is the 4th largest Indian IT company in terms of revenue.

Oops!

5.  If the  table R1 has partial dependency and  no redundancy in the data then the table is  in which normal form?

1NF

1NF

43.23%

2NF

2NF

45.32%

3NF

3NF

5.32%

BCNF

BCNF

6.13%

 If the table has partial dependencies then the  table can’t be in 2NF. As the data of the table has no redundancy hence the table is in 1NF

Good Job! Did you know? : With $8.5 billion in their kitty, Wipro is the 4th largest Indian IT company in terms of revenue.

Oops!

6. A table R has 6 attributes A,B,C,D,E,F and the functional dependencies are given below F= { AB->C, DC->AE, E->F } Tell the table is in which normal form?

1NF

1NF

33.33%

2NF

2NF

33.14%

3NF

3NF

17.74%

BCNF

BCNF

15.79%

From analysing the problem  we can say that the candidate keys Should have B,D in it So, the closure of BD = BD

As, BD can’t be the candidate key

So the closures of ABD= ABCDEF BCD= ABCDEF EBD= BDEF FBD= FBD

Now the closure of EFBD=EFBD

Hence the candidate keys are ABD,BCD

So, the prime attributes = A,B,C,D As, in AB->C , C is a prime attribute

so C can’t be in BCNF As, in E->F, E,F are non-prime attributes so, this is an example of transitive dependency.

So, the table can’t be in 3NF As, DC->E , here DC is a part of a candidate key BCD and E is a non prime attribute.

So, it is a partial dependency. So, the table can’t be in 2NF also. So, only one normal form is possible which is 1NF.

Good Job! Did you know? : With $8.5 billion in their kitty, Wipro is the 4th largest Indian IT company in terms of revenue.

Oops!

7. In DBMS, which of the following statements about bitmap indexes are valid.

  1. It uses bitmaps
  2. It is used for the tables which are huge and frequently used columns have low cardinality
  3. It uses logical operators on bitmap to give most of the queries
  4. Make the bitwise index is very time consuming

A,B

A,B

11.74%

A,C

A,C

14.55%

A,B,C

A,B,C

22.07%

All of the mentioned

All of the mentioned

51.64%

 All of these statements of bitmaps are valid

Good Job! Did you know? : With $8.5 billion in their kitty, Wipro is the 4th largest Indian IT company in terms of revenue.

Oops!

8. Which of the following is False about the surrogate key?

It is an artificial key

It is an artificial key

19.57%

It is user generated key

It is user generated key

30.53%

It uniquely identify each record

It uniquely identify each record

20.35%

All of the above

All of the above

29.55%

 Surrogate keys are system generated

Good Job! Did you know? : With $8.5 billion in their kitty, Wipro is the 4th largest Indian IT company in terms of revenue.

Oops!

9.  If an entity set E does not has enough attributes to form a primary key, then this entity set will be called as:

Strong entity set

Strong entity set

10.78%

Variable set

Variable set

8.04%

Weak entity set

Weak entity set

79.02%

None of the mentioned

None of the mentioned

2.16%

If an entity set does not have enough attributes to form a primary key then it will be considered as a weak entity set.

Good Job! Did you know? : With $8.5 billion in their kitty, Wipro is the 4th largest Indian IT company in terms of revenue.

Oops!

10. 2 entity sets Footballer and Cricketer taken into an entity set called Players and the common entities of Footballer and Cricketer became part of Players. This is an example of ?

Generalization

Generalization

52%

Aggregation

Aggregation

32.8%

Specialization

Specialization

13.4%

None of the above

None of the above

1.8%

 In generalization lower level entity sets are taken into a higher level entity set and the common entities of the lower level entity sets become the part of the higher entity set.

Good Job! Did you know? : With $8.5 billion in their kitty, Wipro is the 4th largest Indian IT company in terms of revenue.

Oops!

×

Please login to report

prepinsta-prime

InfyTQ Analytics 2024

Stats About InfyTQ DBMS Exam

Number of Questions 100%
Cut-off 70%
Difficulty 750%

Topic Wise Analytics

Introduction to DBMS
Number of Questions 0-1
Difficulty Level 65%
Importance 70%
SQL Basics
Number of Questions 1-2
Difficulty Level 70%
Importance 70%
DDL Statements
Number of Questions 0-1
Difficulty Level 65%
Importance 65%
DML Statements
Number of Questions 0-1
Difficulty Level 70%
Importance 75%
SQL Functions, Sorting and Grouping Data
Number of Questions 1-2
Difficulty Level 75%
Importance 70%
Joins
Number of Questions 0-2
Difficulty Level 70%
Importance 80%
Subquery
Number of Questions 1-2
Difficulty Level 65%
Importance 75%
Transactions
Number of Questions 0-1
Difficulty Level 60%
Importance 80%
Normalization
Number of Questions 1-2
Difficulty Level 65%
Importance 80%
Performance
Number of Questions 0-1
Difficulty Level 60%
Importance 65%
NoSQL Databases
Number of Questions 1-2
Difficulty Level 65%
Importance 65%

InfyTQ Learning 2024

Card image cap

InfyTQ Syllabus and Recruitment Process
All Videos

Personalized Analytics only Availble for Logged in users

Analytics below shows your performance in various Mocks on PrepInsta

Your analytics for this Subject

Mocks

0/149

InfyTQ main Mocks Completed

Mocks

0/31

InfyTQ - DBMS Mocks Completed

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

February 14, 2024