-
DBMS analysis and Requirements
Imagine that you joined a company as DBA and your first task is to create test and production database environments for application developers and users. How would you analyze requirements for a new DBMS? Write your answer according to the requirements of Oracle 9i or 10g Enterprise database system.
-
-
Reading Oracle Control file content
Can we read Control file? If yes, then how?
-
-
-
-
Target Database RMAN Backup
What are the steps required to enable the RMAN backup for a target database?
-
Logical online backup
Can you take online backup of a Control file if yes, how? Explain about Logical Backup?
-
Two Phase Locking Protocol
Explain the concept of two phase locking protocol with an example?
-
Load Balancing on Oracle RAC Environment
In Oracle RAC 3-node environment, If one node is down then how will the sessions balance among the remaining two nodes?
-
High Water Mark
What is High Water Mark in Oracle?
-
-
JDBC driver
Why the Standard Oracle supplied JDBC driver cannot be used when using a Real Application Cluster?Decribe the differences between an Oracle Real Application Cluster and Oracle Deployed in a Sun Cluster?
-
-
-
When normalizing a table that can have a many to many relationship with another table, what steps should you take?
Looking for a detailed answer if possible
-
Scarlett
Turn three of your Scarlett Talent Agency entities into relations.
-
-
Oracle server down time
what are the necessary steps to be take when server gets down? How can we increase size of a database?
-
Database Admin Interview Questions
Ans