1. Data Definition Language (DDL) is used at the physical design step of the Database Lifecycle....

Transcribed Image Text:

1. Data Definition Language (DDL) is used at the physical design step of the Database Lifecycle. 2. Drill-down involves analyzing a given set of data at a finer level of detail. 3. An OLAP cube is created by converting the relational format into a dimensional format. 4. The following two SQL statements will produce different results. SELECT last_name, first_name FROM customer_t WHERE (state='MA' OR state = 'NY) AND (state= 'NJ' OR state = 'NH'); SELECT last_name, first_name FROM customer_t WHERE state IN (MA', 'NY', 'NJ', 'NH'); 5. DELETE FROM CUSTOMER_T deletes CUSTOMER T from the database. 6. When creating tables, it's not important to decide which columns will allow null values before the table is created. 7. OLAP uses the technique called "Cube" to visualize three-dimensional query results. 8. An INNER JOIN only displays data common to both tables; while in an OUTER JOIN, the data do not have to be common in both tables to be displayed. 9. Horizontal partitioning distributes the rows of a table into several separate files. 10. While inserting a row in a table, the values of the attributes do not need to be in the same order as columns in the table. 1. Data Definition Language (DDL) is used at the physical design step of the Database Lifecycle. 2. Drill-down involves analyzing a given set of data at a finer level of detail. 3. An OLAP cube is created by converting the relational format into a dimensional format. 4. The following two SQL statements will produce different results. SELECT last_name, first_name FROM customer_t WHERE (state='MA' OR state = 'NY) AND (state= 'NJ' OR state = 'NH'); SELECT last_name, first_name FROM customer_t WHERE state IN (MA', 'NY', 'NJ', 'NH'); 5. DELETE FROM CUSTOMER_T deletes CUSTOMER T from the database. 6. When creating tables, it's not important to decide which columns will allow null values before the table is created. 7. OLAP uses the technique called "Cube" to visualize three-dimensional query results. 8. An INNER JOIN only displays data common to both tables; while in an OUTER JOIN, the data do not have to be common in both tables to be displayed. 9. Horizontal partitioning distributes the rows of a table into several separate files. 10. While inserting a row in a table, the values of the attributes do not need to be in the same order as columns in the table.

Answer rating: 100% (QA)

Answer Total answers posted by the expert is 11301 Dear Student As per the requirement submitted abo... View the full answer