InfyTQ DBMS Questions 2023

InfyTQ DBMS MCQ Round Questions 2023

InfyTQ DBMS Question with Solution 2023 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 2023	Certication Round	Question Type
DBMS	10 Ques	MCQ

Topics

Time Duration

180 mins( shared)

Adaptive/Non-Adaptive

Non- Adaptive

Negative Marking

InfyTQ Database Management Syllabus

Click here to know more about InfyTQ DBMS

InfyTQ Syllabus

Practice Questions

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

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

0/100%
Completed

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

SELECT floor(‘b’);

Zero(0)

37.25%

7.35%

15.07%

Error

40.32%

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 ql

80.5%

None of these

10.5%

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

16.08%

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

62.3%

Error

8.65%

None of the mentioned

12.97%

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

18.47%

2NF

17.8%

3NF

39.93%

BCNF

23.79%

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

43.03%

2NF

45.33%

3NF

5.29%

BCNF

6.35%

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

33.48%

2NF

33.05%

3NF

17.48%

BCNF

15.99%

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.

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

A,B

11.81%

A,C

13.82%

A,B,C

21.86%

All of the mentioned

52.51%

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

19.2%

It is user generated key

31.22%

It uniquely identify each record

20.46%

All of the above

29.11%

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

10.45%

Variable set

8.1%

Weak entity set

79.1%

None of the mentioned

2.35%

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

51.74%

Aggregation

33.04%

Specialization

13.7%

None of the above

1.52%

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!

InfyTQ Analytics 2023

Stats About InfyTQ DBMS Exam

Number of Questions 10 Questions

Cut-off 7 Medium

Difficulty 75 High

Topic Wise Analytics

Introduction to DBMS Number of Questions 0-1

Difficulty Level Medium

Importance Medium

SQL Basics Number of Questions 1-2

Difficulty Level High

Importance High

DDL Statements Number of Questions 0-1

Difficulty Level Medium

Importance Medium

DML Statements Number of Questions 0-1

Difficulty Level Medium

Importance Medium

SQL Functions, Sorting and Grouping Data Number of Questions 1-2

Difficulty Level High

Importance High

Joins Number of Questions 0-2

Difficulty Level Medium

Importance High

Subquery Number of Questions 1-2

Difficulty Level Medium

Importance High

Transactions Number of Questions 0-1

Difficulty Level Medium

Importance High

Normalization Number of Questions 1-2

Difficulty Level Medium

Importance High

Performance Number of Questions 0-1

Difficulty Level Medium

Importance Medium

NoSQL Databases Number of Questions 1-2

Difficulty Level Medium

Importance High

InfyTQ Learning 2023

InfyTQ Syllabus and Recruitment Process

All Videos

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 2023 are eligible.

Prime

PrepInsta Prime Video

Complete Video Course for InfyTQ

Get PrimeFor InfyTQ

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 30, 2022

InfyTQ DBMS Questions 2023

InfyTQ DBMS MCQ Round Questions 2023

InfyTQ DBMS Test

InfyTQ Database Management Syllabus

InfyTQ Database Management System Question and Answer:-

InfyTQ DBMS Questions with Solutions

Preparation Section

Introduction to DBMS

SQL Basics

DDL Statements

DML Statements

SQL Functions, Sorting and Grouping Data

Joins

Subquery

Transactions

Normalization

NoSQL Databases

InfyTQ Analytics 2023

Stats About InfyTQ DBMS Exam

Topic Wise Analytics

<img src="https://prepinsta.com/wp-content/themes/prepinsta-2020/images/play.png">InfyTQ Learning 2023

InfyTQ DBMS FAQ

What is the most difficult topic in DBMS of InfyTQ?

What is the difficulty Level of the DBMS in InfyTQ?

If a student is already working with an organization, then also he is eligible to apply for Infosys Certification?

PrepInsta Prime Video

Comments

InfyTQ Learning 2023