Exam Oracle Adm1 Preparation

Chapter 1: Introduction to the Oracle Server Technologies

TWO-MINUTE DRILL
Position the Oracle Product Family
❑ The Oracle database stores and manages access to user data. ❑ The Oracle Application Server runs applications that connect users to the

database. ❑ Oracle Enterprise Manager is a tool for managing databases, application servers, and if desired, the entire computing environment.❑ Languages built into the database for application development are SQL, PL/SQL, and Java.

Explain Relational Structures
❑ Data must be normalized into two-dimensional tables. ❑ Tables are linked through primary and foreign keys. ❑ Entity-relationship diagrams represent the tables graphically.

Understand the SQL Language
❑ SQL is a set-oriented language. ❑ The DML commands are SELECT,INSERT, UPDATE, DELETE, and MERGE. ❑ The DDL commands are CREATE, ALTER, DROP, RENAME, TRUNCATE,

and COMMENT. ❑ The DCL commands are GRANT and REVOKE. ❑ The TCL commands are COMMIT, ROLLBACK, and SAVEPOINT.

Appreciate the DBA’s Role
❑ ❑ ❑ ❑ ❑ ❑

Sizing applications and server hardware. Oracle software installation and maintenance. Database physical design. Monitoring and tuning performance.Assisting developers with application design and tuning SQL. Liaising with vendors, end users, developers, senior management, and other support groups. ❑ Backup, restore, and recovery. ❑ User and security management.

SELF TEST
Position the Oracle Product Family
1. Which of these languages can run within the database? (Choose all correct answers.) A. C B. Java C. PL/SQL D. SQL E. Any otherlanguage, if it is linked with the OCI libraries 2. In a web application, on which tier does the application software run? (Choose the best answer.) A. In the web browser on the client tier B. On the middle tier C. Within a Java-enabled database

Explain Relational Structures
3. For what data storage paradigm must data be normalized? (Choose the best answer.) A. Hierarchical databases B. Networkdatabases C. Object-oriented databases D. Relational databases

1

4. What type of relationship should be avoided when normalizing data? (Choose the best answer.) A. One-to-many B. Many-to-one C. Many-to-many D. One-to-one

Understand the SQL Language
5. SQL cannot do everything. What functions require another language? (Choose all correct answers.) A. User interface design B. Branchingstructures such as IF...THEN...ELSE C. Operations that affect many rows at once D. Table creation and deletion 6. Which of these is not a SQL command? (Choose the best answer.) A. MERGE B. UPSERT C. COMMENT D. SAVEPOINT E. All the above are SQL commands

Appreciate the DBA’s Role
7. With regard to ensuring that data will not be lost and that security will not be compromised, what would not normallybe part of the DBA’s duties? (Choose the best answers.) A. Designing backup routines B. Setting up disk mirroring C. Creating and dropping database objects D. Testing restore and recovery strategies

SELF TEST ANSWERS
Position the Oracle Product Family
1. ✓ B, C, and D. SQL, PL/SQL, and Java are implemented internally to the database. A is wrong because C is not available internally (thoughwith OCI, it can of course be used for writing user processes). E is wrong because OCI is used for writing user processes that run externally to the database. 2. ✓ B. In a three-tier web application, the application software resides on the middle tier. A is wrong because the client tier manages only the user interface. C is wrong because the database tier manages only the data access.Explain Relational Structures
3. ✓ D. Normalization is the process of converting data to two-dimensional relational tables. A, B, and C. Hierarchical, network, and object-oriented databases do not implement normalized data structures. 4. ✓ C. Many-to-many relationships should be resolved into one-to-many relationships, by inserting another entity between the two. A, B, and D. These are...