Skip to main content

Q) What are the limitations of procedure oriented programming methodology?



A)

Data processing sake we write a program. The problem of processing or particular program application is nothing but program.
Application = data + code
       Difference between procedure oriented and oop methodologies
In procedure oriented the data and code is not organized but in oop the data and code is organized.
The process/procedure of way is important but not important to data.
=> Any application is primarily ment for processing of data. To process data we need to have    instructions (code).
      Therefore, we say that an application is comprises of data and code that acts upon data.
      The way to process is important in procedure oriented.
      The main problem with procedure oriented is the code and data is not property organization.
      The lake of organization of code and data become many problems.
=> Procedural orientation is one kind of programming principle. According to his principle, given            importance. But not “what data is” and “who is processing data “.
=> In procedural oriented style of application development data and code that acts upon data or not properly organized.
=> Lack of proper organization of data and code leads to the fallowing problems:
1)      Data is not secure (from whom?)
2)      Complexity can’t be handled.



Comments

Popular posts from this blog

Q) Explain repeated deletion of records.

A) //RepeatedDeletion.java import java.util.Scanner; import java.sql.*; class RepeatedDeletion {        public static void main(String[] args) {               Connection con= DriverManager. getConnection ( "jdbc:odbc:prince" , "scott" , "tiger" );               PreparedStatement ps=con.PreparedStatement( "DELETE FROM ACCOUNT WHERE ACCNO=?" );               Scanner s= new Scanner(System. in );               while ( true )               {                      System. out .println( "Enter accno : " );      ...

Q) Retrieving data from database?

A)   ->to retrieve the data from database we need to submit SELECT statement from JDBC application. -> executeQuery() method of statement object is used for this purpose. This method has the fallowing ResultSet executeQuery(String sql) throws SQLException Ex: ResultSet rs = st.executeQuery(“SELECT * FROM ACCOUNT”); ->objectoriented representation of tables formate data is called ResultSet object. Ao the driver created one object i.e. ResultSet object. ->object orientation representation of a table of records returned from db is nothing but “ ResultSet ” object.  

Q) What is the purpose of JDBC?

A) -> Java application can do any task by making a method (function) call. ->java method calls are not understandable to database management system. They can understand only SQL statements. ->SQL statements can’t be directly used in a java application. Java compiler complains. ->therefore, we say that java environment and database environment are heterogeneous to each other. Purpose of JDBC: ->for any kind of java application to communicate with any kind of database (management system) in a standard manner, JDBC is used.