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 use of nvl function?
Can we perform dml in function?
What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?
Why do we need sharding?
What are actual parameters and formal parameters?
What is trigger in sql? Explain
How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.
What is sql stand for?
What is an example of translating a date into julian format?
When can we use the where clause and the having clause?
what are the properties and different types of sub-queries? : Sql dba
write a query find which rows of a table is updated on 2 days before?
Oracle (3253)
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)