Answer Posted / r.s.chauhan
When query is fetching Data from different-2 and small
fragmented tables then we have to De-normalize.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Mention what plvcmt and plvrb does in pl/sql?
What is a crud api?
What is pivot query?
Explain the uses of database trigger.
List the different type of joins?
Explain what is rdbms?
Mention what are different methods to trace the pl/sql code?
What do we need to check in database testing?
how to get a list of columns in an existing table? : Sql dba
When sql appeared?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What is sql prepared statement?
how would concatenate strings in mysql? : Sql dba
Explain raise_application_error.
How to process query result in pl/sql?