Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Multiple Choice Questions
Q2201: Fill in the blank: The `SELECT` operation in relational databases creates a new relation that contains only the tuples __________.
- A: From a different relation
- B: Matching the specified condition
- C: With all attributes of the parent relation
- D: Without any specific attributes
View Answer
B
Q2202: What kind of relation is formed by performing the SELECT operation with a condition?
- A: A relation with only one tuple
- B: A relation with no tuples
- C: A relation with all tuples
- D: A relation with tuples matching the condition
View Answer
D
Q2203: In the SELECT operation syntax `NEW <- SELECT from EMPLOYEE where EmplId = '34Y70'`, which part specifies the filter criterion?
- A: `NEW`
- B: `EMPLOYEE`
- C: `SELECT`
- D: `where EmplId = '34Y70'`
View Answer
D
Q2204: Fill in the blank: To create a relation containing tuples from `EMPLOYEE` where the `EmplId` is '34Y70', the SELECT operation would use the syntax __________.
- A: `NEW <- SELECT from EMPLOYEE where EmplId = '34Y70'`
- B: `NEW <- INSERT into EMPLOYEE where EmplId = '34Y70'`
- C: `NEW <- UPDATE EMPLOYEE where EmplId = '34Y70'`
- D: `NEW <- DELETE from EMPLOYEE where EmplId = '34Y70'`
View Answer
A
Q2205: What is the outcome if no tuples match the condition `EmplId = '34Y70'` in the SELECT operation?
- A: The `NEW` relation will contain all tuples from `EMPLOYEE`
- B: The `NEW` relation will contain only the tuples with different `EmplId` values
- C: The `NEW` relation will be empty
- D: The `NEW` relation will contain the same tuples as `EMPLOYEE`
View Answer
C
Q2206: What does the PROJECT operation in relational databases do?
- A: It extracts rows from a relation
- B: It extracts columns from a relation
- C: It updates tuples in a relation
- D: It deletes tuples from a relation
View Answer
B
Q2207: In the statement `NEW2 <- PROJECT JobTitle from NEW1`, what does `NEW2` represent?
- A: A new relation containing the JobTitle column
- B: A new relation containing all columns from NEW1
- C: A new relation with no data
- D: A new relation containing only the selected rows
View Answer
A
Q2208: What will the `MAIL` relation contain after executing `MAIL <- PROJECT Name, Address from EMPLOYEE`?
- A: A single column of names and addresses
- B: All columns of EMPLOYEE relation
- C: Only names of employees
- D: Only addresses of employees
View Answer
A
Q2209: If you want to extract multiple columns using the PROJECT operation, what should you specify?
- A: Multiple column names separated by commas
- B: One column name with a condition
- C: Multiple relations with a common column
- D: Only the first column of the relation
View Answer
A
Q2210: What is the result of the PROJECT operation `MAIL <- PROJECT Name, Address from EMPLOYEE`?
- A: A relation with employee names and addresses
- B: A relation with employee IDs and names
- C: A relation with all employee data
- D: A relation with only the department names
View Answer
A