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
  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
  1. DBA

  2. SYSTEM ADMIN

  3. APPLICATION DEVELOPERS

  4. ALL


Correct Option: D
  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

AWR WILL GIVE RECOMMENDATION?

  1. True

  2. False


Correct Option: A
  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
  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
  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