Infosys Certified Full Stack System Administrator - RDBMS - Beginner
Practice with real exam-pattern questions for Infosys Certified Full Stack System Administrator - RDBMS - Beginner. 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 Full Stack System Administrator - RDBMS - Beginner practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Full Stack System Administrator - RDBMS - Beginner certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
Consider the following perl statement and predict, what would be the outcome of the following statement in file.pl?
open (filehandle,"<file1.txt") and die (" Cannot Open");
- ✓
Error:file1.txt does not exist
Correct - B
Cannot Open at file.pl line number
- C
file1 will be opened for writing
- D
no output
- ✓
- Question 2
ORCL database consists of two pluggable databases PDBEMP and PDBDATA to store the employee details. As per the requirement, one more pluggable database PDBINF need to be created. The task is assigned to William and John as they are appointed as junior DBA and following are the statements made by them.
William: Pluggable database PDBINF can only be created using PDB$SEED
John: Pluggable database PDBINF can be created using PDB$SEED or any existing pluggable database
As a senior DBA, identify whose statement(s) is/are CORRECT?
- ✓
Both William and John statements are correct
Correct - B
Only John statement is correct
- C
Only William statement is correct
- D
Both William and John statements are incorrect
- ✓
- Question 3
The root file system is the only file system that can be identified by the Unix kernel. The Unix OS is installed on the root file system. While starting the Unix system, you find the error that there was no bootable medium found. The corruption of which block in the file system can lead to this error?
- ✓
Boot block
Correct - B
Super block
- C
Data block
- D
Inode block
- ✓
- Question 4
The server listens on a network port for TCP/IP connections unless started with which of the following option?- ✓
–networking
Correct - B
–skip-networking
- C
–skip-networks
- D
–quit-networking
- ✓
- Question 5
To use ‘mysqldbcopy’ which of the following privilege is required on the source server?
- ✓
CREATE
Correct - B
INSERT
- C
UPDATE
- D
SELECT
- ✓
- Question 6
Which of the following is NOT a database object?
- ✓
Database Diagrams
Correct - B
Stored Procedures
- C
Powershell
- D
Index
- ✓
- Question 7
Parameters in the file _________ can be edited only through ALTER SYSTEM command.
- ✓
postgresql.conf
Correct - B
postgresql.auto.conf
- C
pg_hba.conf
- D
postmaster.pid
- ✓
- Question 8
John is working as a DBA of SQL server Database. He needs the information on backup and recovery of Instance. Which of the Following Databases will store the information related to this?
- ✓
msdb
Correct - B
resource
- C
tempdb
- D
master
- ✓
- Question 9
Which of the following statements are TRUE regarding error_log are TRUE?
- It records the information about startup and shutdown time
- It records the errors and warnings that are obtained in the client executions
- It records the errors, warnings and notes about the startup and shutdown of the mysql process
- ✓
Only (i) and (iii) are TRUE
Correct - B
Only (ii) and (iii) are TRUE
- C
Only (i) and (ii) are TRUE
- D
All the above are TRUE
- Question 10
Which of the following statements is/are TRUE with respect to Resource Database? (Choose any 3 correct options)
- ✓
Resource Database is hidden from Users and It cannot be Modified
Correct - B
Resource Database is hidden from Users and It can only be modified by users with SecurityAdmin Role
- C
Stored Procedures defined under Resource database are used by the Instance
- D
Stored Procedures defined under Resource database are used by the Databases
- ✓
More in Code
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.