Placement papers on Oracle - Set 3
1. Which privilege is used to allow creating or altering a system trigger on the database?
Administrator database trigger
alter any trigger
create trigger View Answer / Hide Answer
ANSWER: Administrator database trigger
2. Once trigger is created its source code is stored in which types of data dictionary view?
System_trigger View Answer / Hide Answer
3. ____________________ is the process of copying the schema objects and data from a source third-party (non-Oracle) database to an Oracle database.
OperationView Answer / Hide Answer
4. When there is more than one external agent running or configured at that time which clause allows run-time identification of the external agent program?
REFERENCEView Answer / Hide Answer
5. Which PL/SQL function uses java libraries to impose a limit on method definitions?
Java library function
None View Answer / Hide Answer
6. Oracle Advanced Security supports Triple-DES encryption, which encrypts message data with three passes of the _____________________
AES View Answer / Hide Answer
7. Which is an oracle analytic function?
group by rollup
Sum View Answer / Hide Answer
8. Which LOBs use copy semantics?
CLOBs View Answer / Hide Answer