Question $1$ Not yet answered Marked out of $1\mathrm{.}00$ Question text A database management system can be thought of as replacing an organisation$$s: Select one: a$.$ Telephone b$.$ Records c$.$ Computers d$.$ Filing cabinet CLEAR MY CHOICE Question $2$ Not yet answered Marked out of $1\mathrm{.}00$ Question text Primary keys are used to identify a unique set of records. Select one: True False Question $3$ Not yet answered Marked out of $1\mathrm{.}00$ Question text Which of the following is not one of the strengths of the database approach? Select one: a$.$ Updating data is easier, as there is only one place where the data is housed. b$.$ A database can ensure that each piece of data is recorded in only one place; therefore, one can control redundancy and prevent inconsistencies. c$.$ Anyone can set up and edit a database. d$.$ Data can be kept more secure$.$ CLEAR MY CHOICE Question $4$ Not yet answered Marked out of $1\mathrm{.}00$ Question text Which of the following terms can be described as data that has been organised into tables from which data can be retrieved in a number of ways, with various views, without having to restructure the database tables themselves? Select one: a$.$ Data warehouse b$.$ Entity relationship model c$.$ Relational database d$.$ Spreadsheet CLEAR MY CHOICE Question $5$ Not yet answered Marked out of $1\mathrm{.}00$ Question text This is the standard programming language used for creating, editing, and accessing data from a relational database: Select one: a$.$ Primary key b$.$ Microsoft Access c$.$ Oracle d$.$ Structured Query Language $($SQL$)$ CLEAR MY CHOICE Question $6$ Not yet answered Marked out of $1\mathrm{.}00$ Question text You want to create a database that includes data about your $100$ favourite songs of all time. Your database will include data related to the song title, artist, album, release date, etc. In your top $100$ table, each record will represent: Select one: a$.$ An album b$.$ Release date c$.$ An artist d$.$ A song CLEAR MY CHOICE Question $7$ Not yet answered Marked out of $1\mathrm{.}00$ Question text Which of the following holds a single piece of data? Select one: a$.$ Record b$.$ Primary key c$.$ Field d$.$ Table CLEAR MY CHOICE Question $8$ Not yet answered Marked out of $1\mathrm{.}00$ Question text An attribute can be defined as a property of an entity or a relationship type. Select one: True False Information Information text Questions $913$ relate to Figure $1$ below: Figure $1$: Entity relationship model Question $9$ Not yet answered Marked out of $1\mathrm{.}00$ Question text Which one of the following statements is correct? Select one: a$.$ A hiring manager may oversee the work of one or more recruiters, but not all hiring managers necessarily oversee the work of any recruiters. b$.$ A recruiter can only be assigned one hiring manager at a time. c$.$ Each hiring manager must oversee at least one recruiter. d$.$ Each hiring manager oversees at least one recruiter$$s work, and each recruiter has at least one hiring manager. CLEAR MY CHOICE Question $10$ Not yet answered Marked out of $1\mathrm{.}00$ Question text The relationship between the Hiring manager and Job posting tables indicates that each job posting can only be registered under one hiring manager, and each hiring manager is assigned at least one job posting. Select one: True False Question $11$ Not yet answered Marked out of $1\mathrm{.}00$ Question text The relationship between the Application and Applicant table indicates that: Select one: a$.$ Not every application is linked to an applicant. b$.$ Each application record is linked to only one applicant. c$.$ There can be only one application per applicant. d$.$ There is a many$-$to$-$many relationship. CLEAR MY CHOICE Question $12$ Not yet answered Marked out of $1\mathrm{.}00$ Question text Which table will have more than two foreign keys? Select one: a$.$ Application b$.$ Recruiter c$.$ Hiring manager d$.$ Job posting CLEAR MY CHOICE Question $13$ Not yet answered Marked out of $1\mathrm{.}00$ Question text Each hiring recruiter has at least one hiring manager. Select one: True False Question $14$ Not yet answered Marked out of $1\mathrm{.}00$ Question text Databases prevent multiple users from accessing the data at the same time. Select one: True False Question $15$ Not yet answered Marked out of $1\mathrm{.}00$ Question text A column that is used to enforce a relationship between two tables, so that the same data can be represented in more than one table without having to be re$-$entered, is called a: Select one: a$.$ Entity relationship b$.$ Primary key c$.$ Foreign key d$.$ Join