techpreparation-homepage

Home  Interview Questions  Certifications  Aptitude Questions  Tutorials  Placement Papers  Search  Resume  Soft Skills  Video  Forum  Blog

Android app on Google Play

Technical Interview Questions
Oracle Interview Questions
MySql Interview Questions
MsSql Interview Questions
JDBC Interview Questions
                              .........More

Soft Skills
Communication Skills
Leadership Skills
                              .........More

 

 

  

Sql Interview Questions and Answers



CLIENT/SERVER

What does preemptive in preemptive multitasking mean ?
Preemptive refers to the fact that each task is alloted fixed time slots and at the end of that time slot the next task is started.

What does the OLTP stands for ?
OLTP stands for On Line Transaction Processing

What is the most important requirement for OLTP ?
OLTP requires real time response.

In a client server environment, what would be the major work that the client deals with ?
The client deals with the user interface part of the system.

Why is the most of the processing done at the sever ?
To reduce the network traffic and for application sharing and implementing business rules.

What does teh term upsizing refer to ?
Applications that have outgrown their environment are re-engineered to run in a larger environment. This is upsizing.

What does one do when one is rightsizing ?
With rightsizing, one would move applications to the most appropriate server platforms.

What does the term downsizing refer to ?
A host based application is re-engineered to run in smaller or LAN based environment.

What is event trigger ?
An event trigger, a segment of code which is associated with each event and is fired when the event occurs.

Why do stored procedures reduce network traffic ?
When a stored procedure is called, only the procedure call is sent to the server and not the statements that the procedure contains.

What are the types of processes that a server runs ?
Foreground process and Background process.

What is a event handler ?
An event handler is a routine that is written to respond to a particular event.

What is an integrity constraint ?
An integrity constraint allows the definition of certain restrictions, at the table level, on the data that is entered into a table.

What are the various uses of database triggers ?
Database triggers can be used to enforce business rules, to maintain derived values and perform value-based auditing.

What is a transaction ?
A transaction is a set of operations that begin when the first DML is issued and end when a commit or rollback is issued. BEGIN COMMIT/ROLLBACK are the boundries of a transaction.

Why are the integrity constraints preferred to database triggers ?
Because it is easier to define an integrity constraint than a database trigger.

Why is it better to use an integrity constraint to validate data in a table than to use a stored procedure ?
Because an integrity constraint is automatically checked while data is inserted into a table. A stored has to be specifically invoked.

What are the three components of a client server model ?
A Client,
A Server and
A Network/Communication software.

Page Numbers :   1         2         3         4        5        6        7        8        9        10       11

Have a Question ? post your questions here. It will be answered as soon as possible.

Check HTML Interview Questions for more HTML Interview Questions with Answers

Check Job Interview Questions for more Interview Questions with Answers