If you're unsure in which script a sys or system-owned
object is created, but you know it's in a script from a
specific directory, what UNIX command from that directory
structure can you run to find your answer?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Is it possible to update the multiple field values in a single query? If possible then write the actual query.
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How do you resize a data file?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Query processing is slow(eg select query)how will u solve that
what is ora 24313?what is the procedure to exclude that error?
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)