infytq dbms and sql assignment answers

Navigation Menu

Search code, repositories, users, issues, pull requests..., provide feedback.

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly.

To see all available qualifiers, see our documentation .

• Notifications You must be signed in to change notification settings

Infosys DBMS Course Exercises and Assignment solutions

Aashrith001/INFYTQ-DBMS

Folders and files, repository files navigation.

INFYTQ-DBMS Infosys DBMS(Part-1 & Part-2) Course Exercises and Assignment Solutions

Database Management System Part-1 https://infytq.onwingspan.com/en/app/toc/lex_auth_01275806667282022456_shared/overview

Database Management System Part-2 https://infytq.onwingspan.com/en/app/toc/lex_auth_0127673005629194241_shared/overview

DBMS INFYTQ Mock-I Questions

1.Identify the statements that will be TRUE after executing the following statements on an empty MongoDB collection.

Which of the following statement(s) is/are TRUE? i) Three fruits will have price as 25 ii) The fruit collection will have 4 "Winter" seasons. iii) Two fruits will have price as 35. iv) Two fruits will have a name ending with "melon". a)  i and ii b)  i and iii c)  ii and iv d)  i,ii,iii.

(c) is the correct option.

2. Consider relational schema along with the functional dependencies given below:

How many tables will result when the relation is in 3NF?    a) 1    b) 2    c) 3    d) 4

3.Consider a Patient table with attributes patientid (primary key), patientname, city, dateofbirth and phone. Except patientid no columns are unique. The table has three indexes as follows:

Which of the following queries will result in INDEX UNIQUE SCAN?    a) WHERE city > Mumbai' AND dateofbirth > '30-Mar-1995'    b) WHERE patientid = 'P1007' AND dateofbirth = '30-Mar-1995'    c) WHERE patientname = 'Sam' AND dateofbirth = '30-Mar-1995’    d) WHERE patientname LIKE 'R%

4.Consider the table stores and sales given below:

Which of the following is suitable primary key for the following?

Unlock this article for Free, by logging in

Don’t worry, unlock all articles / blogs on PrepInsta by just simply logging in on our website

• What is InfyTQ ?
• Placement Papers
• Registration Process
• Certification Round Practice Questions
• Java MCQ Practice Questions
• Python MCQ Practice Questions
• DBMS MCQ Practice Questions
• Coding Questions
• Advantage Round
• Recruitment Process
• How to Prepare
• InfyTQ Results
• SP Interview Experience
• Get Hiring Updates

PREPINSTA PRIME

• PrepInsta Mock
• Prime Video

Get Hiring Updates right in your inbox from PrepInsta

InfyTQ Questions and Answers | DBMS Certification Round

June 21, 2023

InfyTQ DBMS MCQ Questions for 2024

InfyTQ Certification Test has been announced for 2024 graduates, and this year the recruitment process has been changed entirely. This year there will be 2 selection rounds

•  Certification Round

In the Certification round, you’ll get MCQ and Coding Questions based on JAVA/Python and along with it there will be 10 questions of DBMS. Here, in this article we have provided some practice questions based on the syllabus and pattern of the latest InfyTQ DBMS MCQ Round Questions

InfyTQ Online Test Pattern:-

Infytq dbms mcq round practice questions.

Question 1 – Ravi Sastri is a good coach. He wants to join 2 relational tables related to sports. He also wants that all the matched and unmatched tuples of the right table should be present in the result but only the matched rows of the left table should be present in the result after the join operation. Which of the following joins he should use?

• Left outer join
• Right outer join
• Full outer join

Answer- Right outer join

Explanation – The result of right outer join contains all the matched and unmatched rows from the right table and only the matched rows from the left table

Question 2 – Joins can be visualize as _______ with ________ :

• Where , Groupby clause
• Aggregate functions, some conditions 
• Cartesian product , some condition 
• None of the above

Answer- Cartesian product , some condition 

Explanation – With the help of cartesian products we can get all the possible combinations between the tables. With the help of adequate conditions we can perform any join operations

