Looking for Databases & Interfaces (COMP1044 UNMC) (SPM1 25-26) test answers and solutions? Browse our comprehensive collection of verified answers for Databases & Interfaces (COMP1044 UNMC) (SPM1 25-26) at moodle.nottingham.ac.uk.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
Which keyword CANNOT be used to declare a variable in modern JavaScript?
Which of the following is the correct way to embed an external JavaScript file in an HTML page?
Consider the following Orders table:
order_id | amount |
1 | 50 |
2 | 200 |
3 | 150 |
4 | 80 |
And the SQL query:
<SQL>
SELECT order_id FROM OrdersWHERE amount > 80ORDER BY amount DESC;
What is the output of this query?
A junior developer executes the following SQL statement:
<SQL>
INSERT INTO Student (ID, Name) VALUES (7, 'New');
What happens if ID is the primary key and the value 7 already exists in the table?
Which attribute on an <a> element causes the link to open in a new browser tab?
A background image is repeating across an element, but the developer wants it to display only once. Which CSS declaration will prevent the image from repeating?
What is printed by the code below?
JavaScript
let name = "Ali";console.log(`Hello ${name}`);
In a company, employees can supervise other employees. In an Entity-Relationship (ER) diagram, how should this relationship be modeled?
Consider a relation R(EmployeeID, DeptID, DeptName) with the following functional dependencies:
Which normalization step is required to improve this relation?
Consider the following SQL query:
<SQL>
DELETE FROM Employee WHERE Dept = 'HR';
What will happen if there are no employees in the HR department?