Topic : Architecture

Do you consider yourself a development DBA or a production DBA and why?


Answer :

"Never in my database carrier have I distinguished between ""development"" and ""production."" Just ask your development staff or VP of engineering how much time and money is lost if development systems are down. Explain to the interviewer that both systems are equally important to the operation of the company and both should be considered as production systems because there are people relying on them and money is lost if either one of them is down. Ok you may be saying; and I know you are; that we lose more money if the production system is down. Ok; convey that to the interviewer and you won't get anyone to disagree with you unless your company sells software or there are million dollar deals on the table that are expecting the next release of your product or service."

Show Answer Discuss

What are the Large object types sported by Oracle?


Answer :

1)bfile - Up to 4 gigabytes ?> File locators that point to a read-only binary object outside of the database
2)blob - Up to 4 gigabytes. ?> LOB locators that point to a large binary object within the database
3)clob - Up to 4 gigabytes. ?> LOB locators that point to a large character object within the database
4)nclob - Up to 4 gigabytes. ?>LOB locators that point to a large NLS character object within the database

Show Answer Discuss

What are the benefits of ORDBMS?


Answer :

The objects as such can be stored in the database. The language of the DBMS can be integrated with an object- oriented programming language. The language may even be exactly the same as that used in the application; which does not force the programmer to have two representations of his objects.

Show Answer Discuss

What are different Oracle database objects?


Answer :

TABLES
VIEWS
INDEXES
SYNONYMS
SEQUENCES
TABLESPACES

Show Answer Discuss

What are the role of DBA?


Answer :

DBA has the authority to create new users; remove existing users or modify any of the environment variables or privileges assigned to other users.
Manage database storage
Administer users and security
Manage schema objects
Monitor and manage database performance
Perform backup and recovery
Schedule and automate jobs

Show Answer Discuss