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)
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Explain oracle instance.
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
What are the 3 modes of parameter?
Explain how to use transactions efficiently : transact sql
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What is clustered index sql?
What is the command or the option available in postgresql that can be used to retrieve the next SERIAL value from the sequence object?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
Explain oracle’s server parameter file.
Is postgres is free?
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
What is difference between index seek vs. Index scan?
How can a single instance environment be converted into rac environment and how will they be different?
What is pragma serially_reusable and why is it used?