Locking is a mechanism implemented either on an entire table or a row. Locking avoids the destruction done by the transactions accessing the same resource. The resource may be data in a table or rows in a data dictionary.
Archive for the ‘OCA DBA 10g’ category
What is locking?
October 26th, 2009
OCP 1z0-047 Short Notes: Exam passing tips
October 3rd, 2009- /*…*/ and — are used to put comments in an Oracle program.
- The CREATE TABLE does not end immediately with a semicolon, and a column name cannot start with a numeric value. However, a numeric value can be used in between a column name.
What is the DBVERIFY utility?
October 2nd, 2009DBVERIFY is an Oracle external command-line utility that performs a physical data structure integrity check. This utility is used on backup files, online databases, and offline databases. The utility is executed by issuing the DBV command at the command prompt.
Automatic Storage Management
October 1st, 2009Enterprises are preferably switching from old existing Oracle versions, such as Oracle 8i and Oracle 9i, to Oracle 10g to have various additional profitable features. They often employ the
What is the n-tier architecture?
October 1st, 2009The n-tier architecture is the most advanced type of architecture for a network configuration. This architecture introduces
An example of the n-tier architecture is the Internet. The n-tier architecture is the most preferred architecture for an enterprise network. This architecture reduces processing load on the server.
Download free practice test for rac-administrator-certified-experts-10g RAC Certified Expert 10g exam. Click here to get free 1Z0-042 Oracle Database 10g: Admin - I exam practice questions.What is an implicit lock in Oracle 10g?
October 1st, 2009An implicit lock is a lock that a row or a table acquires automatically, depending on the database operations such as ALTER TABLE, UPDATE, SELECT etc.
Download free practice test for rac-administrator-certified-experts-10g RAC Certified Expert 10g exam. Get certified in first attempt download 1Z0-042 - Oracle Database 10g: Admin - I simulation.What is the REMOTE_OS_AUTHENT parameter?
September 30th, 2009The REMOTE_OS_AUTHENT parameter in the parameter file of the database specifies whether remote clients will be authenticated with the value of the OS_AUTHENT_PREFIX parameter or not. The type of the REMOTE_OS_AUTHENT parameter is Boolean, the default value is false, and the parameter class is static. The REMOTE_OS_AUTHENT parameter is case sensitive on some operating systems. The flow diagram below may help a user understand the role of the REMOTE_OS_AUTHENT parameter for a remote database:
What is a deadlock and where are deadlocks encountered?
September 30th, 2009A deadlock refers to a condition, in which, two or more processes simultaneously wait for each other to complete, as a result of which both, or all of them, as the case may be, hang. Deadlocks are generally encountered in multitasking, multiprocessing, and client-server environments.
What is DBMS_SESSION PL/SQL package?
September 8th, 2009The DBMS_SESSION PL/SQL package is used to provide access to the ALTER SESSION and ALTER SYSTEM statements. This package is also used for gathering session related information. The DBMS_SESSION PL/SQL package uses the privileges of the user executing this package, instead of using privileges of the user SYS.
- Pass OCA DBA 10g in first attampt.
- Click here to download oca-dba-11g test study guide and practice question.
- Pass OCA DBA 9i in first attampt.
- Pass OCA PL/SQL Developer in first attampt.
- Become Oracle OCP DBA 10g certified.
- Download free practice test for ocp-dba-11g OCP DBA 11g exam.
- Download free practice test for ocp-dba9i OCP DBA 9i exam.
- Get certified in first attempt download ocp-pl-sql - OCP PL/SQL Developer simulation.
- Download free practice test for ocm-10g Oracle Certified Master 10g exam.
- Get certified in first attempt download oracle-pl-sql - Oracle PL/SQL Developer simulation.
- Download free practice test for performance-tuning-certified-expert-11g Performance Tuning Expert 11g exam.
- Best exam simulation Oracle rac-administrator-certified-experts-10g download free trial.
- Click here to download sql-certified-expert-10g test study guide and practice question.
- Pass SQL Certified Expert 11g in first attampt.
- Best exam simulation Oracle 1Z0-033 download free trial.
- Click here to download 1Z0-042 test study guide and practice question.
- Get certified in first attempt download 1Z0-047 - Oracle Database SQL Expert simulation.
- Get certified in first attempt download 1Z0-051 - OCA: Oracle Database 11g-SQL Fundamentals-I simulation.
How are archive destinations specified?
September 3rd, 2009When archiving redo logs, it must be decided whether to archive them to a single archive destination or multiplex them. When the archived redo logs are multiplexed, they are archived to more than one archive destination. The following two methods can be used to specify archive destinations: