1.
What is RDBMS? List example of RDBMS packages.
2.
State the full form of SQK. What is role of SQL
with respect of RDBMS package? List out the major features of SQL
3.
Explain in brief the different between SQL and
SQL* Plus
5.
__________is the default format for entering
values in oracle table.
6.
State the rule for naming table and column in
oracle.
7.
What is precision and scale with reference to
number datatype? Give an Example
8.
Why variable substitution method not preferred
while entering data into an Oracle table?
9.
What is a constraint? List out the different of
constraints that can be define on Oracle table
10.
Define- Primary Key, Foreign Key and Composite
Key or Composite Primary Key.
11.
List the two add addition clauses that can be
given along with the foreign key constraint.
12.
State the differences between a primary key
constraint and unique constraint.
13.
Under what circumstances is a constraint always
defined at table level?
14.
What type of information is stored in user_constraints?
15.
Explain in details the various operations than
can be performed with the ALTER statement.
16.
State the different between DELETE, DROP and
TRUNCATE statements.
17.
Is list possible to recover a deleted table?
Justify with proper reasons.
18.
Which operator is used for NULL value
comparison?
19.
State the two wildcard characters used with
pattern matching operator.
20.
State the different between the range searching
operator/predicate.
21.
What is the derived or calculated column with
reference to SELECT SQL statement?
No comments:
Post a Comment