This document is a review of an attempt on Quiz3 that occurred on Friday, November 3rd, 2023 at 8:47 PM and took 26 seconds to complete. The participant received a score of 3/15 (20%) with questions covering topics such as database schemas, entity-relationship diagrams, SQL queries, and functional dependencies. Several questions were answered incorrectly.
This document is a review of an attempt on Quiz3 that occurred on Friday, November 3rd, 2023 at 8:47 PM and took 26 seconds to complete. The participant received a score of 3/15 (20%) with questions covering topics such as database schemas, entity-relationship diagrams, SQL queries, and functional dependencies. Several questions were answered incorrectly.
This document is a review of an attempt on Quiz3 that occurred on Friday, November 3rd, 2023 at 8:47 PM and took 26 seconds to complete. The participant received a score of 3/15 (20%) with questions covering topics such as database schemas, entity-relationship diagrams, SQL queries, and functional dependencies. Several questions were answered incorrectly.
This document is a review of an attempt on Quiz3 that occurred on Friday, November 3rd, 2023 at 8:47 PM and took 26 seconds to complete. The participant received a score of 3/15 (20%) with questions covering topics such as database schemas, entity-relationship diagrams, SQL queries, and functional dependencies. Several questions were answered incorrectly.
State Finished Completed on Friday, 3 November 2023, 8:47 PM Time taken 26 secs Marks 3.00/15.00 Grade 2.00 out of 10.00 (20%)
Question 1 An ________ is a set of entities of the same type that share the same properties, or attributes. Complete Mark 0.00 out Select one: of 1.00 a. Attribute set b. Entity model
Question 2 Which of the following statements is correct?
Complete Mark 0.00 out Select one: of 1.00 a. Commit and Rollback are DCL commands b. Select, Insert and Update are DCL commands c. Grant and Revoke are DML commands d. With DDL, tables can be created and deleted
The correct answer is: With DDL, tables can be created and deleted
Question 3 Database __________ which is the logical design of the database, and the database _______ which is a snapshot of Complete the data in the database at a given instant in time. Mark 0.00 out of 1.00 Select one: a. Instance, Schema
Question 4 The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This Complete type of attribute is called Mark 1.00 out of 1.00 Select one: a. Composite attribute b. Simple attribute c. Multivalued attribute d. Derived attribute
The correct answer is: Composite attribute
Question 5 An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in Complete A.This is called as Mark 0.00 out of 1.00 Select one: a. Many-to-many
Question 6 In order to insert a column named a with data type varchar (20) into table A, we use the following code Complete Mark 0.00 out Select one: of 1.00 a. alter table A add a varchar(20) b. alter table A alter add a varchar(20) c. All of the above answers are not correct d. alter table A modify a varchar(20)
The correct answer is: alter table A add a varchar(20)
Question 7 Which of the following statements is true for data management using a file-based system? Complete Mark 0.00 out Select one: of 1.00 a. Security is well guaranteed b. Non of the above c. Avoid data redundancy d. Data is shared between applications
Question 8 In an Entity-Relationship Diagram “Ellipses” represents
Complete Mark 0.00 out Select one: of 1.00 a. Multi-valued attributes b. Attributes c. Weak entity set d. Relationship sets
The correct answer is: Attributes
Question 9 Table engineers has the following structure:
Complete engid int(4) Mark 1.00 out name varchar(50) of 1.00 salary int(4) Which of the following answers is correct for the requirement: output information to the two highest-paying employees. The results are ordered in descending order of salary.
Select one: a. SELECT TOP 2 * FROM engineers ORDER BY salary DESC, GROUP BY salary b. SELECT TOP 2 * FROM engineers ORDER BY max(salary) DESC c. SELECT TOP 2 * FROM engineers GROUP BY salary DESC d. SELECT TOP 2 * FROM engineers ORDER BY salary DESC
The correct answer is: SELECT TOP 2 * FROM engineers ORDER BY salary DESC
Question 12 The form of dependency in which the set of attributes that are neither a subset of the primary key nor the candidate keys is classified as Complete Mark 0.00 out Select one: of 1.00 a. Transitive dependency b. Full functional dependency c. Prime functional dependency
d. Partial dependency
The correct answer is: Transitive dependency
Question 13 Table employees has a salary column with the following values: Complete 10000, 11000, 12000, 10000, 14000, 12000, 13000, 10000, 14000, 10000 Mark 1.00 out Select distinct (salary) from employees will output: of 1.00
Select one: a. 10000, 11000, 12000, 14000, 13000 b. 10000, 14000, 12000, 10000, 11000
c. 10000, 11000, 14000, 12000, 13000, 10000
d. 10000, 11000, 12000, 10000, 14000, 12000
The correct answer is: 10000, 11000, 12000, 14000, 13000
Question 14 If there is more than one key for relation schema in relation model, then each key in relation schema is classified as Complete Mark 0.00 out of 1.00 Select one: a. Candidate key b. Super key c. Prime key
d. Primary key
The correct answer is: Candidate key
Question 15 How wrong is the following code?
Complete select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50) Mark 0.00 out of 1.00
Select one: a. Remove the brackets ‘(‘ and ‘)’ from the subquery b. must change ‘=’ by ‘in’ c. None of the above answers are correct d. In the sub-query, ‘*’ needs to be replaced by ‘OrderID’
