Oracle Database 12c: Advanced Administration — Question 95
database, you attempt to load data into the HR.EMPLOYEES table in a pluggable database (PDB):
Which three are true? (Choose three.)
Answer options
- A. It creates the HR.EMPLOYEES table in the PDB and loads data into it if the table does not exist in the PDB to which HR connects.
- B. It succeeds if HR is a local user in the PDB to which HR connects.
- C. It loads data into HR.EMPLOYEES if the table exists in the PDB to which HR connects.
- D. It succeeds if HR is a common user.
- E. It loads data into HR.EMPLOYEES if the table exists in CDB$ROOT.
Correct answer: A, B, C
Explanation
Option A is correct because sqlldr will create the table if it doesn't exist in the specified PDB. Option B is accurate as the HR user must be local to the PDB for the operation to succeed. Option C is also correct since data will be loaded into the existing HR.EMPLOYEES table. Options D and E are incorrect because they do not pertain to the behavior of the sqlldr command in the context of a PDB.