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!
A developer writes the following form.
<form method="GET" action="/search"> <input type="text" name="query"></form>
After the user submits it with the word "html" in the text box, the browser navigates to /search?query=html. Why does the submitted data appear in the URL?
A junior developer executes the following SQL statement:
<SQL>
DELETE FROM Employee;
What will be the result of this query?
Consider a relation R(StudentID, CourseID, Instructor, Grade) with the following functional dependencies:
Based on these dependencies, what is the highest normal form that relation R satisfies?
Consider the following HTML form and PHP code:
HTML
<form method="POST"> <input type="text" name="username"></form>
PHP
<?phpecho $_GET['username'];?>
After submitting the form, no value is printed. What is the most likely reason?
Match each SQL query with its correct purpose.
A developer wants the user to pick exactly one option from a group of three. Which input configuration is correct?
<input type="radio" name="size" value="s"> Small
<input type="radio" name="size" value="m"> Medium
<input type="radio" name="size" value="l"> Large
What is printed by the following PHP script?
PHP
$user = ["name" => "Sara", "age" => 21]; echo $user["name"];
A developer creates the following HTML link:
<a href="page.html">Click here</a>
However, when the user clicks the link, nothing happens. What is the most likely reason?
Consider the following HTML link:
<a href="#">Go</a>
When a user clicks this link, the page scrolls to the top. Why does this happen?
A company database shows that each Employee works in exactly one Department, but each department has many employees.
What is the correct relationship?