Question: What are the Pct Free and Pct Used
Answer: Pct Free is used to denote the percentage of the free space that is to be left when creating a table. Similarly Pct Used is used to denote the percentage of the used space that is to be used when creating a table eg.:: Pctfree 20, Pctused 40
Question: What is Row Chaining
Question: What is a 2 Phase Commit
Answer: Two Phase commit is used in distributed data base systems. This is useful to maintain the integrity of the database so that all the users see the same values. It contains DML statements or Remote Procedural calls that reference a remote object. There are basically 2 phases in a 2 phase commit.
a) Prepare Phase :: Global coordinator asks participants to prepare
b) Commit Phase ::
Question: What are mutating tables
Question: What are Codd Rules
Answer: Codd Rules describe the ideal nature of a RDBMS. No RDBMS satisfies all the 12 codd rules and Oracle Satisfies 11 of the 12 rules and is the only Rdbms to satisfy the maximum number of rules.
Question: What is the Difference between a post query and a pre query
Question: Deleting the Duplicate rows in the table
Question: Can U disable database trigger? How?
Answer: Yes. With respect to table
ALTER TABLE TABLE
[ DISABLE all_trigger ]
Question: What is pseudo columns ? Name them?
Answer: A pseudocolumn behaves like a table column, but is not actually stored in the table. You can select from pseudocolumns, but you cannot insert, update, or delete their values.
* NEXTVAL
* LEVEL
* ROWID
* ROWNUM
Answer: Yes.
verry nice quastion bank.
LikeLike
Its good .Please try to include some more good questions.
Thanks…
LikeLike
Thanks for all the information!
LikeLike
Explicit cursor has attributes %FOUND, %NOTFOUND, %ISOPEN, %ROWCOUNT and implicit cursor has attributes
sql%FOUND, sql%NOTFOUND, sql%ISOPEN, sql%ROWCOUNT
LikeLike