This website uses cookies to ensure you have the best experience. Learn more

Difference Between Truncate And Delete Essay

3178 words - 13 pages

1. What is different between TRUNCATE and DELETE?
The Delete command will log the data changes in the log file where as the truncate will simply remove the data without it. Hence Data removed by Delete command can be rolled back but not the data removed by TRUNCATE. Truncate is a DDL statement whereas DELETE is a DML statement.
2. What are ORACLE PRECOMPILERS?
A precompiler is a tool that allows programmers to embed SQL statements in high-level source programs like C, C++, COBOL, etc. The precompiler accepts the source program as input, translates the embedded SQL statements into standard Oracle runtime library calls, and generates a modified source program that one can compile, ...view middle of the document...

patches for Rapid Clone and you are on latest rapid clone patch.
7. What is different between NO DATA FOUND and %NOTFOUND
NO DATA FOUND is an exception which is raised when either an implicit query returns no data, or you attempt to reference a row in the PL/SQL table which is not yet defined. SQL%NOTFOUND, is a BOOLEAN attribute indicating whether the recent SQL statement does not match to any row.
8. Is it possible to disable the connection sys as sysdba. If yes, does violates oracle 9i Any attempts would be appreciated
There is no possibilities of disabling the connection as sysdba because sys is the owner of the database who has all the powers of the database so you can disable the account of sys what u can do is you can change the password and restrict the access of the password by the password file to the Server itself.
9. What is difference between AD_BUGS and AD_APPLID_PATCHES ?
AD_BUGS holds information about the various Oracle Applications bugs whose fixes have been applied (ie. patched) in the Oracle Applications installation.

AD_APPLIED_PATCHES holds information about the "distinct" Oracle Applications patches that have been applied. If 2 patches happen to have the same name but are different in content (eg. "merged" patches), then they are considered distinct and this table will therefore hold 2 records.
10. What is RAID and what are different types of RAID configurations?
RAID stands for Redundant Array of Inexpensive Disks, used to provide fault tolerance to database servers. There are six RAID levels 0 through 5 offering different levels of performance, fault tolerance.
11. What is difference between SUBSTR and INSTR?
INSTR function search string for sub-string and returns an integer indicating the position of the character in string that is the first character of this occurrence. SUBSTR function return a portion of string, beginning at character position, substring_length characters long. SUBSTR calculates lengths using characters as defined by the input character set
12. What is a deadlock? Explain
When two processes are waiting to update the rows of a table which are locked by the other process a deadlock arises. In a database environment this will often happen because of not issuing proper row lock commands. Poor design of front-end application may cause this situation and the performance of server will reduce drastically.
These locks will be released automatically when a commit/rollback operation performed or any one of these processes being killed externally.

Deadlock is a kind of situation,which occured in a network of database environment while multiple processes is waiting for their completion, whereas some other process is still running till the time we use the rollback or commit commands or stopped the

blocked process by database systems program itself.
13. Can objects of the same schema reside in different tablespaces
Yes : Schema objects can stored in different...

Other Papers Like Difference Between Truncate and Delete

Difference Between Competence and Competency Essay

698 words - 3 pages It becomes confusing when we want to know the difference between “competence” and “competency”, many questions arise when answering this question. Are these terms used interchangeably in organizational context or do they really hold different meaning?. I found an article named “Competence, competency and competencies: performance assessment in organizations” in which the authors wanted to tackle this issue and try to discover the difference

Difference Between Adn and Bsn Essay

1052 words - 5 pages Title - Difference in competencies between nurses prepared at the Associate degree level versus Baccalaureate degree level in nursing. Name - Thomas Paleyl Course – NRS-430V- 0109 Date – 12 April 2014 The

Difference Between And Felony And Misdemeanor

1702 words - 7 pages The Difference between a felony and misdemeanor Laura Macella AIU Online The Difference between a felony and misdemeanor Abstract In this paper it will be discussed the differences between a felony and a misdemeanor. There will be examples of real life situations and memo discussing to a client the differences between the two. It will be discussed to the client that was charged with breach of peace about the crime she committed, her

Difference Between Right and Wrong Clear?

573 words - 3 pages The difference between right and wrong is clear The difference between right and wrong is clear. No it isn't! If the difference between right and wrong is clear, then why did some think slavery was the right thing, yet many more disagree. In my perspective differences between right and wrong are unclear; one may think it is right while another may think it is wrong. For example, the Salem witch trials, innocent people died from that

