Database ProgrammingTU Board 2024
Write the queries for following operations: a) Create two tables (parent and child) maintaining referential integrity. b) Display the record using inner join (natural join) c) Demonstrate the Outer…
10Write the queries for following operations: a) Create two tables (parent and child) maintaining referential integrity. b) Display the record using inner join (natural join) c) Demonstrate the Outer join (left outer, right outer and full outer join) d) Demonstrate the cross join
A worked answer is on its wayMeanwhile, read the Database Programming notes for this topic.
Discussion
Loading…
More Database Programming questions
Define database programming. Describe the differences between procedural and non procedural access to a database. [1+4]TU Board 20255What is a subquery? Explain the use of GROUP BY and HAVING clauses in SQL. [1+4]TU Board 20255Explain the concept of parameter modes (IN, OUT, IN OUT) in PL/SQL with examples. [5]TU Board 20255Define trigger. Write the syntax to create a row level trigger in PL/SQL. [1+4]TU Board 20255Write a PL/SQL block using an explicit cursor to display all employee names from the Employee table. [5]TU Board 20255What are constants in PL/SQL? Give syntax and an example. [5]TU Board 20255