UNIT - 1: DATABASE CONCEPTS LAST YEAR Q & Ans(part-2)
UNIT - 1: DATABASE CONCEPTS LAST YEAR Q & Ans Important Q/ ANS strictly as per the CBSE syllabus for class-XII INFORMATION TECHNOLOGY- 802 PRACTISE QUESTIONS Q1. Which of the following is true for self-referencing table? (a) A foreign key constraint can reference columns within the same table. (b) A primary key constraint can be null. (c) You cannot delete this table. (d) You cannot update or delete this table. Q2. Identify the operator that performs pattern searching in MYSQL. (a) EXISTS operator (b) BETWEEN operator (c) LIKE operator (d) SEARCH operator Q3. Cardinality of a table is four and degree is three. If two columns and four rows are added to this table, what will be the new degree and cardinality of the given table? (a) 5,8 (b) 3,4 (c) 8,5 (d) 4,3 Q4. The Phase of application development that involves creating a database and writing code is called...