Question 1 of 25
Hints left: 3
Q1
Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
Q2
A server cannot serve on which of the following levels?
Q3
Which of the following statements is true about symmetric multiprocessing?
Q4
Which of the following is true concerning the mainframe?
Q5
Which of the following statements is true concerning JDBC?
Q6
A pointer is a detailed coding scheme recognized by system software for representing organizational data.
Q7
Client/server security includes which of the following?
Q8
When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.
Q9
Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
Q10
Stored procedures have which of the following advantages?
Q11
Some advantages of partitioning include: efficiency, security, and load balancing.
Q12
Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.
Q13
A benefit of the three-tier architecture is which of the following?
Q14
The three newest database architectures in use today are relational, multidimensional and hierarchical.
Q15
Which of the following is true concerning QBE?
Q16
An extent is a contiguous section of disk storage space.
Q17
Three-tier architecture includes which of the following?
Q18
Which of the following items are not necessary for client/server?
Q19
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.
Q20
The three different application logic components are which of the following?
Q21
A bitmap index is an index on columns from two or more tables that come from the same domain of values.
Q22
A characteristic of a file server is which of the following?
Q23
A field represents each component of a composite attribute.
Q24
An application program interface (API) is which of the following?
Q25
It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.