Skip to main content

Free Online Books Tutorials interview questions

Book Reviews
Interview Questions
Magazine Feeds
Online Books

Home » Interview Questions » Database

Oracle Job Interview questions PL/SQL SQL

Submitted by bookman on Wed, 10/28/2009 - 00:44

Oracle Job Interview questions PL/SQL SQL

Explain the difference between a hot backup and a cold backup and the benefits associated with each
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
How do you switch from an init.ora file to a spfile?
Explain the difference between a data block, an extent and a segment.
Give two examples of how you might determine the structure of the table DEPT.
Where would you look for errors from the database engine?
Compare and contrast TRUNCATE and DELETE for a table.
Give the reasoning behind using an index.
Give the two types of tables involved in producing a star schema and the type of data they hold.
What type of index should you use on a fact table?
Give two examples of referential integrity constraints.
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
What command would you use to create a backup control file?
Give the stages of instance startup to a usable state where normal users may access it.
What column differentiates the V$ views to the GV$ views and how?
How would you go about generating an EXPLAIN plan?
How would you go about increasing the buffer cache hit ratio?

‹ Oracle DBA Interview questions up Oracle, DBA, Developer Candidates ›

Login or register to post comments

Tags in Tags

Cardiovascular System Computer Science Database Books DERMATOLOGY DIGESTIVE DISEASES GENARAL MEDICINE General GENETICS GYNECOLOGY AND OBSTETRICS Hardware Books HIV AIDS INFECTIOUS DISEASES Java Books Languages Math Books Medical Books Microsoft Books Networking NEUROSCIENCE NUTRITION ONCOLOGY Operating Systems OPHTHALMOLOGY Other Books PEDIATRICS PHARMACOLOGY RADIOLOGY Software Engineering UROLOGY Web Services and web Development

Book navigation

Art and Photography

Biographies and Memoirs

Book Reviews

Business and Investing

Comics and Graphic Novels

Computer Science

Computers and Internet

Cooking and culinary

Crafts and Hobbies

Engineering

Entertainment

Health and Life

History

Home and Garden

Interview Questions

Literature and Fiction

Magazine Feeds

Mathematics Books

Medicine

Mystery and Thrillers

Nonfiction

Online Books

Parenting and Families

Politics

Reference

Science Books

Self-Help

Sports

Text Books

Travel

User login

Username: *

Password: *

Create new account
Request new password

Follow on Twitter

Follow us on Twitter

Navigation

Popular content
Recent posts
Feed aggregator

Latest Online books

microsoft press microsoft windows communication foundation step by step
Inside Windows Communication Foundation
Essential Windows Communication Foundation (WCF): For .NET Framework 3.5
Microsoft .NET Server Solutions for the Enterprise
Microsoft .NET for Programmers
Expert C# 2008 Business Objects
Exam 70-536 Microsoft .NET Framework 2.0 Application Development Foundation
Visual Diagnosis in Emergency and Critical Care Medicine
Manual of Emergency and Critical Care Ultrasound
sex positions complete guide
.NET Development Security Solutions
Professional Enterprise .NET
Microsoft Â® ADO.NET Step by Step (Step By Step (Microsoft))
How to Design Programs An Introduction to Computing and Programming
Algorithms and Complexity
Processor Architecture Laboratory
Writing device drivers in Linux: A brief tutorial
Linux Device Drivers Demystified
Writing a Linux device driver
Write a Linux Hardware Device Driver
Developing Linux Device Drivers using Libusb Programming Interface
Engineering Mathematics Frequently Asked Questions
Advanced engineering mathematics (7th edition)
MATHEMATICS FOR ELECTRICAL ENGINEERING AND COMPUTING
Mathematics for Computer Science
Advanced Calculus for Engineers
Mathematical Methods for Engineers II
ISMAILIA A NARRATIVE OF THE EXPEDITION TO CENTRAL AFRICA FOR THE SUPPRESSION OF THE SLAVE TRADE
In The Heart Of Africa By Sir Samuel W. Baker

(c)chilanti.com