How is data stored in dbms?
No Answer is Posted For this Question
Be the First to Post Answer
What are cursors? Explain different types of cursors?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
1 Answers Flextronics, Hexaware, SQL Star,
Explain about the database management systems.
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
Explain about relational database management systems?
Which data type cannot be used as a parameter in a udf?
Explain about a primary key?
Explain the family trees and connection by clause.
What is denormalization and when would you go for it?
How to generate OIDS
what is Normalization?
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)