InfyTQ DBMS Questions 2024

InfyTQ DBMS Question with Solution 2024 is the most important section of both the Round. DBMS ques comes in both rounds of InfytQ. We have covered all the InfyTQ DBMS Questions with Answers here on this page.

  • Certification Round - 10 Questions
  • Difficulty Level- high

You need to study the DBMS concepts in detail for the InfyTQ exam.

InfyTQ DBMS Test

InfyTQ DBMS Ques 2024 Certication Round Question Type
DBMS 10 Ques MCQ

Topics

11

Time Duration

180 mins( shared)

Adaptive/Non-Adaptive

Non- Adaptive

Negative Marking

No

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

Introduction to DBMS
0%
Start
SQL Basics
0%
Start
DDL Statements
0%
Start
DML Statements
0%
Start
SQL Functions, Sorting and Grouping Data
0%
Start
Joins
0%
Start
Subquery
0%
Start
Transactions
0%
Start
Normalization
0%
Start
NoSQL Databases
0%
Start

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

SELECT floor(‘b’);

Zero(0)

Zero(0)

36.92%

a

a

7.02%

98

98

15.63%

Error

Error

40.43%

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.61%

ql

ql

2.97%

Sql ql

Sql ql

80.66%

None of these

None of these

10.76%

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.31%

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

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

61.86%

Error

Error

8.91%

None of the mentioned

None of the mentioned

12.92%

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.31%

2NF

2NF

17.23%

3NF

3NF

40.31%

BCNF

BCNF

24.15%

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.75%

2NF

2NF

44.57%

3NF

3NF

5.43%

BCNF

BCNF

6.25%

 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.6%

2NF

2NF

33%

3NF

3NF

17.79%

BCNF

BCNF

15.61%

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.88%

A,C

A,C

14.73%

A,B,C

A,B,C

21.62%

All of the mentioned

All of the mentioned

51.78%

 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.44%

It is user generated key

It is user generated key

30.56%

It uniquely identify each record

It uniquely identify each record

20.24%

All of the above

All of the above

29.76%

 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.71%

Variable set

Variable set

8.13%

Weak entity set

Weak entity set

78.97%

None of the mentioned

None of the mentioned

2.18%

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

51.72%

Aggregation

Aggregation

32.93%

Specialization

Specialization

13.54%

None of the above

None of the above

1.82%

 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

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
Related Banners
Prepinsta Prime
Get Prepinsta Prime

Get all 200+ courses offered by Prepinsta

Explore Prime or check Course List
Check out our instagram

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.

Instagram Whatsapp Telegram Linkedin
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 Courses like AI/ML, Cloud Computing, Ethical hacking Courses like AI/ML, Cloud Computing, Ethical hacking Courses like AI/ML, Cloud Computing, Ethical hacking.
Get Prime Course List

Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical hacking Courses like AI/ML, Cloud Computing, Ethical hacking Courses like AI/ML, Cloud Computing, Ethical hacking Courses like AI/ML, Cloud Computing, Ethical hacking.
Get Prime Course List

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

See Full list here
Get Prime

Programming

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

See Full list here
Get Prime

Skills

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

See Full list here
Get Prime

OffCampus Updates

Never Miss OffCampus Updates

Get OffCampus Update from PrepInsta

Follow us on our Social Media Handles

Instagram
Telegram
Whatsapp
LinkedIn

Related Pages

InfyTQ DBMS FAQ

The most difficult topic of DBMS InfyTQ is :-

  • SQL Basics
  • Joins
  • Normalization

The difficulty level is high of DBMS Questions. So to practice DBMS Questions you can visit www.prepinsta.com/infytq/DBMS/.

Only students pursuing B.E., B. Tech, M.E., M. Tech, M.Sc., MCM, or MCA and completing the degree course in 2024 are eligible.

PrepInsta Prime Video

Complete Video Course for InfyTQ

Get Prime

87% of prime members learners got selected in Infosys

Interview and Resume Preparation included with Prime subscription

Prime Mock Access is included with Prime Video

Get Prime

June 20, 2023

Comments