MC	Which statement is CORRECT?	Table cardinality is another way of referring to the number of columns in a table.	incorrect	If no further statistical information about a predicate is available, the filter factor of that predicate can be estimated by dividing 1 by the number of different values the attribute type can have.	correct	The filter factor of a predicate is the fraction of rows that contain a missing value for that predicate.	incorrect	SQL is a declarative language, meaning that the programmer has to specify what data to retrieve and how the data is to be located and retrieved from the physical database files.	incorrect	
MC	Statement 1: When opting for hard drive back-ups to maintain data availability in case of a calamity, the RPO depends on the underlying infrastructure. Choosing a SAN as storage subsystem might be a solution here, as it keeps the burden of data and backup related traffic from the LAN and from the servers.<br><br>Statement 2: Log shipping is a technique which is used for preserving the transaction context of a DBMS in case of a calamity. The remote DBMS used for replication can use the primary log for restoring transactions that were ongoing at the primary site.<br><br>Which statements are correct or wrong?	Statement 1 is correct, statement 2 is wrong.	incorrect	Both statements are correct.	incorrect	Statement 1 is wrong, statement 2 is correct.	correct	Both statements are wrong.	incorrect	
MC	Which statement is CORRECT?	Current versions of SQL impose a specific physical implementation of internal data models.	incorrect	Current versions of SQL do not impose any standardization on the internal data model nor on the way in which a relational data model is implemented physically.	correct	Current versions of SQL require both a specific internal data model AND a specific physical implementation of that data model.	incorrect	Current versions of SQL require a specific internal data model.	incorrect	
MC	Which statement is CORRECT?	Current versions of SQL do not impose any standardization on the internal data model nor on the way in which a relational data model is implemented physically.	correct	Current versions of SQL require both a specific internal data model AND a specific physical implementation of that data model.	incorrect	Current versions of SQL require a specific internal data model.	incorrect	Current versions of SQL impose a specific physical implementation of internal data models.	incorrect	
MC	Which statement is NOT CORRECT?	A DAS does not offer out-of-the-box capabilities for centralized storage management and sharing unused disk capacity across servers.	incorrect	With bit level data striping, every disk participates in each read or write operation.	incorrect	Current versions of SQL require a specific internal data model.	correct	It is often more efficient to combine multiple smaller physical disk drives into one larger logical drive because having multiple physical drives allows for parallel retrieval, which results in much more improved performance.	incorrect	
MC	Which statement is NOT CORRECT?	The SCSI I/O command set is a type of block-level I/O protocol which can be exchanged over SCSI, Ethernet or Fibre Channel cabling.	incorrect	Current versions of SQL do not impose any standardization on the internal data model nor on the way in which a relational data model is implemented physically.	incorrect	RAID level 0 is used if performance is more important than fault tolerance.	incorrect	Current versions of SQL impose a specific physical implementation of internal data models.	correct	
MC	Which statement is CORRECT?	Current versions of SQL do not impose any standardization on the internal data model nor on the way in which a relational data model is implemented physically.	correct	Current versions of SQL impose a specific physical implementation of internal data models.	incorrect	Current versions of SQL require a specific internal data model.	incorrect	Current versions of SQL require both a specific internal data model AND a specific physical implementation of that data model.	incorrect	
MC	Which statement is NOT CORRECT?	With bit level data striping, every disk participates in each read or write operation.	incorrect	For range queries, a primary or clustered index is more efficient than a secondary index.	incorrect	An index can be used to create a physical ordering of rows.	incorrect	Block level striping as used in RAID 0 does not increase read performance.	correct	
MC	Which statement is NOT CORRECT?	The number of block accesses determines the performance, not the number of rows retrieved. 	incorrect	Current versions of SQL require both a specific internal data model AND a specific physical implementation of that data model.	correct	An index implies a logical ordering of the rows in a table.	incorrect	RAID level 0 is used if performance is more important than fault tolerance.	incorrect	
MC	Which statement is NOT CORRECT?	With bit level data striping, every disk participates in each read or write operation.	incorrect	It is often more efficient to combine multiple smaller physical disk drives into one larger logical drive because reliability can be improved by introducing some measure of data redundancy. 	incorrect	Using error correcting codes for fault tolerance requires extra storage space, almost as much as when opting for disk mirroring.	correct	It is often more efficient to combine multiple smaller physical disk drives into one larger logical drive because having multiple physical drives allows for parallel retrieval, which results in much more improved performance.	incorrect