Question 11 Mark
Name the two wild card characters.
Answer
View full question & answer→Two wild Card Characters are % (Percentage) and _(Underscore).
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
View full question & answer→Rows=18
Columns=7
Question 31 Mark
Write the full form of SQL.
Answer
View full question & answer→Structured Query Language.
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
View full question & answer→Degree – 10
Cardinality - 8
Initial table: 5 rows and 7 columns
Later 3 columns added i.e. 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)
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
View full question & answer→Degree – 8 (5+3)
Cardinality – 35 (7 X5)
Question 61 Mark
A Table customer contains 5 rows and 7 columns. What will be its cardinality and degree?
Answer
View full question & answer→Degree – 7, Cardinality -5
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
View full question & answer→(a) Insert
(b) Delete
(c) Alter
(d) Use
(f) Select
(f) Update
Question 81 Mark
What is the purpose of BETWEEN Clause?
Answer
View full question & answer→This clause is used to filter the record(s) by providing the range in a column which contains only a numeric value Text, Data can also be used with BETWEEN clause.
Question 91 Mark
What do you mean by NULL?
Answer
View full question & answer→NULL means no value/ missing value.
Question 101 Mark
Write the difference between CHAR and VARCHAR.
Answer
View full question & 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. |
Question 111 Mark
Write the Difference between DDL and DML
Answer
View full question & answer→| DDL | DML |
| • Its stands for Data Definition Language | • Its stands for Data Manipulation Language |
| • It is used to create/modify/ remove thedatabase schemas. | • It is used to insert/modify/ remove therecords (rows) of the table. |
| • For example Create,Alter, Drop | • For example Insert,Update, Delete |
Question 121 Mark
Define Foreign Key.
Answer
View full question & answer→It is a column that references the primary key of another table.
Question 131 Mark
Define Primary Key.
Answer
View full question & 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.
Question 141 Mark
Name the command used to change the database.
Answer
View full question & answer→USE