Database Management Systems

This component of Abstract Data gives the description on how to manipulate information in the storage structures to obtain the results defined for the operations.

In this transaction's property, either all or none of the transaction's operations are performed.

This component of the RMAN environment containing the control files, datafiles etc..... that RMAN backups or restore.

This node participating in the session tree sends all of the distributed transaction's SQL statements, remote procedure call and so forth to the directly reference nodes.

A logical standby database is created as a separate database by RMAN because it has different DBID from its primary database.

This feature of the RMAN describes the contents of the backup sets that define which files are multiplexed and the level of multiplexing.

During the compilation phase, RMAN determines which objects the command will access for example, resolving a tablespace name into its components datafiles.

In this transaction's property, if many transactions execute concurrently, the result must be same as if they were executed serially in the same order.

A flash recovery area is a directory, file system etc...., includes archived redo logs, flashback logs and RMAN backups.

You can create this component of the RMAN environment that contains the RMAN metadata for multiple target database unless you are using RMAN with a physical standby database.

An ORDBMS offers all the features of a RDBMS plus it offers the benefits of creating user defined objects and types. Oracle offers the user an option to not only create and maintain relationships between different tables but also user defined data types such as Varrays, Types, Nested Table etc..

The resource role allows a user to create and modify new objects like Table, View etc. It is the basic permission that a user requires to create objects. When a user in Oracle is created, it is a two step process - first a new user is created by issuing the create user statement which is create user username identified by password;For example : create user amit identified amit_manager; Once the user is created , it is assigned permissions so that it can carry on with its work. To grant permissions, the create grant statement is issued. For example : Grant connect,resource to amit. This statement will permit the user amit to login(connect) and create objects(resource) 

All statements are applicable for Relational Database model.

This is true as deletion of any records in the parent can cause the deletion of that in the child table too.

These options have correct statements about Network model.