How will you make performance better for application including
front end and back
Answers were Sorted based on User's Feedback
Answer / guest
Describe Java and Database performance technique for UI and
database and mid-tier
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / kexcaliber
Build most of the services for the application in the backend so that this reduces the data transactions and computation is much faster also write service that are service specific i.e Data Encapsulation
Implement OOPS based concepts
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?
What are the popular database management systems in the it industry?
IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????
what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )
Define tables and fields in a database
What is the difference between numeric and autonumber?
how to use myisamchk to check or repair myisam tables? : Sql dba
What is sql profiling in oracle?
define different types of trigger. : Sql dba
Does sql support programming?
what is a foreign key ? : Sql dba
How do I view a view in sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)