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 |
In packages the source code is compiled into p code ? how do we describe the p code
Which nosql database is best?
What are the steps you take to tune(performance tuning) the code in plsql?
4 Answers Cap Gemini, Infosys, TCS,
In what condition is it good to disable a trigger?
what is switch column,colums cost in oracle?
Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.
What is trigger with example?
What is the default value of CHAR type?
How do I truncate a sql log file?
how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?
What does cursor do in sql?
what is the difernece between named and anonymous pl/sql blocks??
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)