- Default ConstraintWhat is default constraint? How we you apply it?
- Disable Restricted SessionHow do you get back into SQLPlus to disable restricted session if you enabled.
- How many ways you can delete the table records ?In how many ways can I delete all the contents of a table and the entire table. Explain with syntax ?
- User defined exception wasteIn which section of a PL/SQL block is a user defined exception waste?
- List all customer (user id, name, and e-mail), number of chargingList all customer (user id, name, and e-mail), number of charging, total charging,
number of transaction and total number of transaction value?
If u have these tables:
1- 'Credit_card'
columns: credit_number,type,value,Customer_ID.
2-'Coupon'
columns: Coupon_number,value,password,Customer_ID
3-'Customer'
columns: Customer_ID,Fname,Mname,lname,E_mail,password,bdate,tot_trans,mobil_no,
hom_no,ex_id_date,current_Balance. You must first Login or Register to view all 132 questions from this category.
Registering yourself is FREE, takes just less than a minute and opens up a whole new GetGyan experience.