Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Multiple Choice Questions
Q2211: Fill in the blank: To create a relation with just the JobTitle column from NEW1, the PROJECT operation would use the syntax __________.
- A: `NEW2 <- PROJECT Name from NEW1`
- B: `NEW2 <- PROJECT JobTitle from NEW1`
- C: `NEW2 <- SELECT JobTitle from NEW1`
- D: `NEW2 <- EXTRACT JobTitle from NEW1`
View Answer
B
Q2212: Fill in the blank: The PROJECT operation is used to create a new relation containing __________ from an existing relation.
- A: Rows
- B: Columns
- C: Constraints
- D: Indexes
View Answer
B
Q2213: Which of the following operations extracts specific columns from a relation?
- A: PROJECT
- B: SELECT
- C: JOIN
- D: UNION
View Answer
B
Q2214: What type of relation is produced by the PROJECT operation `MAIL <- PROJECT Name, Address from EMPLOYEE`?
- A: A two-column relation containing names and addresses
- B: A relation with all employee details
- C: A single-column relation with names
- D: A relation with addresses only
View Answer
A
Q2215: Fill in the blank: The PROJECT operation on the relation EMPLOYEE with columns Name and Address will create a new relation called __________.
- A: ADDRESS
- B: NAME
- C: MAIL
- D: EMPLOYEE_CG
View Answer
A
Q2216: Which statement accurately describes the PROJECT operation?
- A: It filters rows based on conditions
- B: It combines tuples from multiple relations
- C: It selects specific columns from a relation
- D: It updates existing tuples in a relation
View Answer
C
Q2217: What does the JOIN operation in relational databases do?
- A: It combines rows from different relations
- B: It extracts columns from a relation
- C: It updates tuples in a relation
- D: It deletes tuples from a relation
View Answer
A
Q2218: In the JOIN operation `C <- JOIN A and B where A.W = B.X`, what does the condition `A.W = B.X` specify?
- A: The values of attributes W and X must be equal
- B: The values of attributes W and X must be different
- C: The values of attributes W and X must be greater than a threshold
- D: The values of attributes W and X must be less than a threshold
View Answer
A
Q2219: What is the purpose of prefixing attributes with the relation name in the JOIN operation?
- A: To ensure unique attribute names in the result relation
- B: To specify which relation to update
- C: To filter tuples based on attribute values
- D: To aggregate data from multiple relations
View Answer
A
Q2220: In the JOIN operation `C <- JOIN A and B where A.W < B.X`, what does `A.W < B.X` imply?
- A: Attribute W in relation A must be less than attribute X in relation B
- B: Attribute W in relation A must be greater than attribute X in relation B
- C: Attribute W in relation A must be equal to attribute X in relation B
- D: Attribute W in relation A must not be equal to attribute X in relation B
View Answer
A