Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Multiple Choice Questions
Q2191: Fill in the blank: The outcome of selecting information about a specific employee from the EMPLOYEE relation will always be a relation containing __________.
- A: Multiple tuples
- B: A summary of data
- C: One tuple
- D: No tuples
View Answer
C
Q2192: Which operation retrieves all tuples from a relation where a specific condition is met?
- A: Projection
- B: Selection
- C: Joins
- D: Aggregation
View Answer
B
Q2193: What is an example of a condition you might use in a SELECT operation on the JOB relation?
- A: Employee's age
- B: Job identification code
- C: Employee's name
- D: Department attribute
View Answer
B
Q2194: What kind of relation is formed when specific tuples are selected from a parent relation?
- A: A temporary relation
- B: A permanent relation
- C: A view
- D: A summary
View Answer
D
Q2195: What does the SELECT operation in relational databases do?
- A: It retrieves all tuples from a relation
- B: It creates a new relation with selected tuples
- C: It updates existing tuples in a relation
- D: It deletes tuples from a relation
View Answer
B
Q2196: In the statement `NEW <- SELECT from EMPLOYEE where EmplId = '34Y70'`, what is the purpose of `NEW`?
- A: It specifies the relation to be updated
- B: It specifies the relation to be deleted
- C: It specifies the new relation created from the selection
- D: It specifies the relation from which tuples are selected
View Answer
C
Q2197: What will be the content of the `NEW` relation after executing `NEW <- SELECT from EMPLOYEE where EmplId = '34Y70'`?
- A: Tuples matching the condition
- B: All tuples from EMPLOYEE
- C: No tuples
- D: Partial tuples matching the condition
View Answer
A
Q2198: Which attribute is used in the SELECT operation to filter tuples in the given example?
- A: EmplName
- B: EmplAddress
- C: EmplId
- D: EmplDept
View Answer
C
Q2199: What does the SELECT operation in the example `NEW <- SELECT from EMPLOYEE where EmplId = '34Y70'` focus on?
- A: Filtering tuples based on an attribute
- B: Joining relations
- C: Updating tuples
- D: Deleting tuples
View Answer
A
Q2200: Fill in the blank: The result of the SELECT operation `NEW <- SELECT from EMPLOYEE where EmplId = '34Y70'` will be a relation containing tuples where __________.
- A: The EmplId attribute is not equal to '34Y70'
- B: The EmplId attribute is equal to '34Y70'
- C: The EmplId attribute is greater than '34Y70'
- D: All tuples in EMPLOYEE
View Answer
B