Infosys Certified L1 Junior Database Admin Professional
Practice with real exam-pattern questions for Infosys Certified L1 Junior Database Admin 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 L1 Junior Database Admin Professional practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified L1 Junior Database Admin Professional certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
The database user issued a series of queries on different data dictionary views to get information about ORCL database.
Which of the following statement is TRUE with respect to data dictionary views?
- ✓
Data dictionary views need to be created manually by executing the script catalog.sql once the database is created using dbca utility
Correct - B
Data dictionary views gets created automatically when oracle is installed and is shared by all databases.
- C
Content of data dictionary is modified by DDL statement execution
- D
Data dictionary views are optional as the base table of the data dictionaries can be accessed directly
- ✓
- Question 2
As a DBA, you observed the status of CDB1 database, which is innomount state.
Which of the following commands will you execute, to change the database to OPEN mode as SYSDBA in sequence?
- SQL> STARTUP
- SQL> STARTUP MOUNT
- SQL> ALTER DATABASE OPEN
- SQL> ALTER DATABASE NOMOUNT
- SQL> STARTUP OPEN
- SQL> ALTER DATABASE MOUNT
- ✓
(vi), (iii)
Correct - B
(ii), (iii)
- C
(iv), (vi), (iii)
- D
(v)
- Question 3
You as a DBA, want to check the status of the listener service with the name listerner_12c.
Which of the following utility will help you to perform the above activity?
- ✓
listener
Correct - B
sqlplus
- C
lsnrctl
- D
dbca
- ✓
- Question 4
The DBA tries to create net service name for PDBEMP pluggable database which is created in CDB1 container database using NETCA utility.
Which of the following inputs are required to perform the creation of net service name?
- ✓
Net service name, Port Number, Protocols, Host machine details, CDB1 database service name
Correct - B
Net service name, Protocols, Host machine details, PDBEMP database service name
- C
Net service name, Port Number, Protocols, Host machine details, PDBEMP database service name
- D
Net service name, Port Number, Host machine details, PDBEMP database service name
- ✓
- Question 5
The DBA received a request to create a new tablespace TBS_EMP in PDBEMPLOYEE pluggable database for storing the employee details. By mistake, the DBA creates the tablespace in root container CDB$ROOT. He/she executes the below given DROP TABLESPACE command to drop the newly created TBS_EMP from CDB$ROOT immediately so that no objects are created.
SQL> DROP TABLESPACE tbs_emp;
Which of the following statement is TRUE with respect to the above scenario?
- ✓
The DROP command execution will fail with an error message to use INCLUDING CONTENTS option
Correct - B
The DROP command execution will fail as the tablespace name is case sensitive
- C
The tablespace TBS_EMP will get dropped but the datafile will still exists in physical location
- D
The DROP command execution will fail with an error message to use INCLUDING CONTENTS AND DATAFILES option
- ✓
- Question 6
You as a DBA, executes ALTER SYSTEM command to update listener parameter value to register a new listener with the database.
Which of following statement is TRUE with respect to the execution of ALTER SYSTEM command?
- ✓
After the command execution, to make the changes effective the database must be restarted
Correct - B
The command execution makes changes in the pfile of the database
- C
The command execution makes changes in the spfile of the database
- D
The command need to be executed twice to make the changes in spfile and pfile
- ✓
- Question 7
GEMS is an Oracle 12c database which holds information regarding PLAZA GOLDS LTD. industries with two pluggable databases CORAL and RUBY. JENIFER is a local user of CORAL pluggable database, she has been provided with the privilege to connect and create table in CORAL database. She creates a table named account_holders using the below statement.
SQL> CREATE TABLE ACCOUNT_HOLDERS (ACC_NO INT);
Then tries to insert values into the table and faces below error. What would be the possible reasons for the error?
- ✓
JENIFER does not have insert privilege on account_holders table
Correct - B
The given insert statement is wrong
- C
JENIFER does not have insert privilege on users tablespace
- D
JENIFER is not provided with quota on users tablespace
- ✓
- Question 8
SANA, RYAN and MARY are junior DBA’S of RUBY pluggable database. They are asked to provide multiple system and object level privileges to 10 newly joined database users. The dba’s make a discussion among themselves and put forward their statements as below.
MARY: System and object level privileges can be provided to the database users only through roles
SANA: Both system and object level privileges can be provided to the database users through role or as individual privileges
RYAN: Since there are 10 users to be provided with same privileges it is optimal to provide the system and object privileges to the users, by assigning role granted with required privileges.
Which of the above statements are TRUE with respect to the scenario?
- ✓
Both SANA and MARY are correct
Correct - B
Both SANA and RYAN are correct
- C
Both RYAN and MARY are correct
- D
Only RYAN is correct
- ✓
- Question 9
In an Oracle database, the logical storage structure tablespace, comprises segments and one segment is made up of one or more extents. So if there is a data segment, what are the different extents that can be part of it?
- ✓
Extents holding actual data
Correct - B
Extents holding index data
- C
Extents holding temporary data
- D
Extents holding undo data
- ✓
- Question 10
ShopInn is a well-known online shopping store whose application is using oracle databases. The application is expecting an increase in online users as they are going to announce festival offers. The DBA received the request to increase the size of the instance to 128GB, to manage the upcoming user transactions.
Which of the below parameter need to be updated by the DBA to fulfill the above requirement?
- ✓
MEMORY_MAX_TARGET
Correct - B
SGA_TARGET
- C
PGA_AGGREGATE_TARGET
- D
MEMORY_TARGET
- ✓
More in IMS Academy
Infosys Certified WebSphere Application Server 8.5 Administrator
Infosys Certified Windows 11 Administrator - Associate
Infosys Certified Windows Server 2022 Administrator – Associate
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.