Database Management Systems

This background processes copies the online redo log files to archival storage.

This answer is correct. There is no particular reason to explain this answer, because there is a name convention in DBMS. The members of weak entity set are called subordinate entity set. So, this answer is correct.

This answer is correct. There are 3 types of record based data models. These are :- 1.) Hierarchical model 2.) Network model 3.) Relational model

There are five types of attributes in a database. These are :- 1.) Simple attribute 2.) Composite attribute 3.) Single-valued attribute 4.) Multivalued attribute 5.) Derived attribute

This answer is correct. There are seven types of keys in a relational database. These are :- 1.) Primary key 2.) Candidate key 3.) Super key 4.) Foreign key 5.) Alternate key 6 .) Artificial key 7.) Composite key So, this answer is correct.

This is the correct answer. The entity set that does not have sufficient attributes to form a primary key, and relies on another for its identification,  is called a weak entity set. It does not have a primary key. So, this is correct answer.

This answer is correct. There are 3 types of data models present in DBMS. These are :- 1.) Object based data model 2.) Record based data model 3.) Physical data model So, this answer is correct.

This answer is correct. There is no particular reason to explain this answer, because there is a name convention in DBMS. The members of strong entity set are called dominant entity set. So, this answer is correct.

SQL (Structured Query Language) is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS).

Savepoint defines breakpoints for the transaction to allow partial rollbacks.

Data mart is a collection of subject areas organized for decision support based on the needs of a given department.

This technique places records into groups with similar characteristics.

DBA is a powerful set of views allows those who may access them to see all database objects in the entire database.

 An index is a sorted list of data from one or more columns in the tables that are commonly used as selection criteria.

The capacity of the server and hardware must be enough to store your entire data warehouse.