EXAMIANS
The three newest database architectures in use today are relational, multidimensional and hierarchical.
YOUR ANSWER : ?
YOUR ANSWER : ?
Which of the following improves a query's processing time?
YOUR ANSWER : ?
Some advantages of partitioning include: efficiency, security, and load balancing.
YOUR ANSWER : ?
When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.
YOUR ANSWER : ?
What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
YOUR ANSWER : ?
It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.
YOUR ANSWER : ?
What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?
YOUR ANSWER : ?
A secondary key is which of the following?
YOUR ANSWER : ?
In general, larger block sizes are used for online transaction processing applications and smaller block sizes are used for databases with a decision support or data warehousing system.
YOUR ANSWER : ?
Sequential retrieval on a primary key for sequential file storage has which of the following features?
YOUR ANSWER : ?