Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
No Answer is Posted For this Question
Be the First to Post Answer
How will u copy the objects of one schema to another schema in datapump & export/import?
any body know about orawaves do they really provide placements in their unique placement program
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
From the database level, how can you tell under which time zone a database is operating?
What is the difference between dropping a database and taking a database offline? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
When a user process fails, what background process cleans up after it?
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?
What would you do with an "in-doubt" distributed transaction?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is a correlated sub-query? : sql server DBA
Oracle (3253)
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)