Vi ste ovdje
Overview/Description
SkillSoft Mentors are available to help students with their studies for exam 1Z0-052 Oracle Database 11g: Administration I. You can reach them by entering a Mentored Chat Room or by using the E-mail My Mentor service.
Target Audience
Individuals who are studying the associated SkillSoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.
Prerequisites
Familiarity with the exam objectives listed below and skills and competencies being measured in the associated certification exam.
Expected...
Overview/Description
Preparing for and performing data recovery and completing database backups are expected job duties of an Oracle Database 11g Database Administrator (DBA) to ensure that the database is available for users when they require it. They also need to ensure if a failure does occur that the loss of data is minimized as much as possible and they can recover the database in an efficient manner. As an Oracle DBA, it is important to understand the various internal consistency checks a database performs as it moves from the shutdown stage to being fully open. Equally important is an...
Overview/Description
To understand how an Oracle Database functions, it is important to gain a basic understanding of its major components. This course identifies the major architectural components of the Oracle Database 11g Release 2, explains memory structures, describes background processes, and explores the logical and physical storage structures. In addition, this course describes the role of a database administrator (DBA) and the tasks and tools required for this role. This course also covers how to plan for the Oracle Grid Infrastructure and Oracle Database 11g software installations,...
Overview/Description
As an Oracle Database administrator, it is important to plan the database to ensure that the database software is installed properly. Planning involves the logical storage structure, the overall design, and a backup strategy. It is also important to manage the database instance after the installation to ensure that it runs properly, and is started and shut down correctly to avoid problems. This course describes the DBA tasks to plan a database installation and how to use the Database Configuration Assistant (DBCA) to install the Oracle Database 11g software. It...
Overview/Description
Oracle Database 11g Release 2 is designed to prevent multiple users from changing the same data at the same time by implementing locks. These locks are used to manage data concurrency and are implemented automatically, which can sometimes cause lock conflicts. Lock conflicts can be detected and managed through Enterprise Manager or SQL statements. Managing undo data and implementing Oracle Database security are also important DBA roles. Data is manipulated using DML, and undo data exists as a copy of the original, premodified data and is captured for every transaction...
Overview/Description
General database maintenance and performance monitoring are important Oracle DBA tasks. Proactive and reactive database maintenance is made easy by the sophisticated infrastructure of Oracle Database 11g Release 2, including elements such as Automatic Workload Repository (AWR) and database health checkers. DBAs must make sure that databases are open and available to users when they need it and that it is working without bottlenecks by gathering performance metrics. This course explores how to specify, review, and maintain audit information. It also discusses how to use...
Overview/Description
From time to time Oracle DBAs are required to move data. Oracle Database 11g Release 2 offers various ways to complete this task, including Oracle Data Pump, SQL*Loader, and the use of external tables. DBAs are also required to ensure that the database is up-to-date with the latest patches and that critical errors are resolved, which includes contacting Oracle for support. This course explores how to move data using Data Pump Wizards or the command line. Working with the Enterprise Manager Support Workbench, My Oracle Support, service requests, and patch management are...
Overview/Description
An Oracle database is divided into logical storage units called tablespaces. Oracle also provides Oracle-Managed Files (OMF), which eliminate the need for the DBA to directly manage the operating system files in the Oracle database. To access the database, a user must specify a valid database user account and successfully authenticate as required by that user account. What the user can execute once they are logged in is controlled by privileges granted to them, which can be system or object. Privileges can be better controlled by using roles and profiles, which control...
Overview/Description
Oracle Database 11g Release 2 offers Automatic Storage Management (ASM), which eliminates the need for many tasks that are required on a non-ASM storage environment by the DBA. Some of these tasks include I/O performance tuning, file system, cluster file system, and raw device management, and data file movements and reorganizations. When ASM is used, an ASM instance is also used. The ASM instance allocates memory and uses the SGA differently than in a database instance. This course describes the ASM instance and how it works, and demonstrates how to manage it with various...
Overview/Description
To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.
Target Audience
Individuals seeking practice in a structured testing environment,...
- 1 od 2
- ››
Koraci do učenja
Prijavite se, a ako nemate korisničko ime, registrirajte se.
Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.
Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.
Trebate pomoć?
- Česta pitanja - FAQ
- telefon: +385 1 6558 440
- email: support@cognita.hr
- Kontakt forma
