ASSIGNMENT ON SQL CLASS-12 CS

 

ASSIGNMENT ON SQL CLASS-12 CS

 

SQL COMMANDS

ASSIGNMENTS

1. What is MySQL?

2. How is a database related to a table ?

3. Write MySql command that will be used to open an already existing database “CONTACTS”.

4. Write a SQL command to view the constraints of EMP table.

5. Mentioned two categories in which MySQL commands are broadly classified?

6. Is NULL value the same as 0 (zero)? Write the reason for your answer.

7. Write the UPDATE command to increase the commission (column name :COMM) by 500 of all the salesman who have achieved sales (Column name : SALES) more than 200000. The table’s name is COMPANY.

8. Write one similarity and one difference between CHAR and VARCHAR data types.

9. In a hospital, the patients are allocated to wards. A database named ‘Hospital’ is created. One table in this database is: WARD with WardId, WardName, NumOfBeds as columns and WardId as the primary key. Write another suitable table you could expect to see in the ‘Hospital’  database, with 3 suitable columns identifying Primary key and Foreign key in the table that you expect.

10. Which clause should be used to arrange records in a specific order?

ASSIGNMENT-1 DATA REPRESENTATION

MAXFORT SCHOOL-ROHINI

CLASS-XI

SUBJECT: COMPUTER SCIENCE

ASSIGNMENT-1 DATA REPRESENTATION

Question 1:
Do as directed :

a)    Convert (259)10 to binary form.

b)    Convert (17.35)₁₀ to binary form

c)    Convert (39286)₁₀ to octal form.

d)    Convert (0.2)₁₀ to the binary form.

e)    Convert (423.03125)10 to octal form.

f)     Convert Octal number 321.7 into its Binary equivalent.

Question 2:
Do as directed :

a)    Covert the Hexadecimal number 3BC into its Binary equivalent.

b)    Convert the Binary number 10011010.010101 to its Hexadecimal equivalent.

c)    Convert the Decimal number 345 into Octal number.

Question 3:
Do as directed

a)    Convert the Decimal number 736 into Hexadecimal number.

b)     Convert the Octal number 246.45 into Hexadecimal number.

c)     Convert the Hexadecimal number ABF.C into Octal number.

d)     Covert the Octal number 576 to Decimal.

e)     Convert the Hexadecimal number A5C1 to Decimal,

ASSIGNMENT ON SQL CLASS-12 CS

 

SQL COMMANDS

ASSIGNMENTS

1. What is MySQL?

2. How is a database related to a table ?

3. Write MySql command that will be used to open an already existing database “CONTACTS”.

4. Write a SQL command to view the constraints of EMP table.

5. Mentioned two categories in which MySQL commands are broadly classified?

6. Is NULL value the same as 0 (zero)? Write the reason for your answer.

7. Write the UPDATE command to increase the commission (column name :COMM) by 500 of all the salesman who have achieved sales (Column name : SALES) more than 200000. The table’s name is COMPANY.

8. Write one similarity and one difference between CHAR and VARCHAR data types.

9. In a hospital, the patients are allocated to wards. A database named ‘Hospital’ is created. One table in this database is: WARD with WardId, WardName, NumOfBeds as columns and WardId as the primary key. Write another suitable table you could expect to see in the ‘Hospital’  database, with 3 suitable columns identifying Primary key and Foreign key in the table that you expect.

10. Which clause should be used to arrange records in a specific order?

ASSIGNMENT ON NETWORKING CLASS-12 IP

     

Assignment-1 networking

Class-12

       1.     What is the difference between E-mail and Chat?                                     

      2.      What is VOIP?                                                                                

      3.     Write two characteristics of Wi-Fi.                                                           

    4.     Write one advantages of Bus Topology of network. Also, illustrate how 4 computers can be connected with each other using star topology of network.

     5.     Give one suitable example of each URL and Domain Name.           

     6.     What is Cyber Crime?

      7.     What is WEB2.0?

      8.      Differentiate between hacking and cracking.

       9.     What are cookies?

10.                        Define web browser and web server.

     11.                        How FTP is different from HTTP?

     12.                         What is TCP/IP?

     13.                        What is protocol? Name some commonly used protocols.

     14.                        Briefly explain file transfer protocol.

     15.                        What factors should be taken into consideration while opting for a particular topology?

FORMAT OF PRACTICAL FILE CLASS-XII CS WITH PYTHON

NOTES OF NETWORKING CLASS-12 IP

                                   

CLASS-12 ASSIGNMENT-2 SQL QUERIES INFORMATICS PRACTICES