Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
No Answer is Posted For this Question
Be the First to Post Answer
You're getting high "busy buffer waits" - how can you find what's causing it?
What is RAID and what are different types of RAID configurations?
What are the ways tablespaces can be managed and how do they differ?
how can you record information about current session?
Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is the difference between Datapump & export/import?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how do see how much space is used and free in a tablespace
How can you rebuild an index?
What background process refreshes materialized views?
2 Answers Accenture, FLSmidth,
1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????
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)