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
  1. Consumer and Industrial Products and Service

  2. Financial Services

  3. 1 and 2 only

  4. Only 2


Correct Option: C
  1. Technology, Information, Communications and Entertainment

  2. Mortgage Processing Services

  3. 1 and 2 only

  4. Only 2


Correct Option: A

PwC audits 40 per cent of companies in the FTSE 100 Index and 45 per cent of the Fortune 1000 energy companies

  1. True

  2. False


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

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

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
  1. Minimum cardinality

  2. Maximum cardinality

  3. ERD

  4. Greater Entity Count (GEC)


Correct Option: B
  1. Supertype entity

  2. Subtype entity

  3. Archetype entity

  4. Instance entity


Correct Option: D

A recursive relationship is a relationship between an entity and ________ .

  1. itself

  2. a subtype entity

  3. an archetype entity

  4. an instance entity


Correct Option: A
- Hide questions