What is a transaction in oracle database?
Explain committing transactions, rolling back transactions and setting save points in transactions with examples?
Write query to create “Students” table with following columns (StudentID numeric, StudentName text, DOB date)?
Write Query to create students table with following columns ( Student_ID numeric type, Student_Name text type, email text type, DOB date type) and add primary key constraint?
Write query to create new user account “ahmad” and assign permissions?
Write query to drop/delete “students” table?
Write the name of any five DDL statements?
Explain Not Null and Unique Constraints?
Explain Not Null and Unique Constraints; write statement to define NOT Null constraint?
Explain different constraints in oracle database?
Write an example to add a Foreign Key constraint using the ALTER TABLE statement?
What is Sequence, write query to create sequence and delete sequence?
What is View, write SQL query to create or replace exiting view for above mentioned “Students” table?
Write note on subprogram signature and subprogram body and explain its structure?
What is sub program and explain types of stored subprograms?
What is package and explain package specification and package body?
What is package and write pl/sql code to create a package to convert monthly salary into annual salary (using function within package) and add new student record using procedure within package?
What is trigger and explain its basic parts?
Write note on disabling and enabling triggers and explain OLD and NEW Pseudo-records?
Write PL/SQL code to explain instead of trigger with an example?
Write code to create two triggers, HR_LOGON_TRIGGER and HR_LOGOFF_TRIGGER. After someone logs on as user HR, HR_LOGON_TRIGGER adds a row to the table HR_USERS_LOG. Before someone logs off as user HR, HR_LOGOFF_TRIGGER adds a row to the table HR_USERS_LOG.