Quelpr

Manipulating Data in a Database · CSEC Information Technology

13 past-paper questions on Manipulating Data in a Database, part of Database Management, from every CSEC Information Technology paper on Quelpr.

Practise Manipulating Data in a Database
  1. 8(c)1 mark· CSEC Information Technology · 2011 · Paper 2The two tables have been joined by a common field. State the name of the Dean of the faculty that is offering the course with Cid = ECN 100.
  2. 8(d)2 marks· CSEC Information Technology · 2011 · Paper 2Write a query to show ALL courses in the NS faculty with MORE than 5 credits.
  3. 8(c)2 marks· CSEC Information Technology · 2015 · Paper 2A query was created on the STOCK table and the result is shown in Query2. State the criterion used for the query.
  4. 3(c)4 marks· CSEC Information Technology · 2022 · Paper 2Create a query by completing the query design view window to extract the fields ID, FirstName, LastName and Phone from the STUDENTS table, and the field SportName from the SPORTS table, for all married students who play…
  5. 3(d)2 marks· CSEC Information Technology · 2022 · Paper 2State the record IDs of the record(s) that would be extracted when the query designed in (c) is executed.
  6. 7(c)4 marks· CSEC Information Technology · January 2013 · Paper 2Write a query to obtain the names of ALL youths born after 31 December 1994.
  7. 8(c)1 mark· CSEC Information Technology · January 2014 · Paper 2If the records in the table are sorted from the newest to the oldest member, what will be the Membership_No. of the member who would be at the TOP of the sorted list?
  8. 8(d)(i)1 mark· CSEC Information Technology · January 2014 · Paper 2How many fields will be displayed when the query shown in the grid is executed?
  9. 8(d)(ii)1 mark· CSEC Information Technology · January 2014 · Paper 2How many records will be displayed when the query shown in the grid is executed?
  10. 8(c)2 marks· CSEC Information Technology · May/June 2013 · Paper 2Write the criteria to search the database table for all the persons who owe more than $500.00.
  11. Q401 mark · multiple choice· CSEC Information Technology · May/June 2018 · Paper 1In creating a query, a student entered the following criteria for the date field. >= 05/11/2017 and <= 05/14/2017 The output will show days
  12. Q431 mark · multiple choice· CSEC Information Technology · May/June 2019 · Paper 1In creating a query, a student entered the following criteria for the date field. >= 05/11/2017 and <= 05/14/2017 The output will show days
  13. 7(c)2 marks· CSEC Information Technology · May/June 2019 · Paper 2Write the results of a query that lists the learner drivers assigned to Rick.

Related topics in Database Management