agregator gives one to many records or many to one record
what is Normalization?
Explain what a database is?
What is database design and development?
What are cursors? Explain different types of cursors?
Define candidate key, alternate key, composite key?
30 Answers IAS, IBM,
what is difference between primary key and unique key ?
State the acid rules?
Can an extended stored procedure be called from inside a user-defined function?
What is the system function to get the current user's user id?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Explain about the database management systems.
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)