Infosys Certified Database and SQL Professional
Practice with real exam-pattern questions for Infosys Certified Database and SQL Professional. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified Database and SQL Professional practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Database and SQL Professional certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
Identify if any foreign key exists in the below relations.
Item (ItemCode, ItemType, Desc, Price, ReorderLevel, QtyOnHand, Category)
PurchaseBill (BillId, RetailOutlet, ItemNo, Customer, BillAmount, Bill Date,Quantity)
- ✓ItemNoCorrect
- BQtyOnHand
- CBillAmount
- DNo foreign key
- Question 2
Which of the following statement is TRUE regarding CREATE TABLE statement?
A. CREATE table replaces the existing table if it already exists
B. Attributes default to NUMBER data type if data type is not provided
C. Attributes allow NULL values unless NOT NULL clause is provided
D. DEFAULT clause can only be provided for NOT NULL attributes- ✓ACorrect
- BB
- CC
- DD
- Question 3
Smith has created an ER diagram. In a many-to-one relationship, the primary key of one entity acts as foreign key on which side?
- ✓On the side where single (one) relationship is definedCorrect
- BOn the side where many relationships are defined
- COn both the sides
- DNeither of them
- Question 4
Peter, who is a DBA designing databases. An application database for domestic cricket clubs needs to be created. There are many cricket clubs at different locations. A club can have many members. Each member, belonging to a particular club, has a unique member ID. The member ID need not be unique across different clubs. The below relations are created.
Club (ClubId, Name, Location)
Member (ClubId, MemberId, Name, Address)Identify the Primary key for Club relation.
- ✓ClubId, LocationCorrect
- BClubId, MemberId
- CClubId
- DMemberId
- Question 5
Carol, who is an SDET professional has written the following queires.
A. SELECT Id, EName, E.CompId AS E_CompId, C. CompId AS C_CompId, Model
FROM EmpTable INNER JOIN Computer C ON E.CompId = C.CompId WHERE Deptid='ETA'B. SELECT Id, EName, E.CompId AS E_CompId, C.CompId AS C_CompId, Model
FROM EmpTable E INNER JOIN Computer C ON E.CompId = C.CompId AND Deptid = 'ETA'
Select correct answer from the following:- ✓Both gives different resultCorrect
- BBoth gives same result
- CQuery A is invalid
- DQuery B is invalid
- Question 6
John has selected the following query. Predict the output:
SELECT SUBSTRING ((REPLICATE ('Infy', CHARINDEX ('n','Infy'))),5,4)- ✓InfyCorrect
- ByInf
- CInfyInfy
- DInfyInfyInfyInfy
- Question 7
ABCBiG_Bang is a retail store having millions of purchase records every day. A customer can buy many products and a product can be purchased by many customers. Purchase details are available in a separate relation.
Customer (CustId, Name, Address)
Product (ProdId, Desc, Price, ProdValidity)
Purchase (ProductNo, Quantity, SalesAmount, CustomerNo)Identify the Primary key for Purchase relation.
- ✓ProductNo, QuantityCorrect
- BCustId, Name
- CProductNo, SalesAmount
- DProductNo, CustomerNo
- Question 8
Which of the following conditions is equivalent?
A. "C1 >= 10" and "NOT C1 < 10"
B. "C1 LIKE E%" and "C1 LIKE E_"
C. "C1 IN (1,2)" and "C1 = 1 OR C1 = 2"
D. "C1 IN (10,20)" and "C1 BETWEEN 10 AND 20"- ✓A, BCorrect
- BA, C
- CB, C
- DB, D
- Question 9
Joan has created a relation - Employee. Identify the candidate key(s) from the following relations.
Employee(EmpNo, EmpName, EmailID, EmpSal, EmpUnit)
- ✓EmpNameCorrect
- BEmpNo, EmpUnit
- CEmailID, EmpSal
- DEmpNo, EmailID
- Question 10
What is the maximum value that can be stored in NUMERIC(4,2) in Oracle?
- ✓9999.99Correct
- B99.9999
- C99.99
- D9.99
More in IVS Academy
Infosys Certified TOSCA Automation Tester
Infosys certified Digital Accessibility Expert
Infosys Certified Data QE platform Expert
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.