Question bank
Oracle Database Administration I
44 Oracle Database Administration I questions with the correct answer and a written explanation, organised across 8 exam domains.
- 44 questions
- 8 domains
- Foundation level
certilumQuestion index
Jump straight to any question. Answers and explanations are inline.
Configuring Oracle Net Services
4 questions in this domain
- Question 1Single Choice
Which statement best describes the purpose of the tnsnames.ora file on an Oracle Net client?
- AMaps connect identifiers to connect descriptors.Correct answer
- BStores listener protocol endpoints.
- CContains encrypted client authentication data.
- DControls database instance resource limits.
Why this is the answer
tnsnames.ora is the local naming configuration file. It allows a client to use a net service name or connect identifier that resolves to a valid connect descriptor.
- Question 2Multiple Select
Which two statements correctly describe Oracle Net Listener responsibilities? (Select two.)
- AAccepts and forwards client connection requests.Correct answer
- BStores all database user passwords.
- CMay service several database instances.Correct answer
- DOptimizes SQL execution plans.
Why this is the answer
Oracle Net Listener receives initial connection requests and redirects or forwards them to a database service. One listener process can support multiple database instances through service registration.
- Question 3Interactive
The code block shows a configuration entry. Which file stores this entry on a dedicated Oracle Net listener host?
- Alistener.oraCorrect answer
- Btnsnames.ora
- Csqlnet.ora
- Dorapwd.ora
Why this is the answer
A listener.ora file holds the listener name and its protocol addresses. The example defines a listener named LISTENER using TCP on port 1521.
- Question 4Single Choice
What is the default TCP/IP port number on which an Oracle Net Listener accepts connections?
- A1521Correct answer
- B8080
- C1526
- D5500
Why this is the answer
The listener default port is 1521. If a nondefault port is needed, the listener.ora or service registration environment must use that alternate port.
Managing Database Instances
7 questions in this domain
- Question 5Single Choice
Which Oracle utility is the primary tool for moving logical data and metadata between databases or schemas?
- AOracle Data PumpCorrect answer
- BSQL*Loader
- CRMAN
- DAutomatic Workload Repository
Why this is the answer
Oracle Data Pump is the primary tool for logical data movement and metadata. SQL*Loader loads external files, RMAN handles physical backups, and AWR collects performance statistics.
- Question 6Multiple Select
Which types of objects can be moved with Oracle Data Pump?
- ATable data and metadataCorrect answer
- BEntire schemasCorrect answer
- COracle home binary files
- DDatabase alert log files
Why this is the answer
Oracle Data Pump operates on logical objects, including table data and schemas. It does not move operating system files such as Oracle home binaries or alert logs.
- Question 7Interactive
Examine the SQL command. What is the effect of executing the statement?
- AAn Oracle directory object for dump filesCorrect answer
- BA physical operating system directory
- CA table named DP_DIR
- DA database backup job
Why this is the answer
CREATE DIRECTORY creates a database directory object that points to an operating system location. It does not create the OS directory, a table, or a backup job.
- Question 8Single Choice
What is the output of a Data Pump export job called?
- ADump file setCorrect answer
- BControl file
- CParameter file
- DRedo log file
Why this is the answer
Data Pump Export writes logical copies of selected objects into a dump file set. Import later reads that dump file set to recreate the objects.
- Question 9Multiple Select
Which statements about SQL*Loader are true?
- ALoads external files into Oracle tablesCorrect answer
- BUses a control file for input formatCorrect answer
- CStarted with the sqlldr commandCorrect answer
- DCreates database backups
Why this is the answer
SQL*Loader uses the sqlldr client and a control file to load external data into Oracle tables. It does not create database backups.
- Question 10Interactive
Examine the Data Pump command. What job is started?
- AExports all HR schema objects to a dump fileCorrect answer
- BImports the HR schema from a dump file
- CDrops all objects owned by HR
- DExports the entire database
Why this is the answer
The parameters SCHEMAS=hr and DUMPFILE=hr.dmp start a schema-mode export. No import, deletion, or full database export is performed.
- Question 11Single Choice
Which Data Pump mode is selected by including the SCHEMAS parameter in an export command?
- ASchema modeCorrect answer
- BTable mode
- CFull database mode
- DTablespace mode
Why this is the answer
SCHEMAS selects schema mode export. Table mode uses TABLES, full mode uses FULL=Y, and tablespace mode uses TABLESPACES.
Managing Storage
7 questions in this domain
- Question 12Single Choice
Which Oracle Database utility creates a portable dump file set containing data and metadata for movement to another database?
- AOracle Data Pump ExportCorrect answer
- BSQL*Loader utility
- COracle Recovery Manager
- DDirectory object
Why this is the answer
Oracle Data Pump Export writes data and metadata into dump files that can be copied and imported into another Oracle database.
- Question 13Multiple Select
Which two types of content are saved in a dump file generated by Oracle Data Pump Export?
- ADatabase table dataCorrect answer
- BParameter file values
- CSchema object definitionsCorrect answer
- DInstance startup settings
Why this is the answer
Data Pump Export captures logical table data and metadata that describes schemas, including definitions of tables, indexes, constraints, and other objects.
- Question 14Interactive
Examine the command shown in the code block. Which Oracle Database utility is invoked by this command?
- AOracle Data Pump ExportCorrect answer
- BOracle Data Pump Import
- CSQL*Loader utility
- DOracle Recovery Manager
Why this is the answer
The expdp command is the command-line client for Oracle Data Pump Export, used here to move the hr schema into a dump file.
- Question 15Single Choice
Which Oracle Database feature allows SQL to read data from an operating-system file without loading it into the database?
- AExternal table featureCorrect answer
- BDirectory object
- CSQL*Loader utility
- DMaterialized view
Why this is the answer
An external table keeps rows in a flat file but exposes the file to SQL, allowing data to be selected without first loading it.
- Question 16Multiple Select
In an Oracle Database environment, which two statements about external tables are valid? Choose two.
- AData is stored outside the databaseCorrect answer
- BSQL can query the external dataCorrect answer
- CDirect updates can modify the file
- DRows are always stored in a tablespace
Why this is the answer
External tables point to OS files, so data is not stored in the database. They support SQL queries but do not support direct DML.
- Question 17Interactive
Read the SQL statement in the code block. What kind of database object is being created?
- AExternal tableCorrect answer
- BTemporary table
- CCluster table
- DIndex-organized table
Why this is the answer
The ORGANIZATION EXTERNAL clause defines an external table that reads data from an OS file through a directory object.
- Question 18Single Choice
Which Oracle Database object holds an operating-system path that the database can use for loading or exporting files?
- ADirectory objectCorrect answer
- BDatabase link
- CControl file
- DExternal file
Why this is the answer
A directory object stores the server OS path used by Data Pump and external tables when moving or reading files.
Managing Undo
4 questions in this domain
- Question 19Single Choice
Which Oracle utility is used to move data between Oracle databases by creating a binary dump file set?
- ASQL*Loader
- BOracle Data PumpCorrect answer
- CExternal tables
- DRecovery Manager
Why this is the answer
Oracle Data Pump Export creates a binary dump file set; Data Pump Import later reads that file set and moves objects and data into another Oracle database.
- Question 20Multiple Select
Which two statements are true about SQL*Loader? (Choose two.)
- AIt is invoked with the sqlldr command.Correct answer
- BIt uses a control file to describe the input data format.Correct answer
- CIt can be used only for Data Pump dump files.
- DIt automatically creates all target tables and indexes.
Why this is the answer
SQL*Loader loads data from external flat files into an Oracle database. It is started with sqlldr and uses a control file to interpret the input data.
- Question 21Interactive
You run the command shown in the code block. What is the expected result in the target database?
- ACreates schema metadata but no table data.Correct answer
- BImports rows into existing tables only.
- CDrops the imported schema objects before loading them.
- DCreates a backup of the dump file set.
Why this is the answer
The CONTENT=METADATA_ONLY parameter tells Data Pump Import to restore object definitions only. No table rows are loaded into the target schema.
- Question 22Single Choice
Which statement is true when a table is created as an external table?
- ARows are stored in the SYSTEM tablespace.
- BRows are read directly from the operating-system flat file.Correct answer
- CThe flat file is deleted after the table is accessed.
- DUPDATE statements modify the flat file directly.
Why this is the answer
External tables read flat-file data directly without loading that data into a database segment. They do not own the data and cannot be updated directly.
Managing Users, Roles and Privileges
7 questions in this domain
- Question 23Single Choice
In Oracle Database, which definition best describes what a privilege is compared to other security objects?
- ARight to execute SQL or access objectsCorrect answer
- BEncryption rule for stored passwords
- CStorage limit assigned to a tablespace
- DBackup schedule configured by an administrator
Why this is the answer
A privilege is the right to run a particular SQL statement or to access another schema's object. Privileges are security grants, not encryption, storage, or backup settings.
- Question 24Multiple Select
In Oracle Database, which of the following are classified as system privileges? Select all that apply.
- ACREATE SESSIONCorrect answer
- BALTER SYSTEMCorrect answer
- CUPDATE ON hr.employees
- DCREATE TABLECorrect answer
Why this is the answer
CREATE SESSION, ALTER SYSTEM, and CREATE TABLE are system privileges. UPDATE ON hr.employees applies to a specific table, so it is an object privilege.
- Question 25Interactive
Look at the GRANT command shown in the code block. What category of privileges is being granted to user SCOTT?
- AObject privilegesCorrect answer
- BSystem privileges
- CRole privileges
- DResource privileges
Why this is the answer
The SELECT and INSERT privileges are granted on the hr.departments table. Privileges on a specific object are object privileges rather than system privileges.
- Question 26Single Choice
In a CREATE USER statement for an Oracle user, what is the function of the DEFAULT TABLESPACE clause?
- ASets where permanent objects are storedCorrect answer
- BSets where temporary sort data is stored
- CSets where undo data is recorded
- DSets how often the password must change
Why this is the answer
The DEFAULT TABLESPACE clause establishes where the user's permanent objects, such as tables and indexes, are stored when no tablespace is named.
- Question 27Multiple Select
Which of the following statements about Oracle roles are true? Select all that apply.
- AA role is a named group of privilegesCorrect answer
- BRoles can include both system and object privilegesCorrect answer
- CRoles simplify privilege administrationCorrect answer
- DRoles cannot be granted to other roles
Why this is the answer
A role is a named set of privileges and can be granted to users or other roles. Roles contain system and object privileges and reduce the number of individual GRANT statements.
- Question 28Interactive
Review the SQL statements in the code block. After these commands run, what does user JOE receive?
- APrivileges contained in role HR_CLERKCorrect answer
- BDirect SELECT privilege only on HR.EMPLOYEES
- CCREATE SESSION privilege only
- DOwnership of tablespace USERS
Why this is the answer
Granting a role to a user activates the role's combined privileges. Since HR_CLERK contains CREATE SESSION and SELECT on HR.EMPLOYEES, Joe has those privileges through the role.
- Question 29Single Choice
In Oracle Database, which statement correctly defines a role as it is used for access control and privilege management?
- AA named group of privilegesCorrect answer
- BA disk area for database backups
- CA user account with DBA rights
- DA SQL command to reset passwords
Why this is the answer
Roles are database objects that bundle related privileges. They simplify security by allowing the same grant to be assigned to many users or other roles.
Moving Data
4 questions in this domain
- Question 30Single Choice
Which Oracle tool is designed for logical data movement between Oracle databases?
- AOracle Data PumpCorrect answer
- BSQL*Loader
- CRecovery Manager (RMAN)
- DAutomatic Storage Management (ASM)
Why this is the answer
Oracle Data Pump performs logical exports and imports using dump files. SQL*Loader loads external files; Recovery Manager is used for physical backup.
- Question 31Multiple Select
Which two command-line clients are used for Oracle Data Pump operations? (Choose two.)
- AexpdpCorrect answer
- BimpdpCorrect answer
- Csqlldr
- Drman
Why this is the answer
expdp starts a Data Pump export and impdp starts a Data Pump import. sqlldr and rman are used by SQL*Loader and Recovery Manager instead.
- Question 32Interactive
View the Data Pump command shown in the code block. What operation is the command performing?
- AIt imports the HR schema
- BIt exports the HR schemaCorrect answer
- CIt creates a directory object
- DIt loads external table data
Why this is the answer
Because the command starts with expdp and includes SCHEMAS=hr, it performs a Data Pump schema export for the HR schema.
- Question 33Single Choice
Which Oracle object identifies the operating system directory Data Pump can use?
- ADirectory objectCorrect answer
- BTablespace
- CExternal table
- DDatabase link
Why this is the answer
A directory object maps an Oracle name to an operating system directory, providing the location for Data Pump dump and log files.
SQL Fundamentals for DBA
4 questions in this domain
- Question 34Single Choice
Which Data Pump command-line client is used to export data and metadata to a dump file?
- Aimpdp
- BexpdpCorrect answer
- CSQL*Loader
- DRMAN
Why this is the answer
expdp is Oracle Data Pump's export client. It writes schema objects and data to a dump file set; impdp performs the import direction.
- Question 35Multiple Select
Which Oracle utilities or features are commonly used to move data into or out of an Oracle database? Select all that apply.
- AData Pump export and importCorrect answer
- BAutomatic Storage Management
- CExternal tablesCorrect answer
- DSQL*LoaderCorrect answer
Why this is the answer
Data Pump, SQL*Loader, and external tables are standard Oracle options for moving data into or out of a database. ASM manages storage but does not move logical data.
- Question 36Interactive
Examine the Data Pump export command in the code block. What does the schema parameter limit the export to?
- AThe objects in the specified schema are overwritten in the target database.
- BThe entire database is exported without object filtering.
- COnly the objects owned by the specified schema are unloaded.Correct answer
- DThe specified schema is created and then removed during the export.
Why this is the answer
The SCHEMAS parameter identifies the schema owner. Only objects owned by that schema are written to the dump file; other schemas are not exported.
- Question 37Single Choice
What is a directory object used for in an Oracle Data Pump operation?
- AA database object that points to an operating-system directory on the server.Correct answer
- BA table that stores all control-file information for Data Pump.
- CA named file containing database users and privileges.
- DA virtual directory inside the SYSTEM tablespace.
Why this is the answer
Directory objects map a name to an operating-system directory. Data Pump uses them to locate dump files, log files, and other files.
Understanding Oracle Database Architecture
7 questions in this domain
- Question 38Single Choice
In the context of moving data between Oracle databases, what is Oracle Data Pump primarily designed to accomplish?
- AHigh-speed server-side export and import of logical dataCorrect answer
- BPhysical backup of database data files
- CNetwork traffic monitoring and tuning
- DStorage reallocation within tablespaces
Why this is the answer
Oracle Data Pump runs on the database server and moves logical data and metadata in dump file sets.
- Question 39Multiple Select
Within Oracle Database administration, which two statements correctly describe the behavior and purpose of SQL*Loader?
- ALoads data from external files into tablesCorrect answer
- BUses a control file to define loading rulesCorrect answer
- CUsed for logical database export
- DPerforms recovery after media failure
Why this is the answer
SQL*Loader reads data from external files and loads it into Oracle tables using a control file. It is not an export or recovery tool.
- Question 40Interactive
Examine the command in the code block and identify which Oracle Database utility is being invoked.
- AOracle Data Pump ImportCorrect answer
- BOracle Data Pump Export
- CSQL*Loader
- DRecovery Manager
Why this is the answer
The impdp command starts Oracle Data Pump Import, which reads a dump file set and loads objects into an Oracle database.
- Question 41Single Choice
Before running a Data Pump job, which database object identifies the operating system directory for dump files?
- ADirectory objectCorrect answer
- BTablespace
- CProfile
- DSynonym
Why this is the answer
A directory object stores the operating system path where Data Pump reads or writes files. The user must be granted read and write privileges on it.
- Question 42Multiple Select
During an Oracle Data Pump export job, which two file types are normally generated on the server?
- ADump file setCorrect answer
- BLog fileCorrect answer
- CControl file
- DOracle Net configuration file
Why this is the answer
Data Pump creates dump files containing data and metadata and a log file that records the job's progress. Control files and Oracle Net files are not part of Data Pump.
- Question 43Interactive
Review the code block and select the task that the command in the code block performs.
- ALoads data from file into a database tableCorrect answer
- BExtracts logical database data
- CCreates a new Oracle database
- DGenerates an Oracle alert log
Why this is the answer
The sqlldr command invokes SQL*Loader, which reads data from an external file and stores it in an Oracle table according to a control file.
- Question 44Single Choice
Which statement most accurately describes how an external table is stored and accessed in Oracle Database?
- AData lives in OS files and is SQL-readableCorrect answer
- BData is stored in database tablespaces
- CDML operations are fully supported
- DData files vanish after the last query
Why this is the answer
An external table describes an operating system file using database metadata. You can query it with SQL, but normal DML operations cannot change it.
Frequently asked questions
Everything about the Oracle Database Administration I question bank and how to use it.