Read the most frequently asked 80 top Oracle multiple choice questions and answers PDF for freshers and experienced.Oracle objective questions and answers pdf download free.
Oracle Multiple Choice Questions and Answers PDF Experienced Freshers
- You added a PHONE-NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table some of the employees may not have a phone number available. Which data manipulation operation do you perform?
- The EMPLOYEES table has these columns: LAST_NAME VARCHAR2 (35) SALARY NUMBER (8, 2) COMMISSION_PCT NUMBER (5, 2) You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?
- Management has asked you to calculate the value 12* salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCHAR2 (35) NOT NULL SALARY NUMBER (9, 2) NOT NULL COMMISSION_PCT NUMBER (4, 2) Which statement ensures that a value is displayed in the calculated column for all employees?