Font size
WorksheetsDatabase Systems and Integration Assessment
Total questions: 21
Worksheet time: 15mins
What does SQL stand for?
Simple Query Language
Structured Query List
Structured Query Language
Standard Query Language
Explain the purpose of a primary key in a database.
The purpose of a primary key in a database is to uniquely identify each record in a table.
To group related records together in a table.
To store large amounts of data efficiently.
To define the data type of each column in a table.
What is the difference between INNER JOIN and LEFT JOIN in SQL?
INNER JOIN returns matching rows from both tables; LEFT JOIN returns all rows from the left table and matched rows from the right table.
INNER JOIN returns all rows from both tables; LEFT JOIN returns only unmatched rows from the left table.
INNER JOIN includes all rows from the right table; LEFT JOIN excludes unmatched rows from the left table.
INNER JOIN returns all rows from the left table; LEFT JOIN returns only matching rows from both tables.
Define normalization in the context of databases.
Normalization is the technique of merging all data into a single table.
Normalization is the process of organizing data in a database to minimize redundancy and dependency.
Normalization is the process of increasing data redundancy in a database.
Normalization refers to the method of encrypting data in a database.
What is the purpose of the SELECT statement in SQL?
To delete data from a database.
To create new tables in a database.
To update existing records in a database.
To retrieve data from a database.
List three common data types used in MySQL.
TEXT
INT, VARCHAR, DATE
BOOLEAN
FLOAT
What does CRUD stand for in database operations?
Create, Read, Update, Delete
Construct, Read, Update, Delete
Create, Retrieve, Update, Remove
Create, Read, Alter, Destroy
How do you connect to a MySQL database using Python?
Connect using 'mysql.connect()' with parameters.
Use 'connect_to_mysql()' with host and user details.
Use 'mysql.connector.connect(host='hostname', user='username', password='password', database='dbname')' to connect.
Use 'db.connect()' to establish a connection.
What is the function of the WHERE clause in SQL?
The WHERE clause filters records based on specified conditions.
The WHERE clause defines the structure of a database table.
The WHERE clause sorts records in ascending order.
The WHERE clause groups records by specified fields.
Explain the concept of foreign keys in relational databases.
Foreign keys are used to store large amounts of data in a single table.
Foreign keys are used to link two tables together in a relational database, ensuring data integrity and establishing relationships.
Foreign keys are a type of data type used in SQL queries.
Foreign keys are primarily used for indexing data in a database.
What is the significance of indexing in databases?
Indexing significantly enhances query performance and data retrieval speed in databases.
Indexing is only useful for large databases.
Indexing complicates data management.
Indexing reduces the size of the database.
Describe the role of the I2C protocol in sensor interfacing.
The I2C protocol enables efficient communication and control of multiple sensors using a two-wire interface.
I2C protocol requires four wires for sensor connections.
I2C protocol is primarily designed for video data transmission.
I2C protocol is used for wireless communication between sensors.
What is a graphical user interface (GUI)?
A GUI is a type of hardware used for computer networking.
A graphical user interface (GUI) is a visual interface that allows users to interact with a computer using graphical elements.
A GUI is a command-line interface that requires text input.
A GUI is a programming language used to create software applications.
List two advantages of using SQLite over MySQL.
Requires a dedicated server for operation.
Supports complex queries better than SQLite.
1. Serverless architecture, requiring no setup or management. 2. Database stored in a single file, enhancing portability and backup.
Automatically scales with increased data volume.
What is the purpose of the INSERT statement in SQL?
To delete existing records from a database table.
To update existing records in a database table.
To retrieve data from a database table.
To add new records to a database table.
Explain the difference between structured and unstructured data.
Structured data is always in text format, while unstructured data is numeric.
Structured data is organized and easily searchable, while unstructured data is unorganized and complex to analyze.
Unstructured data is easier to manage than structured data.
Structured data cannot be analyzed using software tools.
What is the TIG framework in user interface design?
The TIG framework is a user interface design approach that emphasizes Task, Information, and Goal.
The TIG framework is a method for testing user interfaces.
The TIG framework is a programming language for UI development.
The TIG framework focuses solely on visual aesthetics.
How can real-time data be integrated into a web interface?
Use HTML forms to submit data
Use WebSockets, AJAX, or server-sent events to integrate real-time data into a web interface.
Integrate static JSON files
Utilize CSS animations for data display
What is the purpose of the UPDATE statement in SQL?
To delete records from a table.
To modify existing records in a table.
To retrieve data from a table.
To create new tables in a database.
Describe the importance of user experience in interface design.
User experience is vital in interface design as it enhances usability, satisfaction, and user retention.
User experience is solely about the technical performance of the interface.
User experience only affects the aesthetic appeal of an interface.
User experience is irrelevant to interface design.
Register Number
(a)
