NPTEL Business Intelligence & Analytics Week 3 Assignment Answers 2025

By /

NPTEL Business Intelligence & Analytics Week 3 Assignment Answers 2025

1. What is the purpose of the semicolon (;) in SQL?

  • To comment out a line of code
  • To declare a variable
  • To terminate an SQL statement
  • To start a new SQL block
Answer :- For Answers Click Here

2. Consider an IPL_Players table with columns PlayerID, PlayerName, TeamName, and JerseyNumber:

In the context of superkeys, candidate keys, and primary keys, which of the following statements is true?

  • PlayerID is a candidate key, PlayerName + TeamName is a superkey, and the primary key is the chosen candidate key like PlayerID.
  • PlayerID is a superkey, and PlayerName + TeamName is a candidate key because it includes more attributes.
  • PlayerName + TeamName is the only superkey, and PlayerID is the primary key because it is numeric.
  • Both PlayerID and PlayerName + TeamName are primary keys because they uniquely identify rows.
Answer :-

3. What is the primary purpose of a foreign key in a relational database?

  • To uniquely identify each row in its own table.
  • To establish a relationship between two tables by referencing columns in another table.
  • To enforce that a column contains only unique values.
  • To ensure a table has no duplicate rows.
Answer :-

4. Which SQL command would you use to find the total number of matches played by each team in the IPL 2023 season?

  • WHERE
  • ORDER BY
  • GROUP BY
  • COUNT
Answer :-

5. Which statement about INNER JOIN is correct?

  • Returns all records from the left table and matches records from the right table.
  • Returns only matching records from both tables.
  • Returns all records from both tables, including non-matching rows.
  • Returns all records from the right table and matches records from the left table.
Answer :-

6. Which of the following best characterizes the primary functionality of a data cube in multidimensional data analysis?

  • It organizes data into rows and columns only.
  • It allows for the analysis of data across multiple dimensions or perspectives.
  • It stores data in a strictly two-dimensional format.
  • It is only applicable for textual data analysis.
Answer :- For Answers Click Here

7. Consider a data cube with dimensions Course, Student, and Semester. Which cuboid represents the apex cuboid?

  • The 0-D cuboid, summarizing the total grades across all students, courses, and semesters.
  • The 3-D cuboid, showing data for all students, courses, and semesters.
  • The 1-D cuboid, summarizing data for courses only.
  • The 2-D cuboid, summarizing data for courses and students.
Answer :-

8. Which OLAP operation involves selecting a subcube using multiple dimensions?

  • Roll-up
  • Drill-down
  • Slice
  • Dice
Answer :-

9. In OLAP, the pivoting operation is used to ___________ the data dimensions for alternative presentation.

  • Aggregate
  • Rotate
  • Slice
  • Filter
Answer :-

10. Which normal form requires that there should be no multi-valued attributes in a relation?

  • First Normal Form (1NF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)
  • Fourth Normal Form (4NF)
Answer :-

11. In which of the following multidimensional data models is each dimension represented by only one table, and each table contains a set of attributes?

  • Star schema
  • Snowflake schema
  • Fact constellation schema
  • Galaxy schema
Answer :- For Answers Click Here

12. Which SQL command removes all rows from a table while retaining the table structure?

  • DELETE
  • DROP
  • TRUNCATE
  • REMOVE
Answer :-

13. Which of the following refers to a key with more than one attribute?

  • Composite key
  • Compound key
  • Foreign key
  • Surrogate key
Answer :-

14. What action does the following SQL command perform?

INSERT INTO table_name
VALUES (value1, value2, value3);

  • Updates and removes specific rows from the table
  • Inserts a new row with the given values into the table.
  • Updates existing rows and inserts new data.
  • Retrieves data while inserting a new row
Answer :-

15. What is the main objective of database normalization?

  • To reduce data redundancy and improve data integrity
  • To optimize query performance through indexing
  • To enhance the database design
  • To convert data into a non-relational format
Answer :- For Answers Click Here

Related Posts

Scroll to Top