Business Intelligence & Analytics Nptel Week 3 Answers
Are you looking for Nptel Business Intelligence & Analytics Week 3 Answers ? You are here at right place for assignment answers.
Table of Contents
Nptel Business Intelligence & Analytics Week 3 Answers (Jan-Apr 2025)
Course link: Click here
Que. 1) What is the purpose of the semicolon (;) in SQL?
A) To comment out a line of code
B) To declare a variable
C) To terminate an SQL statement
D) To start a new SQL block
Que. 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?
A) PlayerID is a candidate key, PlayerName + TeamName is a superkey, and the primary key is the chosen candidate key like PlayerID.
B) PlayerID is a superkey, and PlayerName + TeamName is a candidate key because it includes more attributes.
C) PlayerName + TeamName is the only superkey, and PlayerID is the primary key because it is numeric.
D) Both PlayerID and PlayerName + TeamName are primary keys because they uniquely identify rows.
Que. 3) What is the primary purpose of a foreign key in a relational database?
A) To uniquely identify each row in its own table.
B) To establish a relationship between two tables by referencing columns in another table.
C) To enforce that a column contains only unique values.
D) To ensure a table has no duplicate rows.
Que. 4) Which SQL command would you use to find the total number of matches played by each team in the IPL 2023 season?
A) WHERE
B) ORDER BY
C) GROUP BY
D) COUNT
Que. 5) Which statement about INNER JOIN is correct?
A) Returns all records from the left table and matches records from the right table.
B) Returns only matching records from both tables.
C) Returns all records from both tables, including non-matching rows.
D) Returns all records from the right table and matches records from the left table.
Que. 6) Which of the following best characterizes the primary functionality of a data cube in multidimensional data analysis?
A) It organizes data into rows and columns only.
B) It allows for the analysis of data across multiple dimensions or perspectives.
C) It stores data in a strictly two-dimensional format.
D) It is only applicable for textual data analysis.
Que. 7) Consider a data cube with dimensions Course, Student, and Semester. Which cuboid represents the apex cuboid?
A) The 0-D cuboid, summarizing the total grades across all students, courses, and semesters.
B) The 3-D cuboid, showing data for all students, courses, and semesters.
C) The 1-D cuboid, summarizing data for courses only.
D) The 2-D cuboid, summarizing data for courses and students.
Que. 8) Which OLAP operation involves selecting a subcube using multiple dimensions?
A) Roll-up
B) Drill-down
C) Slice
D) Dice
Que. 9) In OLAP, the pivoting operation is used to ___________ the data dimensions for alternative presentation.
A) Aggregate
B) Rotate
C) Slice
D) Filter
Que. 10) Which normal form requires that there should be no multi-valued attributes in a relation?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Fourth Normal Form (4NF)
Que. 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?
A) Star schema
B) Snowflake schema
C) Fact constellation schema
D) Galaxy schema
Que. 12) Which SQL command removes all rows from a table while retaining the table structure?
A) DELETE
B) DROP
C) TRUNCATE
D) REMOVE
Que. 13) Which of the following refers to a key with more than one attribute?
A) Composite key
B) Compound key
C) Foreign key
D) Surrogate key
Que. 14) What action does the following SQL command perform?
INSERT INTO table_name
VALUES (value1, value2, value3);
A) Updates and removes specific rows from the table.
B) Inserts a new row with the given values into the table.
C) Updates existing rows and inserts new data.
D) Retrieves data while inserting a new row.
Que. 15) What is the main objective of database normalization?
A) To reduce data redundancy and improve data integrity.
B) To optimize query performance through indexing.
C) To enhance the database design.
D) To convert data into a non-relational format.
Nptel Business Intelligence & Analytics Week 3 Answers (Jan-Apr 2025)
For answers or latest updates join our telegram channel: Click here to join
These are Nptel Business Intelligence & Analytics Week 3 Answers
More Answers of Nptel Business Intelligence & Analytics: Click here
For answers to additional Nptel courses, please refer to this link: NPTEL Assignment
