
	Trending ▼ ICSE CBSE 10th ISC CBSE 12th CTET GATE UGC NET Vestibulares ResFinder

CBSE Class 11 Exam 2024 : Informatics Practices

6 pages, 6 questions, 0 questions with responses, 0 total responses,

	Ritam Saha	+Fave Message
	Profile Timeline Uploads

Home > coolritam53 >

Formatting page ...

SUBBIAH CENTRAL SCHOOL CLASS XI INFORMATICS PRACTICES (065) TIME: 3 HOURS M.M.70 General Instructions: 1. This question paper contains five sections, Section A to E. 2. All questions are compulsory. 3. Section A have 18 questions carrying 01 mark each. 4. Section B has 07 Very Short Answer type questions carrying 02 marks each. 5. Section C has 05 Short Answer type questions carrying 03 marks each. 6. Section D has 03 Long Answer type questions carrying 05 marks each. 7. Section E has 02 questions carrying 04 marks each. One internal choice is given in Q35 against part c only. 8. All programming questions are to be answered using Python Language only. 1. PART A i) Which command is used to Open a Database? ii) Which command is used to remove the Database? 1 2. Which is the DDL and which is the DML Command? ALTER TABLE , INSERT INTO 1 3. What is the command to create a database? 1 4. The symbol Asterisk (*) in a select query retrieves ____________. (i) All data from the table (ii) Data of primary key only (iii) NULL data (iv) None of the mentioned ____declares that an index in one table is related to that in another table. (i) Primary Key (ii) Foreign Key (iii) Composite Key (iv) Secondary Key 1 6. Write a SQL query to display the Name of all those employee whose ENAME Field contains 4 th character as S from the table EMPLOYEE. 1 7. Write a SQL query to display records in ascending order of their Salary from the table EMPLOYEE. Field Name SALARY. 1 8. What is the difference between DELETE and DROP command in SQL. Explain with example. 1 9. List any 2 limitations of file system that can be overcome by a relational DBMS? 1 5. 1 10. Define the following terms in the context of Database (i) Relation (ii) Tuple 1 11. Which of the following is not RBDMS software? a) Oracle b) MS Excel c) MySQL d) MS Access 1 12. The design of data is known as 1 a) Database Schema b) Data Constraint c) Data Dictionary d) Database Instance 13. The SQL statements ends with a) , b) : c) ; 1 d) 14. Shiv wants to see the table structure in MySQL. Select an appropriate command to 1 help him. a) use b) show c) desc d) display 15. Sahil wants to delete a primary key constraint from the table. Select an appropriate 1 command which help him. a) Create b) Alter c) Drop d) Delete 16. Rajveer wants to rename column in display result for his query. He has given he 1 following queries, select correct query for him: a) select ename, salary*12 Annual Salary from emp; b) select ename, salary*12 rename Annual Salary from emp; c) select ename, salary * 12 change Annual Salary from emp; d) select ename, salary*12 as Annual Salary from emp; Q17 and 18 are ASSERTION AND REASONING based questions. Mark the correct choice as i. Both A and R are true and R is the correct explanation for A ii. Both A and R are true and R is not the correct explanation for A iii. A is True but R is False iv. A is false but R is True 17. Assertion(A): An intelligent machine is supposed to imitate some of the 1 cognitive functions of humans like learning, decision making and problem solving. Reasoning(R): In order to make machines perform tasks with minimum human intervention, they are programmed to create a knowledge base and make decisions based on it. 18. Assertion(A):Robots were initially conceptualized for doing repetitive industrial 1 tasks that are boring or stressful for humans or were labor-intensive. Reasoning(R): Algorithms are one of the prime components of a robot. 19. PART B Write any four applications of DBMS. 20. Define the following: i. Domain ii. Degree 21. Mr. Malhotra is working on a MySQL table named Stud with following table schema: i. Which command is used to get the above table as output ii. Write the query to create the table and insert one record to it 2 2 2 22. Dhruvee has given the following table structure and asked to create a table in 2 MySQL. Help her by writing create table command to accomplish her task. Table Name: players 23. What do you mean by constraints? Enlist the constraints supported by MySQL. 2 24. What is the difference between ALTER and UPDATE command in SQL. Explain 2 with example. 25. Consider the following tables STATIONERY and write SQL query for the given questions:- 2 a) Display details of those Items whose company name is null. b) Display details of those items whose Item name contains character E anywhere in the STNAME. SECTION C 26. Priyam is Class XI student. She is learning some basic commands. Suggest some SQL commands to her to do the following tasks: i. To show the lists of existing databases ii. Select a database to work iii. Create a new database named Annual_Exam OR Observe the following table and write answers for the below given questions: Table Name: Movie 3 i) Write command to add movie_id as primary key. ii) Write command to change the size of category column to 50 characters. iii) Write command to delete column releasedate 27. Differentiate between Augmented Reality and Virtual Reality. 3 28. Write any three advantages of DBMS over flat file system. 3 29. Define following: i) Database Schema ii) Database Instance iii) Database Engine 30. Match the following clauses with their respective functions. 3 3 SECTION - D 31. Consider the table MARKS and write SQL query for the question i to ii and find output for the given SQL query from iii to v. 5 i) Display the details of all Science students. ii) Display the details of students who are in class 12 sorted by stipend. iii) SELECT SNAME, GRADE FROM MARKS WHERE SNAME LIKE %S ; iv) UPDATE MARKS SET STIPEND = STIPEND*2 WHEREGRADE = C ; v) SELECT STREAM, AVGMARK FROM MARKS WHERE AVGMARK > 90; ; 32. Consider the below given table and write queries for (i) & (ii) and output of (iii) (v):Table Name: Pet Name Owner Species Gender Age Monty Badal Moti Mittu Pinky Sweety Aditya Dev Motisingh Harsh Kartvya Vyas Dog Horse Dog Parrot Cat Cat M M M M F F 4 4 3 2 1 2 5 i) Display name, owner and gender for all dogs. ii) Display Name, owner and age of all pets whose age is more 2 years. iii)select name, owner from pet where owner name like %ya ; iv) select name, age from pet where species = dog and age between 1 and 3; v) select * from pets where species in ( horse , parrot ); 33. Choose appropriate answer with respect to the following code snippet. CREATE TABLE student ( name CHAR(30), student_id INT, gender CHAR(1), PRIMARY KEY (student_id)); a) What will be the degree of student table? i) 30 ii) 1 iii) 3 iv) 4 b) What does name represent in the above code snippet? i) a table ii) a row iii) a column iv) a database c) What is true about the following SQL statement? SelecT * fROM student; i) Displays contents of table student ii) Displays column names and contents of table student iii) Results in error as improper case has been used iv) Displays only the column names of table student d) What will be the output of following query? INSERT INTO student VALUES ( Suhana , 109, F ), VALUES ( Rivaan , 102, M ), VALUES ( Atharv , 103, M ), VALUES ( Rishika , 105, F ), VALUES ( Garvit , 104, M ), VALUES ( Shaurya , 109, M ); i) Error ii) No Error iii) Depends on compiler iv) Successful completion of the query 5 e) In the following query how many rows will be deleted? DELETE student WHERE student_id=109; i) 1 row ii) All the rows where student ID is equal to 109 iii) No row will be deleted iv) 2 rows SECTION E 34. Match the following: 4 35. Answer the following questions based on the given table: 4 i. How many attributes are there in the above table? ii. How many tuples are there in the above table? iii. What is the degree of the above table? iv. What is the cardinality of the above table?

Formatting page ...

Related ResPapers
CBSE Class 11 Exam 2024 : Informatics Practices
by coolritam53

Formatting page ...

coolritam53 chat

Horizontal lines at:
Guest Horizontal lines at:
AutoRM Data:
Box geometries: