CH01-Practice References.docx

**شابتر1Practice** **Fill in the spaces suitable words to determine what the sentences refer to:** 1. The basic data structure of the relational model is the Table \_ 2. Schemas are part of the logical database structure associated with a user 3. Open Grid Forum is a standards body that d...

**شابتر1Practice** **Fill in the spaces suitable words to determine what the sentences refer to:** 1. The basic data structure of the relational model is the Table \_ 2. Schemas are part of the logical database structure associated with a user 3. Open Grid Forum is a standards body that develops grid computing 4. Multiple instances access a single Oracle database refer to. RAC 5. In Multitenant Architecture we have one CDB and one or more ,PDB **Answer using True or False:** 6. In Relational Databases (RDBMS) keys used to join or combine data from two or more tables tttttt 7. Oracle is (DBMS) store data as files fffffff 8. In Three-tier applications user's workstation has the application program FFFFF 9. One of the Oracle DBA's Role is to insert application data in the database fffffff 10. In Real Application Clusters Multiple instances access a single Oracle database tttttt **Choose the right answer:** 11. Which statement is true about Sql : A. Sql is Structured Query **Language** used to communicate with a database B. Sql used for DML but not for DDL C. Sql used to insert data into files 12. Resources to share in CLOUD computing D. Servers E. Storage F. Applications G. All of them 13. Which statement is true about Three-tier applications: H. user's workstation has the application program I. Data stored inside user's workstation J. We used one server and Multi user's workstation K. Application server contains the application act as interface between clients and database server 14. **Which statement is wrong about RDBMS:** L. The basic data structure of the relational model is the file M. Information about the particular entity represented in columns and rows N. Tables can have Keys O. Keys used to join or combine data from two or more tables 15. **Which statement is wrong about (ASM):** P. The ASM functionality is an extension of the Oracle Managed Files Q. Reference individual disks rather than disk groups R. includes striping and mirroring S. provide balanced and secure storage 16. The Oracle DBA's Role are: T. U. V. W. 17. The ASM functionality is: X. Y. Z. A. 18. In Multitenant Architecture: B. C. D. E. 19. The main new features in Grid Computing are: F. Multitenant architecture G. Oracle ASM H. Flashback Database I. Database Cloud Service 20. The features of Data Redaction are: J. The functionality change the data stored in the database K. The owner of the functionality will not be able to see the sensitive data as the other users L. To hide sensitive information M. It is one of the features of oracle 11g **Practice Answers** **Answer** --------------------- -------------------------------------------------- 1\. Table (Relational Databases (RDBMS) page 4) 2\. Schemas (database schemas page 4) 3\. Open Grid Forum (Grid Computing page 8) 4\. RAC (Real Application Clusters page 9) 5.CDB,PDB (Multitenant Architecture page 11) 6.True (Relational Databases (RDBMS) page 4) 7.False (Oracle Database page 4) 8.False (Oracle Database page 4) 9.False (Oracle DBA's Role page 6) 10.True (Real Application Clusters page 9) 11\. A (SQL page 4) 12.D (CLOUD computing page 10) 13.D (Oracle Database Three-tier applications page 5) 14.A (Relational Databases (RDBMS) page 4) 15.B (Automatic Storage Management (ASM) page 10) 16.A,D (Oracle DBA's Role page 6) 17.B,C,D (Automatic Storage Management (ASM) page 10) 18.B,D (Multitenant Architecture page 11) 19.B,D (GRID COMPUTING page 8) 20.C (Data Redaction page 11)