Question: (2 Marks) Age Number(2) Q11. Write an SOL query to do the following: a. Create a table Student with the given details. SID S Name

 (2 Marks) Age Number(2) Q11. Write an SOL query to do

(2 Marks) Age Number(2) Q11. Write an SOL query to do the following: a. Create a table Student with the given details. SID S Name Bor Date Varchar2(4). Varchar2(25) Date Primary Key Unique b. Add constraint to check the age is more than 18. c. Insert the following records into the table Student. SID S_Name Bor Date (1 Mark) (1 Mark) Age S124 Sara 20/05/2019 19 20 23 S144 Zahra 15/10/2018 S146 Asma 06/06/2020 d. Change the age of Sara from 19 to 20 Q12 : Use the Student table for the following queries ( 1 Mark) a. Display SID of Students with names having letter a in the second position. (1 Mark) b. Display all details of students whose age is not 19 and 23. (1 Mark) c. Display all details of students in the ascending order of Name. (1 Mark) d. Display student name and age of students whose age lies between 19 and 21. (1 Mark) e Combine the columns SID and S_Name and in the output display column name as NewName (1 Mark)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!