IMSE exam

1. 1Object-oriented technologies for DBMS

   1. AThe evolutionary approach
   2. BThe revolutionary approach
   3. CObject-relational DBMS
   4. DObject-oriented DBMS
   5. ERDBM Object
   6. FSemantic information
2. 2Pro OODBMS

   1. AData are manipulated directly from the programming language
   2. BNo SQL necessary
   3. CMore code to write
   4. DAllows to manipulate objects in main memory
   5. ESaves code and efforts for loading and storing huge data sets
   6. FLess code to write
   7. GOne object in main memory
3. 3Cons of OODBMS

   1. ADue to the power of many programming languages it is easy to make
      errors damaging the DBMS
   2. BComplexity of language complicates the automatic optimization
   3. CSupport of declarative queries not as good as in relational DBMS
   4. DPersistent-programming-language-based OODBs
   5. EMore code to write
4. 4Parallel Database Systems

   1. AGeographically centralized
   2. BCentralized administrated
   3. CFast interconnect
   4. DLocal transaction
   5. EMain focus: performance
   6. FSlow interconnect
   7. GMain focus: networking
5. 5Distributed Database Systems

   1. AGeographically distributed
   2. BSeparately administrated
   3. CSlow interconnect (typical Internet)
   4. DSeparation between local and global transaction
   5. EMain focus: sharing data, autonomy, availability
   6. FFast interconnect
   7. GInternationally distributed
6. 6Distributed Data Store Techniques

   1. AReplication
   2. BFragmentation
   3. CExtensibility
   4. DSelf-describing
7. 7Goals of XML

   1. AIntuitively comprehensible and easy processable
   2. BWorldwide data interchange, interbranch standardization
   3. CXML is a meta language for definition of new languages
   4. DNo strict format: tags can be extended
   5. ETypical for use in NoSQL DBMS
8. 8Advantages of XML

   1. AObjects are typeless (only strings)
   2. BSupports comments
   3. CSupports namespaces
   4. DEasy data exchange between systems
   5. EMany development tools
   6. FEasier to create, read and manipulate
   7. GEfficient to process
9. 9Advantages of JSON

   1. AJSON objects have a type (string, number, array, Boolean)
   2. BLighter syntax
   3. CEasier to create, read and manipulate
   4. DEfficient to process
   5. EPart of Javascript ecosystem
   6. FSupports namespaces
   7. GSupports comments
10. 10Advantages of NoSQL System to Relational DBMS

    1. AElastic Scaling Support
    2. BMade for Big Data
    3. CNo DBA Specialists necessary
    4. DFlexible data models
    5. ELow Costs
    6. FLacking Support
    7. GLacking Maturity
    8. HAdministration inadequately managed
    9. ILack of Expertise
    10. JNot Made for Analytics and Business Intelligence

11. 11RDBMS-MONGODB - choose which are right

    1. AA MongoDB instance may have zero or more databases
    2. BA database may have zero or more collections
    3. CA collection may have zero or more documents
    4. DA document may have one or more fields
    5. EMongoDB Indexes function much like their RDBMS counterparts
    6. FData aggregated within one structure (pre-JOINed)
    7. GRich data model, natural data representation
12. 12Advantages of document model

    1. ARich data model, natural data representation
    2. BData aggregated within one structure (pre-JOINed)
    3. CDynamic Schema
    4. DEconomy of mechanism
    5. EOpen design
13. 13Four Deployment Models

    1. APublic Cloud
    2. BPrivate Cloud
    3. CHybrid Cloud
    4. DCommunity Cloud
    5. EAmazon Cloud
    6. FShared Cloud
14. 14Classical principles for protected ITsystems

    1. AEconomy of mechanism
    2. BFail-safe defaults
    3. CComplete mediation
    4. DOpen design
    5. ESeparation of privilege
    6. FLeast privilege
    7. GLeast common mechanism
    8. HPsychological acceptability
    9. IMost privilage
    10. JClosed design
15. 15Technical security concepts

    1. AEncryption
    2. BCertificate
    3. CDigital signatures
    4. DPGP method
    5. EHTTPS
    6. FDecryption
    7. GKey sharing
    8. HGPG method
16. 16Characteristics of XML

    1. AExtensibility
    2. BStructured
    3. CSemi-structured
    4. DSelf-describing
    5. ELayout independent
    6. FValidity
    7. GInefficient
    8. HLighter-syntax
17. 17Comparison of XML to Relational Data

    1. AXML is inefficient
    2. BXML better than relational tuples for data exchange
    3. CXML data is self-describing by tags
    4. DNo strict format: tags can be extended
    5. ENested structures are allowed
    6. FTypical for use in NoSQL DBMS
    7. GWidespread, not only with DBMS, also in browser, tools and application
    8. HJSON objects have a type (string, number, array, Boolean)
    9. IEasier to create, read and manipulate
18. 18Cloud computing characteristics

    1. Aresource pooling
    2. Brapid elasticity
    3. Con-demand self-service
    4. Dbroad network access
    5. Emeasured service
    6. Fsoftware service
    7. Grich data access
19. 19SPI-Service models

    1. AInfrastructure as a Service
    2. BPlatform as a Service
    3. CSoftare as a Service
    4. DFunction as a Service
    5. ECloud as Service
    6. FNetwork-Sharind as a Service
20. 20Web Dev and virtualization

    1. Ahardware-level virtualization
    2. Bos- virtualization
    3. Cdesktop virtualization
    4. Dapplication virtualization
    5. Enetwork virtualization
    6. Finfrastructure virtualization
    7. Gbroad network virtulization

Description

Computer Science Quiz on IMSE exam, created by Nora Volina on 11/05/2022.

Author

Nora Volina

Language

English

Views

45

Tags

computer science

Rating

No ratings yet

Rate this quiz

Rate this quiz

More on Data Warehousing and Emerging Database Technologies