114161416 Answer Key for Ielts General ReadingFull description
1. A segment is a set of extents which have been allocated for a specific type of data structure, and all are stored in the same tablespace. True (* False 2. The Oracle Database stores data logically in tablespaces, and physically in datafiles associated with the corresponding tablespace. True (*) False
3. Oracle Database stores data logically in tablespaces and physically in datafiles associated with the corresponding tablespace.
True (*) False 4.
The main subject areas taught by the Oracle Academy are:
Computer Repairs Data Modeling, SQL, and PL/SQL (*) Database performance tuning Systems programming and computer architecture 5. The market for IT professionals is still increasing and will continue to do so in the future as the world gets ever more dependent on co mputer systems. True or False? True (*) False
6. Business rules help you understand the standardization procedure an organization follows when handling huge data. Mark for Review (1) Points
True (*)
False
[Correct]
(Choose 3) (1) Points
Correct
7. The reason or drive for using databases rather than files has been ... Mark for Review
(Choose all correct answers)
Availability of data to a diverse set of users (*)
Integration of data for easier access and modification for complex transactions (*)
Reduced redundancy of data (*)
Use of blocks
[Correct]
Correct
8. In a network database model the data is organized into a tree-like structure and to retrieve data the whole tree needs to be traversed starting from the root node. Mark for Review (1) Points
True
False (*)
11. A database interacts with the data and provides the following facilities: Mark for Review (1) Points
Retrieving
Inserting
Both (*)
Neither
[Correct]
Correct
12. A database is a centralized and structured set of data stored on a computer system and provides facilities for retrieving, adding, modifying, and deleting the data when required. Mark for Review (1) Points
True (*)
False
[Correct]
Correct
13.
A row is called a record.
(1) Points
True (*)
False
[Correct]
Correct
Mark for Review
14.
In a relational database a table is referred to as ..
Mark for Review
(1) Points
Cardinality
Relation (*)
Attribute
None
[Correct]
Correct
15.
A table is a collection of records.
Mark for Review
(1) Points
True (*)
False
[Correct]
9.
Correct
The advantages of object-oriented data model are: Reduced Maintenance Real-World Modeling Both (*) None
10. In the relational database model, each table name must be unique. The column names in the table must be unique too. You can have two different tables that have column names that are similar. Mark for Review (1) Points True (*) False
