
Higher 2024
Quiz by Suzanne Miller
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
36 questions
Show answers
- Q1What is a compound key in a database?A single column key that identifies a rowA foreign key that references another tableAn index that speeds up query resultsA combination of two or more columns that uniquely identifies a row30s
- Q2Which of the following is an example of a compound key?PhoneNumberDateOfBirthCustomerID and OrderIDEmailAddress30s
- Q3In what scenario would you use a compound key?When you want to eliminate redundancyWhen no single column can uniquely identify recordsWhen the table has a primary keyWhen all columns are unique30s
- Q4Which of the following statements about compound keys is true?They can be used as primary keys in a database tableThey are always generated automaticallyThey are only used in relational databasesThey cannot include foreign keys30s
- Q5What is a common use of compound keys in relational databases?To simplify data retrieval proceduresTo store data in a flat formatTo create a unique identifier for a many-to-many relationshipTo prevent duplicate records in a single column30s
- Q6Which of the following scenarios is NOT appropriate for using a compound key?When combining two or more fields provides uniquenessWhen managing relationships between different tablesWhen implementing a many-to-many relationshipWhen a single column can uniquely identify each record30s
- Q7What is the main advantage of using a compound key?It allows for more complex queries and data relationshipsIt simplifies database designIt guarantees faster data retrievalIt encrypts sensitive information30s
- Q8What must you ensure when defining a compound key?The key can never contain null valuesThe combination of values must be unique for each recordThe key must consist of at least three columnsThe values must be of the same data type30s
- Q9In a compound key, what happens if one of the columns contains null values?The compound key cannot guarantee uniquenessThe database will reject the entryThe compound key is automatically correctedThe null values are ignored30s
- Q10Which of the following best describes how to create a compound key in SQL?Using a PRIMARY KEY constraint on multiple columnsSetting unique constraints on single columnsAdding an INDEX on multiple columnsDefining FOREIGN KEY references30s
- Q11Which of the following is a key principle of Agile methodologies?Following a fixed plan over adapting to changeIndividual tasks over team collaborationExtensive documentation over working softwareCustomer collaboration over contract negotiation30s
- Q12What is a common practice in Agile methodologies for tracking project progress?Daily stand-up meetingsMonthly status reportsIndividual performance appraisalsFormal project reviews every six months30s
- Q13Which of the following is NOT a characteristic of Agile methodologies?Adaptability to changing requirementsRigid adherence to a predefined planFrequent delivery of working softwareEmphasis on teamwork and collaboration30s
- Q14What is one major problem with using global variables in programming?They automatically manage memory.They always improve performance.They can only be used in one function.They can lead to code that is difficult to debug.30s
- Q15What is a primary reason to limit the use of global variables in team-based software development?They can cause conflicts between team members' code.They always provide up-to-date information.They make collaboration easier across different components.They are faster to access than local variables.30s