Шукаєте відповіді та рішення тестів для MUF0052 ICT Unit 2 - Semester 1, 2025? Перегляньте нашу велику колекцію перевірених відповідей для MUF0052 ICT Unit 2 - Semester 1, 2025 в mlearn.sunway.edu.my.
Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!
tblScores
| Player | Score1 | Score2 |
| Ant | 56 | 54 |
| Bill | 34 | 45 |
| Cat | 45 | 34 |
| Dave | 23 | 56 |
| Edward | 56 | 34 |
Which SELECT statement will calculate the TotalScore for each player?
Below are the Movies and Sales table of a relational database:
Dexter has created the following SQL query:
SELECT tblMovies.Title, tblMovies.Genre, tblSales.CopiesFROM tblMovies, tblSales;
How many records will be returned by the query?
Below are the Movies and Sales table of a relational database:
Dexter has created the following SQL query:
SELECT tblMovies.Title, tblMovies.Genre, tblSales.CopiesFROM tblMovies, tblSalesWHERE tblMovies.MovieID = tblSales.MovieID
How many records will be returned by the query?
Below is an entity-relationship diagram for a relational database:
Which best describes the relationship between customers and sales?
Below is data from a DBMS:
If the following query was run on the table above which CustomerID would appear first?
SELECT CustomerID, First, Last, PostcodeFROM tblCustomersORDER BY Postcode DESC;
Which of the following correctly describes a foreign key in the entity-relationship (ER) diagram?
A flat-file database consist of
What is the term used to describe that the same piece of data is stored in more than one location?
Below is data from a DBMS:
If the following query was run on the table above which CustomerID would appear first?
SELECT CustomerID, First, Last, PostcodeFROM tblCustomersORDER BY Postcode DESC;
Below is an entity-relationship diagram for a relational database:
Which best describes the relationship between customers and sales?