Write the difference between case version and decode version.
Answers were Sorted based on User's Feedback
Answer / nithya
Decode
1.It’s a function
2.can compare only discrete values
3.pl/sql standards
4.cannot process null
Case
1.It's an Expression
2.can handle range values
3.ANSI Standards
4.Processing time is faster when compared to Decode
5.can process null
| Is This Answer Correct ? | 3 Yes | 0 No |
Explain about the database management systems.
How to read and create .LDC data files which are used by linguatic dictionary.
Who are end users in dbms?
In which table collections errors are stored.
What are the types of database model?
Explain the role of indexing in databases?
How is data stored in dbms?
What is denormalization and when would you go for it?
fact table and dimension table containg one to many relationship or many to one relastionship
What are the key features of dbms?
How to use timestamp datatypes
What are the three types of database design?
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)