MySQL
DATABASE QUESTIONS
GRADE XII
1. What is a database? Name any two
RDBMS softwares.
2.
Discuss
features of SQL.
3.
Differentiate
between ALTER and UPDATE statements.
4.
Elucidate
the terms degree and cardinality of a relation.
5.
Answer
the following questions on the basis of the given table:
Admno Name Subject Gender Average
1001 Amit Math M 85.5
1002 Suman English F 90
a) How
many attributes are there in above table?
b) How
many tuples are there in above table?
c) What
is the degree and cardinality of above table?
6.
Out
of the following in ‘Employee’ table, which field is a primary key and why?
a) Emp_id c) emp_name
b) Emp_salary d) emp_designation
7.
What
is the difference between Char and Varchar?
8.
Write
the command to create the following table: “STUDENT”.
Field Name Data Type Constraint
Rollno Integer(5) Primary
Key
Sname Varchar(30)
Contactno Char(10) Not
Null
9.
Write
the query to insert the following record in the above created table.
Rollno Sname Contactno
1 Amit 1234567890
2 1231231234
10. Consider a table EMPLOYEE with the
following data and answer the SQL queries:
Eno Ename Salary Age Gender DOJ
1 Ankit
Singh 60000 35 F 08-03-2007
2 Ravi
Raj 50000 32 M 19-07-2009
3 Udit
Narayan 40000 32 M 03-01-2010
a)
Create a database OFFICE.
b)
Use the database OFFICE.
c) Create
a table EMPLOYEE and insert tuples in it.
d)
Display
the details of all the EMPLOYEES.
Comments
Post a Comment