CIT427 TMA4 Database System and Management
QUESTION 1. Normally, the trasaction processing ___ supports querying by endusers.
- Signal
- Product
- System
- Action
QUESTION 2. The ___ database is one which is not owned by an organisation, but for which the organisation pays in
order to gain access.
- Huge
- External
- Mutable
- Secondary
QUESTION 3. The __ feature can be categorised as random and sequential access.
- Productivity
- Reliability
- Accessibility
- Portability
QUESTION 4. In a central processing unit cache, the __ content addressible storage is often employed.
- Low
- Hardware
- Tertiary
- Software
QUESTION 5. __ systems are often employed in secondary, tertiary and offline storage.
- Table
- File
- Queue
- Link
QUESTION 6. The domain of the corresponding attributes must be the same, for a __ to be legal.
- SWAP
- GROUP
- UNION
- SET
QUESTION 7. Ordinarily, the __ sign denotes the set differnce in database management systems.
- Division
- Minus
- Product
- Slash
QUESTION 8. Writing the context of database management systems, the ___ sigma denotes the Select operation.
- Greek
- Roman
- Italian
- Turkish
QUESTION 9. The properties of instantiated objects are accessed by means of the __ name
- Class
- Form
- Queue
- Object
QUESTION 10. There are __ common operations in a relational algebra
- Four
- Five
- Six
- Three
QUESTION 11. In order to obtain maximum throughput, the storage media should be accessed ____
- Norminally
- Sequentially
- Randomly
- Logically
QUESTION 12. In a typical cartesian product, the __ operation is used in resolving naming issues.
- PUSH
- INSERT
- RENAME
- FILL
QUESTION 13. The ___ storage predominantly uses the volatile memory.
- Initial
- Secondary
- Final
- Primary
QUESTION 14. The actual time it takes to access a particular location on a specific form of storage is described as it’s
___ .
- Dormancy
- Latency
- Valency
- Polency
QUESTION 15. The __ symbol denotes the cartesian product of two relations.
- Addition
- Join
- Multiplication
- LINK
QUESTION 16. The time required to access a given byte of information in stored in a RAM is measured in __ of a
second.
- Thousandths
- Billionths
- Millionths
- Hundredths
QUESTION 17. Normally in project operations, __ rows are deleted
- Inserted
- Formed
- Deleted
- Returned
QUESTION 18. In database management systems, comparisons can be accomplished by means of ___
- Functions
- Operators
- Gates
- Delimits
QUESTION 19. The operation responsible for choosing tuples which satisfy a given predicate is the __ operation
- Query
- Drop
- Alter
- Select
QUESTION 20 __ capacity solid state drives consume less power
- Medium
- Low
- High
- Power
Be the first to comment