Oracle Core DBA Interview Questions Answers Pdf - 1
Who owns the operating system files created by the utl_file package?
The operating system files generated by utl_file are owned by operating system user Oracle.
What do you understand by flashback feature of Oracle?
Flashback feature allows you to use a flashback version of the database, that is, you can query the database from a state in the past based on a specific System Change Number (SCN) or time in the past.
How can you communicate with operating system files from Oracle?
You can use the utl_file package to communicate with operating system files from PL/SQL code.
This package provides multiple functions to open, read, write and close the operating system files.
How can you create a user defined lock?
The dbms_lock package can be used to create user defined locks.
Does Oracle provide any package to deal with materialized views?
You can use the dbms_mview package to deal with materialized views. It is also called dbms_snapshot.
Some of the procedures provided by the dbms_mview packages are as given follows:
BEGIN_TABLE_REORGANIZATION – Performs a process to preserve materialized view data needed for refresh.
END_TABLE_REORGANIZATION – Ensures that the materialized view data for the master table is valid and that the master view or potential materialized view.
EXPLAIN_MVIEW – Explains what is possible with a materialized view or potential materialized views.
EXPLAIN_REWRITE – Explains why a query failed to rewrite
7000+ Direct and Indirect Speech worksheets with Answers More
7000+ Phrasal Verbs Quiz with Answers Pdf More
7000+ Multiple Choice Questions on Phrasal Verbs with Answers Pdf More
7000+ Linkers in English Grammar 2024 - 2025 Exercises Pdf More
7000+ Linkers and Connectors Exercises with Answers Pdf More
Hidden Tricky Picture Puzzles with Answers More
1000+ Chemistry Questions for SSC CGL Tier 1, Tier 2 Exam Pdf More
1000+ Maths Riddles for Adults with Answers Pdf More
PG TRB Model Question Paper for Home science with Answer More
Java J2EE Interview Questions for Senior Developers 2020-2021 More