Technology Questions

- Online backup is one which is taken at the time the database is running in the ARCHIVELOG mode.

- Following files should be backed up during the Offline Backup: All data file, all control file and all online redo log file. But in the case of the online backup following files is backed up: All data files all archived redo log files and one control file via the alter database command.

- Offline database we cannot rely upon but in case of online database no issues.

- Offline backup no archived mode is required but in the online backup it is must.

Data binding is an automatic synchronization of data between model and view components. ng-model directive is used in Data binding.

Static (embedded) SQL:

1.In static SQL how database will be accessed is predetermined in the embedded SQL statement.

2.It is more swift and efficient.

3.SQL statements are compiled at compile time.

4.Parsing, validation, optimization, and generation of application plan are done at compile time.

5.It is generally used for situations where data is distributed uniformly.

6.EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are not used.

7. It is less flexible 

Dynamic (interactive) SQL:

1.In dynamic SQL, how database will be accessed is determined at run time.

2.It is less swift and efficient.

3.SQL statements are compiled at run time.

4.Parsing, validation, optimization, and generation of application plan are done at run time.

5.It is generally used for situations where data is distributed non-uniformly.

6.EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are used.

7.It is more flexible.

Scope resolution operator allows a program to reference an identifier in the global scope that is hidden by another identifier with the same name in the local scope.

A is wrong because a class can extend nly one class .B is wrong because a class can implement any number of interfaces.C is wronb because both can can be done simulteneously.So, D is correct

CEDA 

The main aim of the namespace is to understand the logical units of the program and to make the program so robust.