Font size
WorksheetsHello
Total questions: 120
Worksheet time: 3hrs 30mins
Các lợi ích đáng kể của việc áp dụng quản lý cơ sở dữ liệu trong quản lý là gì?
Tiện lợi.
Đúng thời gian.
Thiếu sót.
Nhanh chóng.
What was the manual data management task before computers existed?
Very convenient.
Very laborious.
Very fast.
Very timely.
Which database management system is an open-source product?
ORACLE.
SQL Server.
DB2.
MySQL.
To download one of the MySQL versions, which address should you visit?
https://dav.mysql.com/download/mysql/.
https://dcv.mysqlserver.com/downloads/mysql/.
https://dev.mysql.com/downloads/mysql/.
https://duv.mysql.com.com/donloads/mysql/.
To download one of the two versions of HeidiSQL, which address should you visit?
https://www.heidisql.com/download.php.
https://www.heidisql.com/downloads.php.
https://www.haidisql.com/download.php.
https://www.hiedisql.com/download.php.
When double-clicking the HeidiSQL software icon, a window appears. What steps should be taken to enter the working window of HeidiSQL?
Enter Username and Password then click New.
No need to enter Username and Password, just click Open.
Enter Username and Password then click Open.
No need to enter Username and Password, just click New.
What type of software are MySQL and HeidiSQL?
Closed source.
Commercial.
Free.
Open source.
When the working interface of HeidiSQL is in English, what steps should be taken to change the interface to Vietnamese?
Select Tools/Preferences/Data editor/change in Application language.
Select Tools/Preferences/General/change in Application language.
Select Edit/Preferences/General/change in Application language.
Select Go to/Preferences/General/change in Application language.
What query should be typed in the MySQL command window to read all information from the nhacsi table in the mymusic database?
SELECT* FROM nhacsi;
FROM* SELECT nhacsi;
SELECT* WHERE nhacsi;
FROM* WHERE nhacsi;
What are the functions of the areas (1), (2), (3) in the HeidiSQL working window?
Area (1) is the list of existing databases, area (2) is the main working area, area (3) is the query input area.
Area (1) is the list of existing databases, area (2) is the query input area, area (3) is the main working area.
Area (1) is the query input area, area (2) is the list of existing databases, area (3) is the main working area.
Area (1) is the main working area, area (2) is the query input area, area (3) is the list of existing databases.
What are the popular database management systems today?
What are the limitations of MySQL?
What are the advantages of HeidiSQL?
Why does database management on computers provide more effective data retrieval and analysis compared to manual management?
Why is database management on computers usually faster, saving time and effort compared to manual management?
The bank X is facing difficulties in managing customer data. Searching for customer information takes a lot of time, affecting transaction activities. The head of the department believes that applying a database management system on computers can solve this problem. However, one employee argues that: a) Database management systems help manage data effectively. b) Applying database management systems cannot improve the speed of information retrieval. c) Database management systems help speed up information retrieval, thus shortening transaction time.
What types of keys are there in the QTCSDL software HeidiSQL?
Primary key, foreign key, unique key.
Primary key, foreign key, duplicate key.
Internal key, foreign key, unique key.
Primary key, secondary key, unique key.
The banthuam, casi, and bannhac tables are abbreviated as follows: banthuam(idBanthuam, idBannhac, idCasi) casi(idCasi, tenCasi) bannhac(idBannhac, tenBannhac, tenNhacsi). The banthuam table relates to the casi table through the field?
tenCasi, the banthuam table relates to the bannhac table through the field idBannhac.
tenCasi, the banthuam table relates to the bannhac table through the field tenBannhac.
idCasi, the banthuam table relates to the bannhac table through the field tenBannhac.
idCasi, the banthuam table relates to the bannhac table through the field idBannhac.
What songs did musician Hoang Viet compose?
Du kich song Lo and Vietnam my homeland.
Tinh Ca and Tien ve Ha Noi.
Nhac rung and Xa khoi.
Tinh Ca and Nhac rung.
Identify the primary key and foreign key for the tables?
idCasi in the banthuam table is the primary key of the banthuam table.
idCasi in the casi table is the primary key of the banthuam table.
idCasi in the casi table is the foreign key of the casi table.
idCasi in the banthuam table is the key in the casi table.
The fields tenNhacsi, tenCasi, tenBannhac can be chosen as ... with a maximum length of 255 characters (VARCHAR(255)). Fill in the missing word and the ellipsis.
integer type
string
foreign key
primary key
In the banthuam table, which field is chosen as the primary key, and why?
The field tenBannhac is chosen as the primary key because it uniquely identifies a music piece.
The field tenCasi is chosen as the primary key because it uniquely identifies a singer.
The field tenNhacsi is chosen as the primary key because it uniquely identifies a musician.
The field idBanthuam is chosen as the primary key because it uniquely identifies a recording.
Database management for music helps organizations optimize operations by not performing which of the following tasks?
Data management
Analysis
Security
Helping singers become famous
What data type is commonly used for the date of birth field?
INT
Auto-incrementing value
Date
Varchar
In the banthuam table, which field should be managed to oversee the recordings?
idBanthuam
tenBannhac
ten
What fields do I need to manage for the audio recordings?
idBanthuam
tenBannhac
tenNhacsi
tenCasi
What issues should be considered to organize the existing data table?
Analyze and rearrange data to reduce duplication
Summarize all information to be managed
Review management problems
Arrange it nicely and easy to use
Differentiate between a table and a record in a database?
List the steps to create a table in HeidiSQL?
In the QTCSDL system of HeidiSQL, what do you understand by the primary key and what is its role?
Differentiate between primary key and foreign key?
Identify the primary key and foreign key of the following table links?
To perform the steps of analyzing the proposal to establish a data model for a real management problem, such as managing students in a school, what unique factors must be identified as the primary key to ensure consistent management and avoid omissions?
Student ID
Full name
Citizen ID number
Date of birth
In the database system, primary keys and foreign keys are used. A student after designing a database for managing books made a statement about foreign keys.
Foreign keys add completeness to the data.
Foreign keys prevent data duplication.
Foreign keys link tables, ensuring data consistency.
With foreign keys, querying data is easier due to links.
When creating a new database in MySQL, which default character set is commonly used?
ASCII
utf8mb3
Unicode 2 byte
utf8mb4 (UTF-8)
If you accidentally select a field as the primary key, what is the way to correct it?
Delete the table and recreate it.
Right-click on the field
If you accidentally select a field as the primary key, how can you fix it?
Delete the table and recreate it.
Right-click on the field and select Delete column.
Double-click on the field and change the primary key.
Set the field as a foreign key.
To declare a primary key for a field, right-click on the field name you want to declare as primary key, you
select Create new index, select PRIMARY.
select Create new index, select KEY.
select Add column, select PRIMARY.
select Add column, select KEY.
When declaring the field 'tenNhacsi', which data type is suitable to store the name of the musician?
INT
VARCHAR
FLOAT
DATE
When declaring the field 'tenNhacsi', what is the maximum length usually used?
50
100
255
500
After completing the table declaration, what is the final step to save the table?
Close the table creation window.
Press the Save button.
Select Export.
Select Commit.
If you want to add a new field to the table 'nhacsi', which shortcut can be used?
Ctrl+S.
Ctrl+C.
Ctrl+Insert.
Ctrl+Delete.
To set the field 'idNhacsi' as the primary key, what action must be taken?
Select AUTO_INCREMENT.
Select foreign key.
Select PRIMARY in the Create new index section.
Select VARCHAR.
To create the table 'nhacsi' with the fields 'idNhacsi' and 'tenNhacsi', what is the data type of 'idNhacsi'?
VARCHAR.
INT.
TEXT.
FLOAT.
To implement a model for managing the list of district names of provinces/cities, you can identify the primary key in the table Province/City as
District code.
Town code.
Province/City code.
Town code.
When declaring the field 'idNhacsi', to ensure that this field does not accept NULL values, which option should be selected?
AUTO_INCREMENT
UNSIGNED
NOT NULL
DEFAULT
When creating a database 'mymusic' in MySQL, what is the default character set selected?
ASCII
utf8mb3
utf8mb4
Latin1
When creating the table 'nhacsi', which option should be selected for idNhacsi to auto-increment each time a new record is added?
UNSIGNED
AUTO_INCREMENT
DEFAULT
UNIQUE
How many fields does the following table have, and what are they?
There are 3 fields: field 1, field idBannhac, and field INT.
There are 3 fields: field Name, field Data Type, field Length/Set.
There are 3 fields: field idBannhac, field tenBannhac, and field idNhacsi.
There are 3 fields: field 1, field 2, and field 3.
When using AUTO_INCREMENT, which data type is usually used for primary key fields?
VARCHAR
FLOAT
CHAR
INT
Observe the image below and indicate which field is the unique key?
tenBannhac and idNhacsi.
idBannhacsi.
idBannhac.
There is no field.
To declare a foreign key, which tag should be clicked?
Please create a database to manage the names of districts/cities of Vietnam?
Please create the table City from the database managing the names of districts using HeidiSQL?
Open HeidiSQL and connect to your database (if you have one). If you do not have a database, you can create a new one by right-clicking?
To create the table 'Casi', what actions do I need to perform?
Assuming HeidiSQL already has the table tinh_thanhpho, please fill in the missing information in the table below?
Which of the following is a unique key?
tenBannhac and idNhacsi.
idBannhacsi.
idBannhac.
None of the above.
To declare a foreign key, which tag should you click on in the image below?
Click on the Basic tag.
Click on the Check contents tag.
Click on the Foreign keys tag.
Click on the Indexes tag.
The fields that are foreign keys of the table reference a field ... of another table. Fill in the missing phrase.
unique key
data
primary key
foreign key
To declare a unique key, which method is correct? Mark the fields you want to declare as unique, right-click on the marked area, select
Create new index, select PRIMARY.
Add to index, select PRIMARY.
Create new index, select KEY.
Create new index, select UNIQUE.
In the screen for creating a foreign key below, after clicking on the Foreign keys tag, which tag should you click next?
Click on the Indexes tag.
Click on the Options tag.
Click on the Basic tag.
Click on the Add new tag.
Observe the image below and identify which field is the primary key and which is the foreign key?
The primary key is idNhacsi, the foreign key is idBannhac.
The primary key is idBannhac, the foreign key is tenBannhac.
The primary key is idBannhac, the foreign key is idNhacsi.
The primary key is idNhacsi, the foreign key is tenBannhac.
Regarding foreign keys, when should the Foreign keys tag be used?
When operations relate to the primary key.
When operations relate to non-duplicate keys.
When operations relate to data.
When operations relate to foreign keys.
When creating a database to manage the names of districts/provinces of Vietnam, what is needed to create the Province/City table?
When creating a database to manage the names of districts/provinces of Vietnam, what fields are needed when creating the City/Province table?
Idtenthanhpho, tenthanhpho, tenquan (huyen)
tenthanhpho, thanhpho, tenquan (huyen)
tenthanhpho, tenquan (huyen)
Idtenthanhpho, tenquan (huyen)
What actions do I need to take to create the banthuam table?
When creating a table in a database that supports foreign keys, how is the foreign key established?
To create a foreign key idNhacsi, the following steps are taken: 1. Select Add new; 2. Select the Foreign keys tab; 3. Click on the box below Columns and select the foreign key field as idNhacsi and then select OK; 4. Click on the box below Reference table and select the reference table as nhacsi and then select OK; 5. Click on the box below Foreign columns and select the reference field for the nhacsi table as idNhacsi and then select OK; 6. Select Save. Rearrange the steps to have a proper execution.
An is experimenting with using HeidiSQL to create a database. An believes that creating a new table in HeidiSQL must be done by writing SQL commands. The classmates have the following opinions: a) HeidiSQL only allows creating tables by writing SQL commands. b) HeidiSQL provides a visual interface to create tables. c) Using the graphical interface simplifies table creation, even if the user does not know about SQL. d) An can use the graphical interface or write SQL commands to create tables in HeidiSQL.
HeidiSQL only allows creating tables by writing SQL commands.
HeidiSQL provides a visual interface to create tables.
Using the graphical interface simplifies table creation, even if the user does not know about SQL.
An can use the graphical interface or write SQL commands to create tables in HeidiSQL.
During the practice session in the computer lab, Binh wants to create a new table named 'hocsinh' in the database 'quanlytruonghoc'. Binh believes that just entering the table name is enough, and no additional information is needed. The classmates have the following opinions: a) When creating a table, it is necessary to declare the data fields and their corresponding data types. b) Each data field needs to have a data type.
When creating a table, it is necessary to declare the data fields and their corresponding data types.
Each data field needs to have a data type.
To add new data to the table nhacsi, select the table nhacsi and click on one of the tabs below?
Click on the Database tab: mymusic.
Click on the Table tab: nhacsi.
Click on the Data tab.
Click on the Query tab.
To add a new row of data, which of the following methods is correct?
Right-click on the data area of the table.
Click on the plus (+) icon.
Click on the cross (x) icon.
Press the Ctrl key on the keyboard.
Observe the image below and explain why the field idNhacsi appears with the word (NULL).
Because the field idNhacsi is the primary key, so no data needs to be entered for this field.
Because the field idNhacsi is the foreign key, so no data needs to be entered for this field.
Because the field idNhacsi is a non-duplicate key, so no data needs to be entered for this field.
Because the field idNhacsi has the INT type, AUTO_INCREMENT (automatically fill in the value).
To edit data in the table nhacsi. Suppose the entered data is missing, it needs to be corrected, for example, the musician's name Đỗ Nhuận does not have Vietnamese accents as shown below. To re-enter with Vietnamese accents, which of the following methods is correct?
Left-click on the input cell and re-enter.
Left-click on the input cell and press the Insert key, then re-enter.
Double-click on the input cell and re-enter.
Right-click on the input cell and select Refresh, then re-enter.
To delete rows of data in the table, which of the following actions is correct?
Press the Shift + Delete key combination.
Press the Ctrl + Delete key combination.
Click on the delete icon.
What are the operations to delete data rows in the table?
Press Shift + Delete.
Press Ctrl + Delete.
Click on the (+) sign.
Press Alt + Delete.
To view all data in the table nhacsi, which method is correct?
Select table nhacsi, click on the Table: nhacsi tab.
Select table nhacsi, click on the Database: mymusic tab.
Select table nhacsi, click on the Data tab.
Select table nhacsi, click on the Query tab.
To sort the order of a field, which method is correct?
Click on the field name to sort, when a triangle pointing up appears, it sorts in ascending order, when a square appears, it sorts in descending order.
Click on the field name to sort, when a triangle pointing up appears, it sorts in descending order, when a triangle pointing down appears, it sorts in ascending order.
Click on the field name to sort, when a triangle pointing up appears, it sorts in ascending order, when a rectangle appears, it sorts in descending order.
Click on the field name to sort, when a triangle pointing up appears, it sorts in ascending order, when a triangle pointing down appears, it sorts in descending order.
To filter data that meets a certain requirement, which operations can be performed?
Right-click on the data area below the field name you want to filter, select Find Text.
Right-click on the data area below the field name you want to filter, select Quick Filter.
Left-click on the data area below the field name you want to filter, select Quick Filter.
Right-click on the data area below the field name you want to filter, select Export data grid.
To work with SQL queries, which tab should be selected?
Table tab
Database tab
Query tab
Data tab
Which query is used to retrieve musician Văn Cao (including idNhacsi) from the nhacsi table?
Which of the following tags?
Table Tag
Database Tag
Query Tag
Data Tag
Which query is used to retrieve musician Van Cao (including idNhacsi) from the nhacsi table?
How does HeidiSQL support the main tasks of updating and retrieving data with simple tables that have no foreign keys?
For the bannhac table (idBannhac, tenBannhac, tenNhacsi) written concisely, please write the query to retrieve all information of the music table name:
How to delete a row of data in the table?
After practicing lesson 21, Ly stated that in HeidiSQL, to enter data into the database, attention should be paid to the following issues.
Enter values for tables with fewer constraints first, strictly adhere to the constraints.
Enter values arbitrarily because there are constraints.
Tables do not need to establish foreign keys.
Enter primary key fields according to the rules for management.
During the practice of computer science 11, students often wonder how to delete multiple rows of data in the database table on HeidiSQL, one student suggested the following ideas.
Select the data row and press the Delete key on the keyboard.
Select multiple data rows, then press Ctrl+Delete or use the delete icon.
Use the SQL DELETE command to delete data rows.
Right-click on each row and select Delete row.
Observe the image below and indicate which field does not need additional data?
Field tenBannhac.
Field idBannhac.
Field idNhacsi.
No need to add data to any field.
Choose the correct answer for the table below?
The bannhac table is in the mymusic database with 8 columns.
The mymusic table is in the bannhac database with 8 rows.
The bannhac table is in the mymusic database with 8 rows.
The mymusic table is in the mymusic database.
What is the structure of the table bannhac in the mymusic database?
The table bannhac in the mymusic database has 8 columns.
The table mymusic in the bannhac database has 8 rows.
The table bannhac in the mymusic database has 8 rows.
The table mymusic in the bannhac database has 8 columns.
When does the notification appear?
When deleting a data column.
When deleting a data table.
When deleting a database.
When deleting a data row.
When does the notification below appear?
When deleting data in the idNhacsi field in the bannhac table that references the foreign key in the idNhacsi field of the nhacsi table.
When deleting data in the idNhacsi field in the nhacsi table that references the foreign key in the idNhacsi field of the bannhac table.
When deleting data in the idNhacsi field in the nhacsi table that does not reference the foreign key in the idNhacsi field of the bannhac table.
When deleting data in the idNhacsi field in the bannhac table that does not reference the foreign key in the idNhacsi field of the nhacsi table.
To query data in SQL, we use
the ORDER BY clause.
the SELECT statement syntax.
the BETWEEN...AND operator.
another answer.
To edit data in the table, we perform
double-click on the data cell to edit.
left-click on the data cell to edit.
right-click and hold on the data cell to edit.
another answer.
Refer to the tables nhacsi and bannhac below, the query to retrieve all songs of the musician Văn Cao in the bannhac table
Refer to the bannhac table below. The query to retrieve the entire row of data with the song name 'Việt Nam quê hương tôi'
Use the query to add to the nhacsi table row number 5, musician name is Phú Quang and row number 6, musician name is Phan Huỳnh Điểu.
Use the query to delete row 6, musician name is Phan Huỳnh Điểu
Perform data update in the banthuam table using HeidiSQL to update data in the banthuam table.
The command to retrieve all data
What happens when trying to delete a musician in the nhacsi table that has been referenced in the bannhac table?
Data will be completely deleted from both nhacsi and bannhac tables.
The database management system will prevent deletion and report an error.
The nhacsi table will automatically update information to avoid reference errors.
Data in the bannhac table will automatically delete to match the operation in the nhacsi table.
Which key represents the relationship between tables?
Primary key.
Foreign key.
Secondary key.
Open key.
In the interface of a database management system, what can users use to retrieve data from other tables based on relationships?
Using data fields.
Using data query software like SQL queries or graphical tools.
Using data query tools like SQL queries or graphical tools.
Using foreign key data fields.
To retrieve data from tables that have relationships with each other, which option should be chosen?
Users need to use the primary key.
Users use third-party software.
To retrieve data from tables that have relationships with each other, which option should be chosen?
The user needs to use the primary key
The user uses third-party software
The user needs to use the JOIN statement to combine tables with each other via foreign key
Other answer
What does the JOIN command allow you to do?
You process information efficiently
You use data reasonably
You retrieve data from multiple tables at once by joining tables together via foreign key
Other answer
To use the SELECT * command, which option should you choose?
Specify the columns you want to select
Where you want to extract data
You want to select all columns in the table
Where you want to store data
What does the FROM table command do?
You want to select all columns in the table
Specify the columns you want to select
Where you want to extract data
You want to select all characters
In the following options, what does the * in SELECT * mean?
Specify the columns you want to select
Where you want to extract data
You want to select all columns in the table
Specify the data character
If you want the output data to have both fields to be able to compare explicitly, what should you do?
Rename the two field names (same field) in two tables to distinguish
Change the data format
Arrange the data to be the same
Other answer
To query more than two tables via foreign key linkage, how should you proceed?
Repeat the JOIN clause
Repeat the ORDER BY clause
Repeat the WHERE clause
Other answer
If the following value of the foreign key field is invalid, what happens?
HeidiSQL will report an error.
Allows you to perform the update operation.
HeidiSQL will not report an error.
Allows you to perform the export operation.
To get a list of recordings with the information idBanthuam, tenBannhac, tenTheloai, tenCasi of the recordings
In the practical session in the computer room, Lan wants to retrieve data from three tables 'banthuam', 'bannhac', and 'casi'. Lan believes that it is not possible to query on three tables at the same time. What do the students in the class think?
It is possible to retrieve data from three tables at the same time if they are linked.
Lan needs to use two JOIN clauses in the SQL statement to connect the three tables.
Lan can use the statement SELECT * FROM banthuam INNER JOIN bannhac ON banthuam.idBannhac = bannhac.idBannhac INNER JOIN casi ON banthuam.idCasi = casi.idCasi to get all information from the three tables.
It is not possible to retrieve data from the three tables 'banthuam', 'bannhac', and 'casi' because they are not linked.
Hoa is learning about the application 'Music Data Management'. Hoa believes that this application requires users to know how to write SQL statements to query data. What does Hung think?
Users need to know how to write SQL statements to use the application.
The 'Music Data Management' application has a friendly graphical interface, easy to use.
The application allows users to retrieve data from multiple tables without needing to write SQL statements.
Hoa can use the application to view the list of songs along with the names of the musicians, singers, and genres without knowing SQL.
To get a list of recordings with the information idBanthuam, tenBannhac, tenTheloai, tenCasi of the songs by musician Van Cao, what command should be used?
To get a list of recordings with the information idBanthuam, tenBannhac, tenTacgia, tenTheloai of the songs performed by singer Le Dung, what command should be used?
When a user updates data in a table containing a foreign key, what will HeidiSQL do?
