Oracle Interview Questions and Answers for Beginners - 1
What is a user defined lock?
Oracle manages database resources through locking mechanism.
These locks are usually managed by the system and are released on commit or rollback of a transaction.
However, Oracle has provided this functionality to the users so that they can create user defined locks.
These locks are similar to system created locks in functionality but are not released automatically when transaction commits or rollbacks. Therefore, a user has to be extremely careful while using user defined locks.
What functionality does Oracle provide to secure sensitive information?
You can use the dbms_obfuscation_toolkit package to encrypt sensitive information.
The Data Encryption Standard (DES) or triples DES algorithm can be used to encrypt the data.
List some of the procedures provided by the dbms_aq package.
Some of the procedures provided by the dbms_aq package are enqueue, dequeue, register and unregister.
How can you grant privileges on AQ to other users?
You cannot grant privileges on AQ by using grant statement similar to other Oracle objects.
grant_system_privilege – Grants AQ system privileges
revoke_ system_privilege – Revokes AQ system privileges
grant_queue_privilege – Grants privileges on AQ
revoke_queue_privilege – Revokes privileges on AQ.
How can you enable flashback feature?
Oracle provides the dbms_flashback package to use flashback feature.
The package has the following procedures to facilitate this feature:
7000+ TNPSC Group 1, 2, 4, VAO Indian Economy Study Materials Pdf More
7000+ Gate Computer Science Engineering Previous Year Questions More
7000+ Fill in the Blanks with Suitable Homonyms More
7000+ Fill in the Blanks with Suitable Homophones More
Power Semiconductor Device and Integrated Circuits MCQ Questions Pdf More
1000+ GATE Civil Engineering Question Papers 2023 - 2024 More
Important Days and Dates General Knowledge Questions 2020-21 More
Top 50+ Applied Biology Quiz Questions for TNPSC, NEET Exams 2019-2020 More
C#- VB.NET Winforms Interview Questions and Answers More
List of Presidents of India From 1947-2019 Pdf Download More