Database Management Systems

This memory component of the system global area is responsible for storing and reusing frequently used SQL statements, their execution plans and stored procedures.

All objects created in the database by users have their data physically stored in the data files.

This memory component of the system global area is used by all session-specific java code and data within the JVM.

This is the correct alternative.

This is also known as Database-Protocol Driver and it converts JDBC calls directly to the vendor-specific protocol without any middleware software like in Type-3 driver.

Yes,  a Statement object can not accept parameters and is used for static SQL statements at runtime.

Yes, both the statements determines the properties of the 'savepoint' command.

These can be either stored for use in multiple sessions or generated for one session only.

It helps you to write java applications that manage the activity such as connection to a data source, like a database.

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

This is the correct answer. 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 is the correct answer.

This is correct answer. There are 3 types of record based data models. These are :-1.) Hierarchical model2.) Network model3.) Relational modelThese are the 3 models.So this is the correct choice.

There are five types of attributes in database. These are :-1.) Simple attribute2.) Composite attribute 3.) Single-valued attribute4.) Multivalued attribute5.) Derived attribute So this is the correct answer .

This is the incorrect answer. there are 3 types of data models present in DBMS. These are :-1.) Object based data model2.) Record based data model3.) Physical data modelSo this is the incorrect answer.

This is the correct answer. There are seven types of keys in relational database. These are :-1.) Primary key2.) Candidate key3.) Super key4.) Foreign key5.) Alternate key6.) Artificial key7.) Composite keySo this is the correct answer.