8 Oct Issuu is a digital publishing platform that makes it simple to publish magazines, catalogs, newspapers, books, and more online. Easily share. Ashima Mittal is the author of Oracle DBA Interview Questions ( avg rating, 1 rating, 0 reviews) and Oracle DBA Interview Questions, ed ( avg. Oracle DBA Interview Questions by Ashima Mittal, , available at Book Depository with free delivery worldwide.

Author: Neshura Vudoshakar
Country: Belize
Language: English (Spanish)
Genre: Love
Published (Last): 6 July 2013
Pages: 268
PDF File Size: 16.12 Mb
ePub File Size: 11.50 Mb
ISBN: 884-5-26558-847-8
Downloads: 1647
Price: Free* [*Free Regsitration Required]
Uploader: Kajisar

The benefit of taking a hot backup is that the database is still available for dbaa while the backup is occurring and you can recover the database to any point in time. Write a Testimonial Few good words, go a long way, thanks! How would you determine who has added a row to a table? You could use Logminer or Streams You should also look at the logic involved in the application getting the error message. Requirements Engineering Fundamentals Klaus Pohl.

OpenShift in Action Jamie Duncan. A data block is the smallest unit of logical storage for a database object. What command would you use to create a backup control file?

Ashima Mittal (Author of Oracle DBA Interview Questions)

While a procedure does not have to return any values to the calling application, a function will return a single value. Beginning Django Daniel Rubio. Other Books By Author. Home Oracle Dba Interview Questions. SapnaOnline offers Free shipment all across India for orders above Rs and Global Shipment at the most economical cost. Monday to Saturday 9. At SapnaOnline we believe that customer satisfaction is utmost important hence all our efforts are genuinely put into servicing the customer’s in the best possible way.


The Job Queue Processes.

What does coalescing a tablespace do? They are also used to pipeline information in an ETL process. When creating a user, what permissions must you grant to allow them to connect to the database? Practical Programming Paul Gries. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables. Describe what redo logs are.

Creative Selection Ken Kocienda. The benefit of taking a cold backup is that it is typically easier to administer the backup and recovery process.

What view would you use to determine free space in a tablespace? Partitioning is a method of taking large tables and indexes and splitting them into smaller, more manageable pieces. These groupings of contiguous data blocks are called extents. Concurrency in Go Katherine Cox-Buday. Comics And General Novels.

She holds BE Hons. The team is committed to excellence-excellence in quality of content, excellence interviea the dedication of its authors and editors, excellence in the attention to detail, and excellence in understanding the needs odacle its readers.

Materialized views are objects that are reduced sets of information that have been summarized, grouped, or aggregated from base tables. Coalescing is only valid for dictionary-managed tablespaces and de-fragments space by combining neighboring free extents into large single extents.

Tag: Oracle DBA Interview Questions By Ashima Mittal Pdf Free Download

By using our website you agree to our use of cookies. How would you do this without affecting the children tables? A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. Explain materialized views and how they are used. SapnaOnline provides online shopping for over 10 Million Book Titles in various languages and genres. If you need any of your orders’ to be delivered outside of India, please reach out to us via our contact us page with the product details and delivery location for us to quote you the best possible shipping price.


The difference between the two is that ashuma truncate command is a DDL operation and just moves the high water mark and produces a now rollback. What background process refreshes materialized views?

Average Rating Customers. Fact tables and dimension tables. Ashima Mittal is passionate about databases as a technology and is very hands-on with trouble-shooting and performance tuning. These two Oracle utilities are used for loading data into the database.

Name three advisory statistics you can collect. You have mlttal had to restore from backup and do not have any control files.

Give two methods you could use to determine what DDL changes have been made. Why Shop at SapnaOnline. The Software Mittxl Sandro Ashimma. Login Please enter your login details. Create a plan table with utlxplan. Sorry, out of stock. I would create a text based backup control file, stipulating where on disk all the data files where and then issue the recover command with the using backup control file clause.

Please enter valid pincode to check Delivery available unavailable in your area.