New ! Computer Science MCQ Practise Tests



Data Manipulation Through SQL - Two Marks Study Materials

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 00:45:00 Hrs
Total Marks : 28
    14 x 2 = 28
  1. Mention the users who uses the Database.

  2. Which method is used to connect a database? Give an example.

  3. What is the advantage of declaring a column as “INTEGER PRIMARY KEY”

  4. Write the command to populate record in a table. Give an example.

  5. Which method is used to fetch all rows from the database table?

  6. What is a cursor in SQL and databases?

  7. What is the reason behind defining a SQL command with triple quotes?

  8. What is master table?

  9. How will you sort the data in a table in an ordered way?

  10. What is the use of AND, OR operators combined with WHERE clause?

  11. Write a note or cursor. description.

  12. Write the placeholders which supported by SQlite3 module Execute.

  13. How the cursor object is created?

  14. How the SQL DISTINCT class is helpful to you?

*****************************************

Reviews & Comments about 12th Computer Science - Data Manipulation Through SQL - Two Marks Study Materials

Write your Comment