15-05-2012, 11:12 AM
DATABASE MANAGEMENT SYSTEM SQL SAMPLE PRACTICAL QUESTION
DBMS_SQL_practical_question_1.doc (Size: 36.5 KB / Downloads: 72)
1) Define data?
2) Difference between data and information?
3) What is database?
4) What is DBMS and RDBMS?
5) Difference between DBMS and RDBMS?
6) What is a tuple?
7) Define SQL?
8) Feature of SQL*PLUS?
9) Overview of iSQL*Plus?
10) Difference between SQL and iSQL*Plus?
11) Architecture of DBMS?
12) Explain Entity-relation diagram?
13) Draw ER DIGRAM for college management?
14) Define weak entity and strong entity set ?
15) What is "normalization"? What is denormalization and difference between normalization and denormalization?
16) Write basic of SELECT statement?
17) Define NULL value? are the pros and cons of using NULLS?
18) Write example of literal character string?
19) How to find and remove duplicate values?
20) Define BETWEEN condition clause?
21) Define IN conditional clause?
22) Define LIKE conditional clause?
23) Define AND , OR NOT conditional clause?
24) Define ORDER BY conditional clause?
25) What keyword does an SQL SELECT statement use for a string search?
26) What is single row function and multi-row function?
27) Explain ROUND, TRUNC, MOD functions ?
28) Which function is used to find the largest integer less than or equal to a specific value?
29) What is the difference between TRUNCATE and DELETE commands?
30) Syntax of TO_CHAR, TO_NUMBER and TO_DATE Functions ?
31) Use of NVL, NVL2, NULLIF, COALESCE, CASE, DECODE?
32) Explain join, Equijoin, Non-Equijoins, Outer join, inner join?
33) What is a Cartesian product?
34) What is left outer join , right outer join?
35) What is natural join and USING Clause?
36) Why do you use self join ?
37) Difference INNER Versus OUTER Joins?
38) What is the difference between IN subselects and EXISTS subselect.
39) What Are Group Functions and Types of Group Functions?
40) Explain Group Functions Syntax and Group Functions with Null Values?
41) What is the use of Sub queries and what is Types of Sub queries?
42) What is Single-Row Sub queries and multiple-Row Sub queries?
43) Use of Substitution Variable?
44) DEFINE and UNDEFINE Commands?
45) What is Data Definition language , properties of DDL commands?
46) Syntax of create ,alter, drop ,truncate command?
47) How to create a table with the help of another table?
48) How to create a table from the other table without any data?
49) What is Data Dictionary?
50) What is data manipulation language , write syntax?