Tag: databases

Questions Related to databases

AWR WILL GIVE RECOMMENDATION?

technology databases

  1. True

  2. False

Show answer
Correct Option: A

How to generate statspack report?
technology databases

  1. run spcreate.sql

  2. run sptrunc.sql

  3. run spexp.par

  4. run spreport.sql

Show answer
Correct Option: D

IMS Db is IBM's ________________ database management.
technology databases

  1. Network

  2. Relational

  3. Hierarchical

  4. Object-oriented

Show answer
Correct Option: C

A segment has 3 occurrences for a parent. This segment is called a ________
technology databases

  1. Multiple

  2. Twin

  3. Sibling

  4. None of These

Show answer
Correct Option: B

What is the maximum number of levels in IMS database?

technology databases

  1. 15

  2. 12

  3. 16

  4. 20

Show answer
Correct Option: A

What call is performed prior to a deletion call ?
technology databases

  1. GU

  2. GHU

  3. GN

  4. GNP

Show answer
Correct Option: B

Which of the following indicates the maximum number of entities that can be involved in a relationship?
technology databases

  1. Minimum cardinality

  2. Maximum cardinality

  3. ERD

  4. Greater Entity Count (GEC)

Show answer
Correct Option: B

Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?

technology databases

  1. Weak entity

  2. Strong entity

  3. ID-dependent entity

  4. ID-independent entity

Show answer
Correct Option: A

In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
technology databases

  1. parent

  2. child

  3. instance

  4. subtype

Show answer
Correct Option: A

Which type of entity represents an actual occurrence of an associated generalized entity?
technology databases

  1. Supertype entity

  2. Subtype entity

  3. Archetype entity

  4. Instance entity

Show answer
Correct Option: D