Tuesday, March 1, 2011

VB.net mid semester exams questions

 VISUAL BASIC.net

1.   Explain the use of following control with its important property and method  with example.
      a) Error Provider control
      b) Data Greed view
      c) List View
      d) Timer
      *note :-  in exam any control will asked.
2.   Explain Data source property.
3.   What is use of following and give its syntax.
       a) BindingManagerBase class
       b) DataAdapter
       c) DataSet
       d) Connection Object
       f) Command Object
      *note :-  in exam any one will be asked among this.
4.   What do you mean by bound control ? It is possible to bound any control without database connectivity ?
      if yes than give example.
5.   Write down the code for entering only letters as well as only number in simple text box.
6.   Write syntax for binding data grid view with particular table in database.
7.   Write steps for create database connectivity and generating table and column name through visual studio.
8.   Write syntax for navigate web page and display on form.
9.   Consider a form as shown below in VB.net .
      Write a code for each button click event.code must include the syntax for binding control with sql
      database .also write the code for data connectivity , insert , update , delete operation with particular
      button click event.                  

PHP & MySQL(Mid sem exam questions)

ASSIGNMENT-1(MID SEM QUESTIONS)


                                                PHP


1. What is open source? Write down the advantages of it.
2.  Write down the rules of php syntax.
3.  Explain constant and variables in php.
4.  Explain integration of html code inside php script with example.
5.  Write down the method used for passing variables between pages and explain all with example.
6.  Explain use of following functions
     a)  rand
     b)  ceil
     c)  floor
     d)  number_format
     e)  max
     f)   min
     g)  print
     h)  print_r
     i)   sort
     j)   asort
     k)  rsort
     l)   arsort
7.  Explain the concept of include file for efficient code.
8.  Explain foreach construct with example.
9.  Compare session and cookie.
10. Write down disadvantages of passing variables using URL.
11. Explain use of heredoc as an alternative to  echo statement.

                                             MySQL

12. Explain different features provided by InnoDB storage engine.
13. Explain advantages of transactional table over non-transactional table and vice-versa.
14. List out different table format provided by MySQL.
15. Explain different datatype in MySQL.

   

Thursday, January 6, 2011

Simple Introduction to PHP and MY SQL


 PHP( Hypertext Preprocessor) & MY SQL

Introduction of PHP

● Server side scripting language
● Free Software (PHP License)
● Supports many databases (MySQL, Informix, Oracle, Sybase, Solid, PostgreSQL, Generic ODBC etc.)
● Runs on different platforms (Windows, Linux, Unix, etc.)
● Compatible with almost all servers used today (Apache,
IIS, etc.)


Introduction of MY SQL

MySQL has been criticized in the past for not supporting all the features of other popular and more expensive DataBase Management Systems. However, MySQL continues to improve with each release (currently version 5), and it has become widely popular with individuals and businesses of many different sizes

REASON TO USE MY SQL

● Scalability and Flexibility
● can handle embedded applications and massive data warehouses
● High Performance
● unique storageengine architecture
● High Availability
● highspeed master/slave replication configurations
● Robust Transactional Support
● ACID (atomic, consistent, isolated, durable) transaction support
● distributed transaction capability
● multiversion transaction support Web and Data Warehouse Strengths
● highperformance query engine
● good storage architecture for data warehousing
● Strong Data Protection
● SSH and SSL support
● powerful data encryption and decryption functions
● Comprehensive Application Development
● libraries to embed MySQL datasupport into nearly any application
● connectors and drivers (ODBC, JDBC) Management Ease
● automatic space expansion, autorestart, and dynamic configuration
● suite of graphical management and migration tools






SUBJECT OF IV SEMESTER