Skip to main content

MySQL - ASSIGNMENT | 10th March 25

 

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

Popular posts from this blog

PYTHON - MYSQL CONNECTIVITY CODE

  #INSERTION OF DATA import mysql.connector mydb = mysql.connector.connect( host="localhost", user="root", passwd="root", database="school" ) print("Successfully Connected") #print(mydb) mycursor=mydb.cursor()   v1=int(input("enter ID:")) v2=input("enter name:") v3=input("enter Gender:") v4=int(input("enter age:")) sql='insert into TEACH values("%d","%s","%s","%s")'%(v1,v2,v3,v4) print(sql) mycursor.execute(sql) mydb.commit() print("record added") #MYSQL Connection code – Deletion on database SOURCE CODE: s=int(input("enter id of TEACHER to be deleted:")) r=(s,) v="delete from TEACH where id=%s" mycursor.execute(v,r) mydb.commit() print("record deleted") MYSQL Connection code – Updation on database SOURCE CODE: import mysql.connector mydb = mysql.connector.c...
Post a Comment
Read more

GRADE XII CS - VIVA QUESTIONS

  VIVA QUESTIONS GRADE XII CS Dear All Be thorough with your project and practical files, as the viva can be asked from anywhere. Stay calm, don’t get nervous, and be confident in front of the examiner. 1. Tell me about your project. 2. Which concepts you have used for your project? 3. What do you mean by front end and back end? How they are important in developing any such projects? 4  Mention the modules and built-in functions you have used in your project. 5. Which real world problems are solved by your project? 6. Explain the most important feature of your project. 7. Name a few mutable data types of python. Lists, Sets, and Dictionaries 8. Name a few immutable data types of python. Strings, Tuples, Numeric 9. Name ordered and unordered data type of python. Ordered – String, List, Tuples Unordred – Set, Dictionaries 10. What is the significance of a pass statement in python? pass is no operation python statement. This is used where python requires syntax but logic requires...
Post a Comment
Read more