Increment the salaries by 5% and add a comm. of 300 to the existing comm, and changing the clerk to jobs of all salesman whose salary is more than or equal to 1500.

List the premium customers who is not using the service within the last one week.if you have these tables: 1-'Premuim_USER'columns: Customer_ID, post_paid.2-'calls'columns: called_number, Customer_ID, call_date, call_time_started, Call_time_ended, transaction_no.

Why or why not?

How to use different types of locks in SQL query?

What is BC and AD in date function of SQL?

Describe variable length record representation in files using byte string representation

these are the columns in the exam_report tableEXAM_CODE,STUDENT_ID,USER_ID,FIRST_NAME,STUDY_CENTER,COURSE,PAPER,APPEARENCEnow i want to know how many student have passed at the end of the yr for each paper? and if they r failed i need to know there mark of the last appearance for each paper(ie)he might have appeared 5 times but still he may have failed and i want the mark of the 5 appearance

What is explain plan and what is tkproff?

1. How many non cluster index we have use in one table?2. How we set the priority in the cluster index?3. What is co-releated sub query?