What is simple replication and advance replication? What is the difference between simple replication and advance replication? How can we do simple replication?
DBMS_meta_data. This parameter is very usefull. What you infer from this parameter. What info you will find in that. explain in detail.
Latest Answer: To find the structure of a external table we used this package.syntax is below:SELECT DBMS_METADATA.GET_DDL ('TABLE','')||';' FROM DUAL ...
What is Cache Fusion Technology?
Latest Answer: Cache Fusion is a new technology that uses a high speed interprocess communication (IPC) interconnect to provide cache to cache transfers of data blocks between instances in a cluster. This eliminates disk I/O (which is inherently slow, since it is a ...
What kind of backup you take Physical / Logical? Which one is better and Why?
What is your datafile size? How long it can go? What is the max limit to which you can extend?
Latest Answer: v$datafile data dictionary view will tell us the size of a datafile.to check the number of datafile you can check db_files init parameter. you can also alter this parameter but it will reflect after restartthe database.you can also resize the datafile ...
You have a database of 2GB. Can you convert the database to 1GB. Which compression parameter will you use?
Latest Answer: COMPRESSION =(METADATA_ONLY | NONE) - This parameter applies from Oracle 10.2. It specifies whether to compress metadata before writing to the dump file set. Compression reduces the amount of disk space consumed by dump files.To convert from 2 GB to 1 ...
What is Oracle Reserved Memory and Unreserved Memory? What is the size of Oracle Reserved Memory?
Can we create as many tablespace as we require. What is the limit? What is the default size of tablespace? (System and User tablespace). Mention name of some tablespace.
How you spend a day as a DBA. Explain DBA activities in detail.
What is the difference between Cost Based Optimizer and Rule Based Optimizer?(CBO is the default optimizer)
Latest Answer: In brief the rule-based method means that when executing a query the database must follow certain predefined rules and matter what data is stored in affected database tables. The cost-based method means the database must decide which query execution plan ...
View page << Previous 4 5 6 7 [8] 9 10 11 12 13 Next >>
Go Top
