Download App

Computer Science 1 Marks Each

Database Management – SQL · CBSE STD 12 Commerce (CBSE - English Medium). 14 questions.

Questions

1 Marks Each

🎯

Test yourself on this topic

14 questions · timed · auto-graded

Question 21 Mark
A table course has its degree as 7 and cardinality as 18. Write the number rows and columns in the table.
Answer
Rows=18
Columns=7
View full question & answer→
Question 41 Mark
A table student consists of 5 rows and 7 columns. Later on 3 columns added and 2 rows deleted. After some time 5 new students added. What will be the degree and cardinality?
Answer
Degree – 10
Cardinality - 8
Initial table: 5 rows and 7 columns
Later 3 columns added: 10 columns
2 rows deleted : 3 rows and 10 columns
5 new students: 5 rows
Degree = 10 (i.e. 7 + 3 = 10 columns)
cardinality = 8 (i.e. 5 – 2 + 5 = 8)
View full question & answer→
Question 51 Mark
A table Item and Store have one common column Item-Id. Item table consists of 5 rows and 3 columns while the store table consists of 7 rows and 5 columns. What will be the degree and cardinality of these tables in the cartesian product?
Answer
Degree – 8 (5+3)
Cardinality – 35 (7 X5)
View full question & answer→
Question 61 Mark
A Table customer contains 5 rows and 7 columns. What will be its cardinality and degree?
Answer
Degree – 7, Cardinality -5
View full question & answer→
Question 71 Mark
Name the SQL command used for the following:
(a) To add new record
(b) To remove a record
(c) To change the name of a column
(d) To change the database
(e) To display records
(f) To edit record
Answer
(a) Insert
(b) Delete
(c) Alter
(d) Use
(f) Select
(f) Update
View full question & answer→
Question 81 Mark
What is the purpose of BETWEEN Clause?
Answer
This clause is used to filter the record by providing the range in a column which contains only a numeric value Text, Data can also be used with BETWEEN clause. For example Select * from student where age between 15 and 18;
View full question & answer→
Question 101 Mark
Write the difference between CHAR and VARCHAR.
Answer
CHAR VARCHAR
• It is fixed length string. • It is variable length string.
• They are right-padded with spaces to the specified length. • They are not right-padded with space. The length is actual data it contains.
View full question & answer→
Question 111 Mark
Write the Difference between DDL and DML
Answer
DDL DML
• Stands for Data Definition Language • Stands for Data Manipulation Language
• It is used to create/modify/ remove the
database schemas.		 • It is used to insert/modify/ remove the
records (rows) of the table.
• For example Create, Alter, Drop • For example Insert, Update, Delete
View full question & answer→
Question 131 Mark
Define Primary Key.
Answer
A column or a set of columns which can uniquely identify a row in a relation. Primary key cannot have Null values. For example AdmNo(Admission No) in table Student.
View full question & answer→
Generate Paper FreeAll Database Management – SQL topics
1 Marks Each - Computer Science STD 12 Commerce Questions - Vidyadip