SQL QUESTIONS.
1) How do
I list all of my tables?
2) Create
one table from another table without copying the data from the first table.
3) How do
I select from different user’s tables?
4) What
is SQL?
5) What
is a function in oracle?
6) What
is the default format of date in Oracle? How can I change my default date
format?
7) What
is a view? What are its advantages?
8) What
is a synonym?
9) What
is PL/SQL?
10)What
is an Index? Why it is useful?
11)What
is PL/SQL?
12)Mention
some features of Oracle 9i database.
13) Mention
some features of Oracle 10g database.
14)What
is the meaning of “i”
and “g” in 9i & 10g respectively?
15)What
is the purpose of joining the tables? Explain different types of Joins.
16)What
are the data types available in Oracle? Explain.
17)What
is Database Link?
18)What
is Tuning? Explain.
19)What
is DDL? Give examples.
20)What
is DML? Give examples.
21)What
is a Sequence?
22)Write
a query to eliminate duplicates rows from a table?
23)How
does one implement IF-THEN-ELSE in a select statement?
24)How we
can send the query output to a file?
25)Display
the Department Names that are having more than 4 employees in it?
26)What
is SQL* Loader?
27)What
is Export & Import?
28)Write
the syntax to add Foreign Key?
29)Write
the syntax to create Composite Primary Key?
30)How to
run the SQL statements from a file?
31)What
is a schema?
32)What
are roles & privileges?
33)What
are sub query statements and co-related sub query statements?
34)What
is Data, Database and DBMS?
35)What
are the types of DBMS?
36)What
is Entity, Attribute and Relationship?
37)What
are the types of Attributes?
38)What
are the types of Entities?
39)What
is a constraint?
40)What
is primary and foreign keys?
41)What
are various type of oracle software?
42)what
is RDBMS?
43)what
is SQL statements, list all?
44)what
is projection, selection and join?
45)Display
all rows and columns of department table?
46)10-2+20/2*3?
47)What
is the output for select 1,2,3 from empty?
48)What
is distinct?
49)What
is concatenation operator?
50)What
is spooling? APPEND?
51)What
are comparison conditions?
52)What
are logical conditions?
53)What
are SQL functions, and types?
54)What
are character functions, and types?
55)What
are dates & example also?
56)Display
all the managers working 20 & 30 dept.
57)Display
all the employee whose name doesn’t end with. ‘MAN’
58)Display
all the employee whose annual salary is ending with ‘MAN’
59)What
is data functions & data types?
60)What
is conversion functions?
61)What
is group functions & their types?
62)What
is DDL? create? alter? rename? truncate?
63)What
is DML? Insert? Update? Delete?
64)What
is DTL? Commit? Savepoint? Rollback?
65)What
is DCL? Grant? Revoke?
66)What
is Join? Cartesian product?
67)Types
of Join? Outer Join ? Inner join?
68)Explain
all 12 Codd’s rules?
69)What
is normalization?
70)What
are normalization form types?
71)What
is de normalization?
72)Increase
the salaries of all the employees by 10% for the departments that are common in
both of these tables.
Table1
|
Deptno
|
Empno
|
Sal
|
|
10
|
1
|
1000
|
|
10
|
2
|
3000
|
|
20
|
3
|
2000
|
|
30
|
4
|
6000
|
|
20
|
5
|
1000
|
|
60
|
6
|
9000
|
|
10
|
7
|
1000
|
Table2
|
Deptno
|
|
10
|
|
40
|
73) Difference
between :
A. ROLLBACK
& SAVEPOINT
B. ROLLBACK
& COMMIT
C. Truncate
& Delete
D. Truncate
& Drop
E. Delete
& Drop
F. PK and
(UNIQUE + Not Null)
G. ROUND
& TRUNC
H. ROWID
& ROWNUM
I.
Alternate Key & Candidate Key
J.
Simple Key & Composite Key
K. Stored
Procedure and Function
L. Stored
Procedure and Trigger
M. Equi-Join
and Outer Join
N. CHAR
& VARCHAR2
O. CASE
Statements & DECODE
P. UNION
and UNION ALL
Q. Oracle
9i & 10 g
R. SQl
& SQL*Plus
S. SQL
server & Oracle server
T. DBMS
& RDBMS
Did you like these useful knowledge about these SQL questions ? If Yes, then share with us via your comments…
No comments:
Post a Comment