 |
|
| |
Facing the technical interview of a
company is an uphill task. It all depends on the mood of
the interviewer and to an extent on your appearance. If
he is in a bad mood, the interview can be really tough.
Otherwise you might have a slight consideration. Be
prepared for any questions from every section of your
skill set. If the interviewer goes to a part of your
skill, which you are not comfortable with, try to divert
his attention to some other part in which you are an
expert. Try to explain things in a simple way and be
precise in your answers. If you don't know an answer
admit it. Do Not try to make up and answer. |
 |
DBMS - RDBMS Interview Questions
* How to copy SQL table?
* How can i hide a particular table
name of our schema.
* What is the main difference between
the IN and EXISTS clause in sub
queries??
* In sub queries, which is efficient
,the IN clause or EXISTS clause? Does
they produce the same result?
* What is difference between DBMS and
RDBMS?
* How to test the complex view using
manually testing?
* When using a count (distinct) is it
better to use a self-join or temp
table to find redundant data
* What is the advantage to use trigger
in your PL?
* What is materialized View?
* What the difference between UNION
and UNION ALL?
* How to find out the 10th highest
salary in SQL query?
*What is the parameter substitution
symbol used with INSERT INTO command?
* Which command displays the SQL
command in the SQL buffer, and then
executes it?
* What are the wildcards used for
pattern matching?
* What are the privileges that can be
granted on a table by a user to
others?
* Which system tables contain
information on privileges granted and
privileges obtained?
* What is the use of the DROP option
in the ALTER TABLE command?
* Which is the subset of SQL commands
used to manipulate Oracle Database
structures, including tables
* What operator performs pattern
matching?
* What is the difference between
Single row sub-Query and Scalar
sub-Query?
* How do I write a cron which will run
a SQL query and mail the results to a
group?
* What is difference between
Co-related sub query and nested sub
query?
* When we give SELECT * FROM EMP; How
does oracle respond?
* What is reference cursor?
* What operator performs pattern
matching?
* Which system table contains
information on constraints on all the
tables created?
* What is the difference between
TRUNCATE and DELETE commands?
* What command is used to create a
table by copying the structure of
another table?
* Difference between Store Procedure
and Trigger?
* Cursor Syntax brief history?
* Explain normalization with examples?
* How to find out the database name
from SQL*PLUS command prompt?
* How can we backup the sql files &
what is SAP?
* Whats the back end processes when we
type "Select * from Table"?
* What is the difference between SQL
and SQL Server?
* What is table space? |
|
|
| |
|
|
|