07-10-2016, 10:26 AM
1458140382-AdvanceSqlimportantquestions.docx (Size: 13 KB / Downloads: 4)
Unit 1:
What do you mean by SQL? Explain its sub languages in detail.
Describe set membership and pattern matching test search condition of select statement with example.
Explain 5 Date function in detail(give example).
Short note on Sequence(write example).
Explain aggregate function in detail.
Explain any 5 string function in detail.
What do you mean by cross join and self join and give example for each.
Explain foreign key with example.
Short note on view and updating and dropping view.
What do you mean by Outer join? What are their types (write with example)?
Short note on index.
Explain primary key, default and not null constraint with example.
Unit 2:
Explain grant and revoke command in detail.
Short note on subquery Qualified test(ANY & ALL).
What do you mean by system and object privileges? write any 3 privileges of each type.
Write about subquery existence test.(give Example).
Explain Role and with syntax. And write query for crating role student and assigning all object privileges on product table.
Short note on hierarchical subquery.
Explain set operators in detail.(give example of each).
What do you mean by subquey and explain about how it differ from join
Explain DCL commands in detail with example.
Short note on Co-related subquery
What is mean by ROLL UP and CUBE operator.in group by clause.(give example)
Explain group by with having clause.
Unit 3 :
Explain What is PL/SQL and Describe PL/SQL Engine in detail.
What do you mean by %type attribute? give example.
Short note on bind variable.(write example).
Explain PL/SQL data type and describe Saclar data type with example.
What is transaction? And explain Savepoint in transction.
Explain declaration of variable and scope of variables in pl/sql in detail.
Explain PL/SQL block in detail.(give example to state each setion in plsql block)
What is anonymous block and stored procedure and explain PL/SQL benifits.
State and explain Explicit data type conversion in PL/SQL
Explain PL/SQL Comment. And write program to describe it.
Explain commit and rollback command in detail.
Write advantages and disadvantages of PL/SQL
Unit 4:
What is cursor and explain with example.
Explain nested If-THEN –ELSE in pl/sql with example.
What do you mean by exception? write one program to handle NO_DATA_FOUND error.
Describe implicit cursor in detail.(give example)
What is mean by composite data type? Explain its Types.
Explain index-by -table with example.
Explain about CASE statement in PL/SQL.
Give details on composite data type record.(give example)
Describe explicit cursor in detail.
Explain named system exception with example.
Short note on user define exception.
Describe for loop in pl/Sql with example.
Unit 5:
Explain parameters mode use in subprogram.
Write difference between anonymous block and subprogram.
Explain advantages of using package.
Write program of package that consist one procedure to print max sal of emp.
Brief about subprogram. Describe about package,package specification,body.
Write a pl/sql program to print Fibonacci numbe between 1 to 20 .
Write difference between procedure and function.
Explain parameter mode in subprogram of pl/sql.
Write program of package that consist one procedure to print max sal of emp.
Explain overloading of subprogram in pl/sql using package.
What is package? State its advantages of package.
Unit 6:
Explain DDL Trigger.(give example)
What is mean by dynamic sql?
write difference between row level and statement level triggers.
What is enabling and disabling trigger.(write syntax)
Explain native dynamic sql (give example).
write difference between row level and statement level triggers.
What is trigger? Explain its component.
Write program of trigger to print ‘row level trigger’ message to be display each update statement of student table.
What is enabling and disabling trigger.(write syntax).
What is trigger? Explain its type.
Write syntax for crateing, altering, droping trigger.(give one example for creating and droping trigger).