CIT427 Question

CIT427 TMA4 Database System and Management

QUESTION 1.  Normally, the trasaction processing ___ supports querying by end­users.

  1. Signal
  2. Product
  3. System
  4. 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.

  1. Huge
  2. External
  3. Mutable
  4. Secondary

QUESTION 3. The __ feature can be categorised as random and sequential access.

  1. Productivity
  2. Reliability
  3. Accessibility
  4. Portability

QUESTION 4. In a central processing unit cache, the __ content addressible storage is often employed.

  1. Low
  2. Hardware
  3. Tertiary
  4. Software

QUESTION 5. __ systems are often employed in secondary, tertiary and offline storage.

  1. Table
  2. File
  3. Queue
  4. Link

QUESTION 6. The domain of the corresponding attributes must be the same, for a __ to be legal.

  1. SWAP
  2. GROUP
  3. UNION
  4. SET

QUESTION 7. Ordinarily, the __ sign denotes the set differnce in database management systems.

  1. Division
  2. Minus
  3. Product
  4. Slash

QUESTION 8. Writing the context of database management systems, the ___ sigma denotes the Select operation.

  1. Greek
  2. Roman

 

  1. Italian
  2. Turkish

QUESTION 9. The properties of instantiated objects are accessed by means of the __ name

  1. Class
  2. Form
  3. Queue
  4. Object

QUESTION 10. There are __ common operations in a relational algebra

  1. Four
  2. Five
  3. Six
  4. Three

QUESTION 11. In order to obtain maximum throughput, the storage media should be accessed ____

  1. Norminally
  2. Sequentially
  3. Randomly
  4. Logically

QUESTION 12. In a typical cartesian product, the __ operation is used in resolving naming issues.

  1. PUSH
  2. INSERT
  3. RENAME
  4. FILL

QUESTION 13. The ___ storage predominantly uses the volatile memory.

  1. Initial
  2. Secondary
  3. Final
  4. Primary

QUESTION 14. The actual time it takes to access a particular location on a specific form of storage is described as it’s

See also  Community lauds Gov Inuwa over infrastructural development

___ .

  1. Dormancy
  2. Latency
  3. Valency
  4. Polency

QUESTION 15. The __ symbol denotes the cartesian product of two relations.

  1. Addition
  2. Join
  3. Multiplication
  4. LINK

QUESTION 16. The time required to access a given byte of information in stored in a RAM is measured in __ of a

second.

  1. Thousandths
  2. Billionths

 

  1. Millionths
  2. Hundredths

QUESTION 17. Normally in project operations, __ rows are deleted

  1. Inserted
  2. Formed
  3. Deleted
  4. Returned

QUESTION 18. In database management systems, comparisons can be accomplished by means of ___

  1. Functions
  2. Operators
  3. Gates
  4. Delimits

QUESTION 19. The operation responsible for choosing tuples which satisfy a given predicate is the __ operation

  1. Query
  2. Drop
  3. Alter
  4. Select

QUESTION 20 __ capacity solid state drives consume less power

  1. Medium
  2. Low
  3. High
  4. Power

Be the first to comment

Leave a Reply

Your email address will not be published.


*