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