Interview Questions And Answers
Q: - What is "SCN" ?
The System Change Number (SCN) is an important quantifier that the Oracle database uses to keep track of its state at any given point in time.
Submitted By:-Kunal Email-ID: - rkunal63@yahoo.com
Q: - What is the role of "Recover Command" ?
The recover command, as you can imagine, is used during a recovery of the database or one of its files or tablespaces after a database failure.To be able to run this command, you need to have the OSOPER or the OSDBA role. You can perform manual or automatic recovery, and in either case, you're responsible for first restoring all the necessary data files so you can recover your database
Submitted By:-Kunal Email-ID: - rkunal63@yahoo.com
Q: - What are the "Temporary Tables" ?
Oracle9i allows you to create temporary tables to hold data just for the duration of a session or even a transaction. After the session or the transaction ends, the table is truncated (i.e., the rows are automatically removed). Temporary tables are handy when you are dealing with complex queries or transactions that require transitory row information before inserting or updating a permanent table.
Submitted By:-Kunal Email-ID: -rkunal63@yahoo.com
 |
 |