Question: 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

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

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.

Step by Step Solution

3.40 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!