Computer Systems Quiz

What factors could affect the performance of a CPU in a computer system? pick 2

• Color of the computer case

• Clock speed

• Type of mouse used

• Screen resolution

• Number of cores

Which of the following correctly describes the difference between RAM and ROM? pick 2

• RAM is non-volatile and ROM is volatile

• RAM and ROM are both types of external storage

• RAM is used for currently executing instructions and ROM is for start up instructions

• RAM is volatile and ROM is non-volatile

Which of the following could be a non-graphical use for a GPU in an insurance company? pick 2

• Enhancing video game graphics

• Processing complex numerical calculations

• Displaying high-resolution images

• Streaming videos

• Calculations on multiple data at the same time

What is the purpose of pipelining in a CPU?

• To reduce the physical size of the CPU

• Concurrent processing of multiple instructions. One instruction can be fetched as the previous is decoded...

• To decrease the heat generated by the CPU

• To increase the storage capacity of the CPU

What is the primary key in the provided database table?

• CustomerID

• Surname

• Phone

• CarReg

Which SQL statement would correctly display only the CustomerID and Surname for customers with the title "Miss" or "Mrs"?

• SELECT CustomerID, Surname FROM Customer WHERE Title = 'Miss' OR Title = 'Mrs'

• SELECT CustomerID, Surname FROM Customer WHERE Title = 'Miss' AND Title = 'Mrs'

• SELECT CustomerID, Surname FROM Customer WHERE Title = 'Miss' NOT Title = 'Mrs'

• SELECT * FROM Customer WHERE Title = 'Miss' OR Title = 'Mrs'

Identify a potential issue with the flat file database structure if a customer wants to insure more than one car at the same time.

• There would be no issue as each car can have a separate record.

• The database would need to create duplicate customer records for each car, leading to redundancy.

• The database automatically updates to accommodate multiple cars.

• The database structure allows for multiple cars under a single record without issues.

Describe how the flat file database structure could be altered to efficiently allow each

customer to insure multiple cars at the same time. (You may assume each car is insured

to only one customer.)

• Introduce a new table that links customers to their insured cars with foreign keys referencing customer ID and car ID.
• Use a hierarchical structure to store customer-car relationships.
• Merge all customer and car data into a single flat file.
• Create a separate file for each car insured by a customer.

What is the 8-bit binary representation of the decimal number 231?

• 11100111

• 11010111

• 10110111

• 10011111

What is the 8-bit binary representation of the hexadecimal number 6F?

• 01101111

• 11001111

• 10101111

• 10011111