Tag: technology

Object level.

Row level.

Block level.

Schema level.

Database level.

Loss of the initialization parameter file.

One of the redo log members.

Any data file belonging to the default permanent tablespace

Any archive log file.

Any control file.

The goal / purpose of testing is to demonstrate that the program works.

The purpose of testing is to demonstrate that the program is defect free.

The purpose of testing is to demonstrate that the program does what it is supposed to do.

Testing is executing Software for the purpose of finding defects.

It is possible to have tablespaces of different block sizes in a database.

A data block is the smallest unit of I/O for data files.

Multiple tablespaces can share single data file.

Each data block in the database always corresponds to one OS block

Each segment contains one or more extents.

Top down

Big-bang

Bottom up

Functional incrementation

Data files and redo log files can be renamed at the MOUNT stage

Control files are required to bring the database to the NOMOUNT stage.

Data files and online redo log files are checked for consistency while opening the database

Data files and redo log files are made available to users at the OPEN stage.

iv is correct and i,ii,iii are incorrect.

i,ii,iii is correct and iv is incorrect

ii is correct and i,ii,iii are incorrect

iii and iv are correct and i,ii are incorrect

i , ii , iv are true and iii is false

i , ii , iii are true and iv is false

i , iii , iv are true and ii is false

All of above are true

i & ii are true, iii, iv & v are false

ii, iii & iv are true, i & v are false

ii & iv are true, i, iii & v are false

ii is true, i, iii, iv & v are false

AA11

11AA

BB22

None of the above