0

databases Online Quiz - 21

Description: databases Online Quiz - 21
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

PwC service lines to their clients are in the following categories in various countries

  1. Consumer and Industrial Products and Service

  2. Financial Services

  3. 1 and 2 only

  4. Only 2


Correct Option: C

PwC service lines to their clients are in the following categories in various countries

  1. Technology, Information, Communications and Entertainment

  2. Mortgage Processing Services

  3. 1 and 2 only

  4. Only 2


Correct Option: A

Academy of Motion Picture Arts and Sciences, gives PwC the unique distinction of having been (in various incarnations) the tabulator and certifier of votes for the Academy Awards since 1934

  1. True

  2. False


Correct Option: A

A Node in a domain is

  1. Logical representation of machine

  2. collection of domains

  3. Distributed set of administrative services

  4. Distribute set of application services and Service Manger


Correct Option: A
  1. Logical representation of machine

  2. collection of domains

  3. Distributed set of administrative services

  4. Distribute set of application services and Service Manger


Correct Option: A

Tuning can be done by?

  1. DBA

  2. SYSTEM ADMIN

  3. APPLICATION DEVELOPERS

  4. ALL


Correct Option: D

How to resolve incomplete checkpoints in database?

  1. SHU IMMEDIATE

  2. ADDING MORE REDO LOGS

  3. BOTH A AND B

  4. NONE OF THE ABOVE


Correct Option: B

Under what situation buffer busy wait event occur?

  1. NO FREE BUFFERS

  2. NOT ENOUGH SPACE IN DB CACHE

  3. CONCURRENT ACCESS BY USERS

  4. DIRTY BUFFER ARE NOT CHECKPOINTED


Correct Option: C
  1. run spcreate.sql

  2. run sptrunc.sql

  3. run spexp.par

  4. run spreport.sql


Correct Option: D
  1. Network

  2. Relational

  3. Hierarchical

  4. Object-oriented


Correct Option: C

What is the maximum number of levels in IMS database?

  1. 15

  2. 12

  3. 16

  4. 20


Correct Option: A

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

  1. Minimum cardinality

  2. Maximum cardinality

  3. ERD

  4. Greater Entity Count (GEC)


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?

  1. Weak entity

  2. Strong entity

  3. ID-dependent entity

  4. ID-independent entity


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.

  1. parent

  2. child

  3. instance

  4. subtype


Correct Option: A
  1. Supertype entity

  2. Subtype entity

  3. Archetype entity

  4. Instance entity


Correct Option: D
  1. itself

  2. a subtype entity

  3. an archetype entity

  4. an instance entity


Correct Option: A
- Hide questions