Answer Key for Ilearning Oracle Academia | Oracle Database ...

November 18, 2016 | Author: Anonymous | Category: Oracle
Share Embed


Short Description

and deleting the data when required. modifying. A database interacts with the data and provides the following facilities...

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 computer 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

View more...

Comments

Copyright © 2017 DATENPDF Inc.