Infytq DBMS Questions and Answers 2023 | Set-1

Infytq DBMS Questions and Answers 2023: In this article, we will be discussing some important Infytq DBMS Questions and Answers which will help you guys to crack Infytq 2023 exam.

So, If you are also preparing for Infytq exam, Must prepare these questions.

If you didn’t book your slot yet for infytq exam, Book your slot now.

Question 1: Which SQL Clause is used to combine data from two or more tables ?

1. ADD
2. INSERT INTO
3. MERGE
4. JOIN

Correct Answer – 4th Option

JOIN

Question 2:  Which is not a valid type of JOIN ?

1. INNER JOIN
2. LEFT UPPER JOIN
3. OUTER JOIN
4. LEFT OUTER JOIN

Correct Answer – 2nd Option

LEFT UPPER JOIN

Question 3: Which type of JOIN is used to returns all rows, if there is one match in both tables ?

1. INNER JOIN
2. FULL JOIN
3. OUTER JOIN
4. LEFT JOIN

Correct Answer – 1st Option

INNER JOIN

Question 4: Which type of JOIN is used to returns all rows from left table and only matched rows from right table ?

1. INNER JOIN
2. FULL JOIN
3. OUTER JOIN
4. LEFT JOIN

Correct Answer – 4th Option

LEFT JOIN

Question 5: Which type of JOIN is used to returns all rows from right table and only matched rows from left table?

1. INNER JOIN
2. RIGHT JOIN
3. FULL JOIN
4. LEFT JOIN

Correct Answer – 2nd Option

RIGHT JOIN

To get all job updates on time, Don’t forget to join our whatsapp group. Click below to join.

Question 6: Which type of JOIN is used to returns all rows, if there a match in one of the tables?

1. INNER JOIN
2. RIGHT JOIN
3. FULL JOIN
4. LEFT JOIN

Correct Answer – 3rd Option

FULL JOIN

Question 7: What is the difference between UNION and UNION ALL?

1. UNION ALL returns only DISTINCT values while UNION Operator returns all values.
2. UNION Operator returns only DISTINCT values while UNION ALL returns all values.
3. Both of Above.
4. None of these.

Correct Answer – 2nd Option

Question 8: Which is the correct syntax for UNION Operator?

1. SELECT column_name(s) FROM TABLE table_name1
   UNION 
   SELECT column_name(s) FROM TABLE table_name2
2. SELECT column_name(s) FROM table_name1
   UNION
   table_name2
3. SELECT column_name(s) FROM table_name1
   UNION
   SELECT column_name(s) FROM table_name2
4. SELECT column_name(s) FROM table_name1
   UNION
   table_name2

Correct Answer – 3rd Option

SELECT column_name(s) FROM table_name1
UNION
SELECT column_name(s) FROM table_name2

Question 9: INSERT, UPDATE and DELETE statements belong to ?

1. DQL Language
2. DDL Language
3. DCL Language
4. DML Language

Correct Answer – 4th Option

DML Language

Question 10: The SQL UNION Operator is combines the result of two or more ________ statements.

1. INSERT
2. UPDATE
3. SELECT
4. DELETE

Correct Answer – 3rd Option

SELECT