Oracle Mc Question

Only available on StudyMode
  • Download(s) : 110
  • Published : November 8, 2012
Open Document
Text Preview
Ch1
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 other language, 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| | Answers

|

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 (though with 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. | For what data storage paradigm must data be normalized? (Choose the best answer.) A. Hierarchical databases B. Network databases C. Object-oriented databases D. Relational databases| | 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| | Answers

|

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 all acceptable in the third normal form model.| Understand the SQL Language

|

5. | SQL cannot do everything. What functions require another language? (Choose all correct answers.) A. User interface design B. Branching structures 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| | Answers

|

5. |  A and B. SQL has no facilities for user interface design or for flow control. C is wrong because operations such as this are inherent in SQL’s set orientation. D is wrong because DDL commands are a part of SQL.| 6. |  B. The UPSERT command does not exist—though some developers refer to a MERGE operation as an UPSERT A, C, D, and E. MERGE, COMMENT, and SAVEPOINT are all 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 normally be 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| | Answers

|

7. |  B. Disk administration is usually the responsibility of the system administrators, not the database administrator. A, C, and D. These are typically all part of the DBA’s work.| CH2
Describe the Single-Instance Architecture
|

1. | What statements regarding instance memory and session memory are correct? (Choose all correct answers.) A. SGA memory is private memory segments; PGA memory is shared memory segments. B. Sessions can write to the PGA, not the SGA. C. The SGA is written to by all sessions; a PGA is written by one session. D. The PGA is allocated at instance startup. E. The SGA is allocated at instance startup.| | 2. | How do sessions communicate with the database? (Choose the best answer.) A. Server processes use Oracle Net to connect to the instance. B. Background processes use Oracle Net to connect to the database. C....
tracking img