Skip to main content

Free Online Books Tutorials interview questions

Book Reviews
Interview Questions
Magazine Feeds
Online Books

Home » Interview Questions » Database

Database Basic Set 1

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

Database Basic Set 1

Explain normalization with examples.
What cursor type do you use to retrieve multiple recordsets?
Diffrence between a "where" clause and a "having" clause
What is the difference between "procedure" and "function"?
How will you copy the structure of a table without copying the data?
How to find out the database name from SQL*PLUS command prompt?
Tadeoffs with having indexes
Talk about "Exception Handling" in PL/SQL?
What is the diference between "NULL in C" and "NULL in Oracle?"
What is Pro*C? What is OCI?
Give some examples of Analytical functions.
What is the difference between "translate" and "replace"?
What is DYNAMIC SQL method 4?
How to remove duplicate records from a table?
What is the use of ANALYZing the tables?
How to run SQL script from a Unix Shell?
What is a "transaction"? Why are they necessary?
Explain Normalizationa dn Denormalization with examples.
When do you get contraint violtaion? What are the types of constraints?
How to convert RAW datatype into TEXT?
Difference - Primary Key and Aggregate Key
How functional dependency is related to database table design?
What is a "trigger"?
Why can a "group by" or "order by" clause be expensive to process?
What are "HINTS"? What is "index covering" of a query?
What is a VIEW? How to get script for a view?
What are the Large object types suported by Oracle?
What is SQL*Loader?
Difference between "VARCHAR" and "VARCHAR2" datatypes.
What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table.
Difference between "ORACLE" and "MICROSOFT ACCESS" databases.
How to create a database link ?

‹ Database up Oracle DBA Interview questions ›

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