-Difference-Between-Private-and-Public-Company-

1000 words - 4 pages Difference between private and public company structure under the Corporations Act Governance Foundations (1) Types of companies Public vs private Type of company Differences in regulation Regulated by Percentage of registrations - Limited by shares Sub-classified as small or large ASIC - Unlimited with share capital Small = Can be any size; some are very large - consolidated gross operating revenue

Difference Between Greek And Roman Sculpture

361 words - 2 pages artwork. The most obvious difference between Greek and Roman architecture is the material used. The Greeks used marble and the Romans used concrete. Greek sculptures are associated with white marble, Greek sculpture in the early classical period was often made in bronze during the high classical period. They were made from white marble and were often painted. Roman sculptors also used primarily white marble, though they did not paint their

Difference Between Moral Absolutism and Relativism

676 words - 3 pages Explain the difference between moral absolutism and relativism (25) There are two different ways in distinguishing whether something is right or wrong within ethics. Absolutism is a deontological theory, which determines whether an action is intrinsically right or wrong. Whereas relativism is a teleological theory, which determines whether an action is right or wrong based on the outcomes of the action, on its consequences, this is linked

The Difference Between China and France

1158 words - 5 pages Cultural Comparison Between China and France Introduction From my first step in france 3 months ago, the first thing I could say is that France is facinating and fancy me. I also wonder that france and china are really different countries. In fact, France and China have a different economy, and don’t have the same culture. The purpose of this report is to compared with the diference between France and China ,since the difference exists in

Difference Between Euclidean And Spherical Trigonometry

4711 words - 19 pages Difference Between Euclidean and Spherical Trigonometry 1 Non-Euclidean geometry is geometry that is not based on the postulates of Euclidean geometry. The five postulates of Euclidean geometry are: 1. Two points determine one line segment. 2. A line segment can be extended infinitely. 3. A center and radius determine a circle. 4. All right angles are congruent. 5. Given a line and a point not on the line, there exists exactly

Difference Between Natural Language and Artificial Language

1451 words - 6 pages and humor relies on ambiguity, and the ambiguity also allows us to express ourselves very concisely by having an implicit frame of reference. Ambiguity is the main difference between the two languages; this has been confirmed by failed projects in human computer interaction using natural languages. Natural language is one of many 'interface styles' (or 'interaction modalities') that can be used in the dialog between a human user and a

The Difference Between Monotony and Boredom…

1009 words - 5 pages seeking stimulation to avoid states of boredom and depression. The Difference Between Monotony and Boredom… Repetition isn't always boring. For some reason I can listen to the same great song on auto repeat for an hour straight. I could eat the same foods every day, and I wake up every morning at 6:30am. I’m not sure why but when I find something I enjoy, I prefer to experience it over and over. Perhaps that’s why training and running

Related Essays

Difference Between Socialism And Capitalism Essay

1114 words - 5 pages profit. On the other hand, socialism is an economic system that supports the state ownership and administration of the means of production. (Salihoğlu, 1997) First difference between capitalist and socialist economic systems is ownership. In capitalist economic systems, private ownership, which is the right to own the means of production, is emphasized. However, in socialist economic systems, the government decides what to produce, how to

Difference Between Adn And Bsn Essay

1123 words - 5 pages Difference Between Associate- Degree Level Nurses and Bachelor- Degree Nurses There is always a question about which program is better; Is it the associate’s degree in nursing program provided by community colleges or the baccalaureate of science in nursing program provided by colleges and universities? One similarity is for sure that nurses from both programs can take the NCLEX-RN exam. Before I started college I was debating whether I should

Difference Between Journals And Diaries:

618 words - 3 pages Difference between journals and diaries:- The difference between a diary and a journal is that a diary is where you can write down what happened during the day and keep a record of stuff. A journal is to write your own personal feelings in, and things that happened, and how they happened. A diary is a report of what happened during the day—where you ate, who you met, the details that what was happened in the office, and who took whose

Difference Between Curriculum And Instruction Essay

675 words - 3 pages Definition of Curriculum & The Difference Between Curriculum and Instruction EDU 765: Seminar in Curriculum Problems July 10, 2009 Definition of Curriculum The term curriculum has been used by many involve in the field of education for a very long period of time. Like any other term with ambiguity, a number of authorities have come up with various definitions. Although the wording of the definitions may be different, there