Infosys Certified Oracle 10g Database Administrator
Practice with real exam-pattern questions for Infosys Certified Oracle 10g Database 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 Oracle 10g Database Administrator practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Oracle 10g Database Administrator certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
State true or false. SGA_TARGET is a static parameter ?
- ✓ a. True Correct
- B b. False
- Question 2
The user is trying to execute a SELECT statement. Which of the following background processes will obtain data from a disk for the user?
- ✓ a. DISPATCHER Correct
- B b. USER
- C c. SERVER
- D d. LGWR
- E e. DBW0
- Question 3
Which three statements regarding Automatic Database Diagnostic Monitor (ADDM) are correct? a. ADDM targets the tuning of individual user response times. b. ADDM also documents the non problem areas of the system. c. ADDM analyzes online transaction processing (OLTP) systems only. d. An ADDM analysis is performed each time a statspack snapshot is taken. e. Each ADDM finding has one or more recommendations associated with it. f. ADDM analyzes the snapshots stored in Automatic Workload Repository (AWR) on a regular basis.
- ✓ a. a,b,c Correct
- B b. c,e,d
- C c. d,f,a
- D d. b,e,f
- E e. c,f,a
- Question 4
You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What should you do? a. set SQL_TRACE=true b. set UNDO_RETENTION=14400 c. set FAST_START_MTTR_TARGET=240 d. set LOG_CHECKPOINT_INTERVAL=240 e. set DB_FLASHBACK_RETENTION_TARGET=14400 f. issue ALTER DATABASE FLASHBACK ON; command g. set the RETENTION GUARANTEE clause for the undo tablespace
- ✓ a. a,c Correct
- B b. b,e
- C c. c,f
- D d. d,g
- E e. b,g
- Question 5
State True or False: We can see the progress of the backup taken by exp command ?
- ✓ a. True Correct
- B b. False
- Question 6
You decided to use Oracle Managed Files (OMF) for the control files in your database. Which initialization parameter do you need to set to specify the default location for control files if you want to multiplex the files in different directories?
- ✓ a. DB_FILES Correct
- B b. DB_CREATE_FILE_DEST
- C c. DB_FILE_NAME_CONVERT
- D d. DB_CREATE_ONLINE_LOG_DEST_n
- Question 7
Multiple Answers Question: While installing database, which of the following is NOT a part of prerequisite checks, select all that applies.
- ✓ a. Adequate temporary space Correct
- B b. OS Patch level
- C c. System and kernel parameters
- D d. Correct OS
- Question 8
Examine the following command to create an external table from EMPLOYEES and DEPARTMENTS database tables. CREATE TABLE employee_ext (employee_id, first_name, department_name) ORGANIZATION EXTERNAL (TYPE ORACLE_LOADER DEFAULT DIRECTORY ext_dir LOCATION (‘emp1.dmp’)) PARALLEL AS SELECT e.emplyee_id, e.first_name, e.last_name, d.department_name FROM employees e, departments d; Which line of the command would cause an error?
- ✓ a. line 2, because the column names have been specified Correct
- B b. line 7, because file name must have a .dat extension
- C c. line 3, because ORGANIZATION EXTERNAL has been specified
- D d. line 9, because the PARALLEL option cannot be specified with one file name
- E e. line 12, because there is no join defined between EMPLOYEES and DEPARTMENTS table
- Question 9
The SQL Access Advisor may recommend additional structures to improve the performance of SQL statements. You can select the type of structure recommended by the SQL Access Advisor. Which two structures can you select? a. Indexes b. Partitions c. Synonyms d. Sequences e. Database links f. Materialized views g. Hash or index clusters h. Index-Organized Table
- ✓ a. b,c Correct
- B b. d,e,g,h
- C c. a,e,g
- D d. c,f,h
- E e. a,f
- Question 10
Out of following which one is NOT a law for database security?
- ✓ a. Sarbanes-Oxley Act Correct
- B b. Health Information Portability and Accountability Act
- C c. California Breach Law
- D d. UK Data Protection Act
- E e. None of the choices
More in Oracle Enterprise Applications
Infosys Certified PL-SQL Associate
Infosys Certified Oracle B2B Service Cloud Consultant
Infosys Certified Oracle Financial Consolidation and Close Cloud Services Consultant
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.