Solved Sample Paper class xii IP Paper 1- Q3 , cbse board

818 views · Published 9 November 2018 · 12:05 · Indexed 5 October 2026

Channel: Anjali Luthra · 2018 · Education

Watch on YouTube

Complete Paper's solution : https://www.youtube.com/playlist?list=PLDDXuRcB-QG7NDhC7P1BnAKrX3gtk7nJA
Crash course for xii ip :https://www.youtube.com/playlist?list=PLDDXuRcB-QG7zubiLLoWwkevc6tLsDdq9
Whatsapp Number : +919212535516
Email id :- [email protected]
Q3
a SQL is structured query language used to work with databases. 
It provides the commands to create and mange tables i.e. inserting/ deleting/ updating and fetching the data from databases

b
i . since there is no column mentioned for gender , cant check if the candidate is female

i. select count(*) from Training;
ii. select * from Training where Fee is null;
iii. select city,fee from Training where Topic='Cyber Security';
iv. alter table Training
Add feedback varchar(200);


c
i. city
   New Delhi
   Faridabad
   Gurugram
ii.count(Training_id)
     2
iii. avg(fee)
      11000
iv.  name
    Ms. Neena

d.
Degree : 6
Cardinality : 5

Facebook Page : 
https://www.facebook.com/aeccomputereducation/
Link for Complete Java Tutorial in HIndi https://www.youtube.com/playlist?list=PLDDXuRcB-QG6MQ1Lwh4fI1cvNb09k0dOn
Link for Complete Tutorial for Programming in C  in HIndi https://www.youtube.com/playlist?list=PLDDXuRcB-QG5br_VxN4zSmORIKJSfh1Rj

Link for Complete  Python Tutorial in HIndi https://www.youtube.com/playlist?list=PLDDXuRcB-QG7FAWqrgUms1xEf7CcD7mjq

Complete Study Material for Class 12 CS https://www.youtube.com/playlist?list=PLDDXuRcB-QG4UDvkbqPV2y0La-PptDect

Complete Study Material for Class 12 IP  https://www.youtube.com/playlist?list=PLDDXuRcB-QG7gfmbcp-hJF5AeKd82-fz6

More from this channel