Tag: technology

It allows the identification of changes in user requirements

It facilitates timely set up of the test environment.

It reduces defect multiplication

It allows testers to become involved early in the project.

tests the individual components that have been developed.

tests interactions between modules or subsystems

only uses components that form part of the live system.

tests interfaces to other systems.

No benefits

1. It’s like taking service from other IT vendors

1. No hardware investment, i.e. lower costs, No software to download - ready to start from the word go, No IT resources - Anyone who has used a Web program like Hotmail can use it, Faster deployment

1. No IT resources

a. The database stores the same column for a group of rows together

b. The data block does not store the rows in the row-major format

c. The database stores the identical rows together with a reference for each row

d. Database operations works transparently against compressed objects without the need of changing application code

a. Warehouse Compression & Online Archival Compression

b. Basic Compression, Warehouse Compression & Online Archival Compression

c. Basic Compression, OLTP Compression, Warehouse Compression & Online Archival Compression

d. OLTP Compression, Warehouse Compression & Online Archival Compression

a. Compression unit can span across multiple data blocks

b. The value of particular column can span across multiple blocks

c. If a column in a compression unit is updated, the database will take a lock only on the updated rows

d. If a column in a compression unit is updated, the database will take a lock on the entire compression unit

a. For basic and online archival compression inserted and updated rows are uncompressed

b. Higher compression levels of Exadata Hybrid Columnar Compression are achieved only with data that is direct-path inserted

c. High CPU overhead in case Warehouse compression

d. Conventional inserts and updates are supported in Exadata Hybrid Columnar Compression but the extent of compression is low

a. COMPRESS FOR QUERY HIGH should be used where load performance is critical

b. COMPRESS FOR QUERY LOW should be used where load performance is critical

c. COMPRESS FOR ARCHIVE HIGH should be used for rarely accessed application

d. COMPRESS FOR ARCHIVE HIGH should be used for heavily accessed application

a. CELL_OFFLOAD_PLAN_DISPLAY

OPT_PARAM

c. CELL_OFFLOAD_PROCESSING

d. CELL_PARTITION_LARGE_EXTENTS

True

False