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) If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
937how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
1596
How does mysql store binary data?
What happens when converting big values to integers?
What is stored in a database?
How to display nth highest salary from a table in a mysql query?
What is the function of ms access?
What is the use of function "module procedure" in pl/sql?
How do I start pgadmin 4 on windows?
Explain about the case statement present in stored procedure?
1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD
Mongodb uses bson to represent document structures. True or false?
What do you understand by ‘database’?
How to backup encryption key ?
Explain the use of tables option in exp command.
Can we use max in where clause?
How do you call a stored procedure from jdbc?