Oracle Database Admin I Exam 1Z0-051 (SQL) and 1Z0-052 (11g) ExamFOCUS Study Notes and Review Questions 2013 |
|
Author:
| ExamREVIEW, |
ISBN: | 978-1-4825-0800-0 |
Publication Date: | Aug 2013 |
Publisher: | CreateSpace Independent Publishing Platform
|
Book Format: | Paperback |
List Price: | USD $18.95 |
Book Description:
|
1z0-052 is an entry level DBA 11g (Admin) exam. The topics covered include:Exploring the Oracle Database ArchitecturePreparing the Database EnvironmentCreating an Oracle DatabaseManaging the Oracle InstanceConfiguring the Oracle Network EnvironmentManaging Database Storage StructuresAdministering User SecurityManaging Data and ConcurrencyManaging Undo DataImplementing Oracle Database SecurityDatabase MaintenancePerformance ManagementIntelligent Infrastructure EnhancementsBackup and...
More Description1z0-052 is an entry level DBA 11g (Admin) exam. The topics covered include:Exploring the Oracle Database ArchitecturePreparing the Database EnvironmentCreating an Oracle DatabaseManaging the Oracle InstanceConfiguring the Oracle Network EnvironmentManaging Database Storage StructuresAdministering User SecurityManaging Data and ConcurrencyManaging Undo DataImplementing Oracle Database SecurityDatabase MaintenancePerformance ManagementIntelligent Infrastructure EnhancementsBackup and Recovery ConceptsPerforming Database BackupsPerforming Database RecoveryOn the other hand, the SQL exam 051 covers:Retrieving Data Using the SQL SELECT Statement Restricting and Sorting DataUsing Single-Row Functions to Customize Output Using Conversion Functions and Conditional ExpressionsReporting Aggregated Data Using the Group Functions Displaying Data from Multiple Tables Using Subqueries to Solve Queries Using the Set Operators Manipulating Data Using DDL Statements to Create and Manage TablesCreating Other Schema ObjectsWe give you knowledge information relevant to the exam specifications. To be able to succeed in the real exams, you'll need to apply your earned knowledge to the question scenarios. This ExamFOCUS book focuses on the more difficult topics that will likely make a difference in exam results.Throughout this book we run Oracle 11g on Windows Server 2012 for demonstration. Oracle 11g can be downloaded from Oracle free of charge. You do need to apply for a free OTN account from Oracle. Your server needs to have sufficient RAM and drive space to accommodate Oracle.