Infosys Certified SQL Server 2016 Administrator
Practice with real exam-pattern questions for Infosys Certified SQL Server 2016 Administrator. 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 SQL Server 2016 Administrator practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified SQL Server 2016 Administrator certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
As a DBA of SQL server Database, you need to list out all the Databases and their compatibility as well as primary file Location. Which of the Following views will you Query?
- ✓sys.databasesCorrect
- Bsys.sysdatabases
- Csys.databaseproperties
- Dsys.all_objects
- Question 2
Tred is working as junior DBA for a TRASHERS Organization using MS-SQL server 2016 for Data warehousing purpose.
Which of the following tools can Tred use to access SQL server error logs at OS level?
- ✓SSMSCorrect
- BSSCM
- CEvent Viewer
- DSQLCMD
- Question 3
Which of the following databases occupies maximum space space and memory with respect to each other?
- ✓MasterCorrect
- BMSDB
- CModel
- DTempDB
- Question 4
Which of the following component is used for ETL (Extract Transform Load) in SQL Server?
- ✓SSASCorrect
- BSSIS
- CSSRS
- DDatabase Engine
- Question 5
Which of the following tool is used to configure SQL Server instance properties?
- ✓SSCMCorrect
- BSSMS
- CActivity Monitor
- DSSIS
- Question 6
How many system databases are present in SQL Server 2016?
- ✓3Correct
- B4
- C5
- D6
- Question 7
What is the size of one Extent in SQL Server 2016?
- ✓8 KBCorrect
- B64 KB
- C8 MB
- D1 MB
- Question 8
You are a DBA of SQL Server 2016 and want to configure one of the databases in such a way that it serves as the template for all databases created in future on one of the instances of SQL Server. Which of the following databases will you use?
- ✓MasterCorrect
- BModel
- CUser
- DUser_template
- Question 9
Which of the following is TRUE about SQL server Architecture?
- ✓Optimizer generates the execution planCorrect
- BExecutor generates the execution plan
- COptimizer performs the syntax and semantic check of the request
- DExecutor performs the syntax and semantic check of the request
- Question 10
What is the size of one page in SQL Server 2016?
- ✓8 KBCorrect
- B64 KB
- C1 KB
- D1 MB
More in IT
Infosys Certified iEDPS Developer
Infosys Certified Delmia ORTEMS Professional
Infosys Certified Knowledge Based Engineering Professional
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.