Questions
Which of the following is generally used to find and sort elements and text in an Extensible Markup Language (XML) document?
- XQuery
- Quilt
- XML-QL
- XQL
- Lorel
__________ is/are abstract and can have further subclasses.
- Multiple inheritance
- Relationships
- Data model
- Directed acyclic graph
- Non-leaf classes
_________ is/are considered a full backup of the database or dump of the database.
- Full database backup
- Differential backup
- Transaction log backup
- Redundant transaction logs
- Database buffers
Which of the following object oriented data model concepts comprise(s) of a state and behaviour, where a state is the group of values for the object's attributes and behavoiur is the group of methods?
- Object and object identifier
- Attributes and methods
- Class
- Class hierarchy and inheritance
- Procedures
Which of the following signifies a relation that relates database element with information regarding locking?
- Lock table
- Lock
- Two-phase locking
- Database recovery
- Scheduler
Which of the following approaches grants all S locks waiting, then one U lock and grants X lock if others are waiting?
- First-come-first-served
- Shared lock priority
- Upgrading priority
- Timestamp resolution
- None of these
__________ considers intervals of estimates and proposes heuristics to identify robust plans.
- EAO (Error-Aware Optimisation)
- LRU (Least Recently Used)
- QOS (Quality of Service)
- XML (Extensible Markup Language)
- Ripple joins
Which of the following are accessible from any of the processors through the communication network?
- Iterators
- Scanning tables
- Shared disks
- Shared memories
- None of these
A/An _________ system is a technique that allows you to take action automatically to events.
- active rules
- active database
- dynamic buffer allocation
- multimedia database
- None of these
Which of the following is used to store multimedia data such as videos, images and audios in binary format only?
- Abstract data type
- CLOB
- BLOB
- ODMG smalltalk binding
- ALOB
Which of the following transparencies resides when the user should recognise the data fragment names, but has no need to declare at which locations these fragments are situated?
- Fragmentation transparency
- Location transparency
- Local mapping transparency
- Horizontal fragmentation
- Failure transparency
Which of the following components of ODMG-93 standard determines how the various objects are represented for exchanging them between different OODBMS?
- Object model
- Object definition language
- Object interchange format
- Object query language
- Access mode
_________ simplifies data sharing between different users.
- Data fragmentation
- Distributed database
- Distributed transaction
- Distributed transaction coordinator
- Homogeneous database
Which of the following is/are the main criterion for the accuracy of simultaneous transaction executions and a main objective for concurrency control?
- Recoverability
- Transaction
- Serialisability
- Workflow systems
- Online transaction processing system
Which of the following has the ability to subdivide a single query into a number of parts and replicate them concurrently using either intra-partition parallelism or inter-partition parallelism or both?
- Degree of parallelism
- Intra-query parallelism
- Parallel database system
- Parallel I/O
- None of these