What is table scan and index scan?
No Answer is Posted For this Question
Be the First to Post Answer
Explain natural key?
Differentiate between extension & intension?
Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
What is OQL?
Is it possible to update AS400 database record while reading it with no lock
Explain data independence & its types.
What is global database name?
what is Normalization means..?
8 Answers AZTEC, Bank Of America, Infosys, TCS,
Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
How to do Data integrity testing? Who does this testing (Developer or tester)?
if we have set auto differencial back up then waht is difference between 1.appen to media 2.over right the existing media
1 Answers Indian Web Technology,
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)