Question 3 – Kapil Dev is a good cricket administrator. He wants to join 2 tables using an equality operator.

Which type of join is this?

Answer- Equi join

Explanation – If 2 tables are joined using equality operator then that join comes under the condition of Equi join.

Question 4 – What will be the output of the following function call in SQL? Select Replace(‘pqrstpqr’, ‘pqr’, ‘rst’) 

Answer- rststrst

Explanation – Replace(‘pqrstpqr’, ‘pqr’, ‘rst’) Here all the ‘pqr’ substrings of  ‘pqrstpqr’ will be replaced by ‘rst’. So, the output will be ‘rststrst’ Hence the answer will be rststrst

Question 5 – Consider a directed line(->) from the relationship set mentor to both entity sets student and teacher. This indicates _________ cardinality

• One to many
• Many to one
• Many to many

Answer- one to one

Explanation – This indicates a teacher can mentor at most 1 student and a student can have at most 1 teacher as mentor.

Question 6 – Given are the columns in the STUDENTS table, Which of the following statements will you use to retrieve a string that contains ‘_abc_’ in the ‘STUDENT_ID’ column?  

STUDENTS table columns:

CLASS_ID NUMBER (4)

LAST_NAME VARCHAR2 (25)

STUDENT_ID VARCHAR2 (10)

• SELECT class_id, last_name, student_id FROM students WHERE student_id = %ABC%;
• SELECT class_id, last_name, student_id FROM students WHERE student_id LIKE ABC_%;
• SELECT class_id, last_name, student_id FROM students WHERE student_id LIKE %ABC%;
• None of these

Answer- SELECT class_id, last_name, student_id FROM students WHERE student_id LIKE %ABC%;

Explanation – WHERE student_id LIKE ‘%_ABC_%’  selects all the job_ids that has ‘_ABC_’ substring in it (case insensitively)

Question 7 – Which of the following statements are true about LIKE operator in SQL?

• LIKE operators are case insensitive.
• LIKE ‘%abc’ finds all the strings end with abc
• LIKE ‘%ABC%’ finds all the strings which contain abc
• LIKE ‘_AC_’ find all the strings which have exactly 4 characters and the 2nd and 3rd characters are A,C respectively

Answer- A,B,C,D

Explanation – All of the above is true about Like Operator

Question 8 – Which of the following lines in the given code contains an error?  

• SELECT stid,f_name, l_name
• FROM students
• WHERE SUBSTR(l_name, 1, 1) > TO_NUMBER(‘P’)
• AND stid > 2000
• ORDER BY stid DESC, l_name ASC;

Explanation – TO_NUMBER function: The TO_NUMBER function converts a character value to a numeric datatype. If the string being converted contains nonnumeric characters, the function returns an error.

Question 9 – What will the following query return?  

FROM Products

WHERE Amount BETWEEN 10 AND 80

WHERE Amount BETWEEN 50 AND 75;

• Unique record
• None of the given option
• Record that are not in query 2

Answer- Record that are not in query 2

Explanation – The SQL EXCEPT clause/operator is used to combine two SELECT statements and returns rows from the first SELECT statement that are not returned by the second SELECT statement. This means EXCEPT returns only rows, which are not available in the second SELECT statement.

Question 10  – The SQL statement select SUBSTR(‘mnopqrst’, INSTR(‘qpsptrcs’, ‘p’),3) from dual prints

Answer- public static synchronized final strictfp void main(String… args){}

Explanation – 

• INSTR Function:- The INSTR function in SQL is used to find the starting location of a pattern in a string. The syntax for the INSTR function is as follows:
• INSTR (str, pattern): Find the starting location of pattern in string str.
•  SUBSTR Function:- The Substring function in SQL is used to grab a portion of the stored data. The syntax for the SUBSTR function is as follows: 
• In the above query INSTR(‘qpsptrcs’, ‘p’) outputs 2 as the starting location of the pattern So, now the query can be written as 
•  It will return the substring from position 2 to position (2+3-1)=4 of the string which is “nop”

Login/Signup to comment

30+ Companies are Hiring