NEW
Font size
WorksheetsQuản trị CSDL
Total questions: 36
Worksheet time: 18mins
What is the main benefit of database management on computers?
Increase data processing speed and reduce errors
Reduce hardware requirements
No need for management personnel
Increase management costs
In database management systems, which function helps ensure data consistency?
Data integrity
User permission
High availability
Data security
Why is MySQL popular in database management?
Because it is inexpensive
Because it is open-source and free software
Because it only supports small systems
Because it does not require strong hardware
Which function of the database management system helps protect data from unauthorized access?
Data integrity
User permission
Data consistency
Data storage
What is HeidiSQL used for in database management?
Manage the graphical interface for MySQL
Run applications outside the system
Increase MySQL processing speed
Manage computer memory
One of the benefits of using a database management system is what?
Data is stored directly on paper
Data can be retrieved and edited quickly
Limit access rights of all users
No need to check data
In which cases is the MySQL database management system primarily used?
Only for small systems
Large database systems and Internet applications
Systems that do not require high security
Systems without network connectivity
What is a special feature of HeidiSQL?
Only supports MySQL
Supports multiple languages, including Vietnamese
Does not support Internet connection
Only available on Windows operating system
What is the benefit of database management systems in the banking sector?
Reduce manpower
Increase transaction processing time
Ensure transaction accuracy
What are the benefits of database management systems in banking?
Minimize labor
Increase transaction processing time
Ensure accurate and fast transactions
Limit automation capabilities
Why is it necessary to enter a password when accessing MySQL with root privileges?
To protect data from unauthorized access
To limit access time
To enhance processing speed
To control network access
What should be done to search for a song by composer Van Cao in the 'bannhac' table?
Filter by the 'idBannhac' field
Retrieve in descending order of song name
Filter data by the 'idNhacsi' field corresponding to composer Van Cao
Cannot search
What should a user do to modify data in the 'bannhac' table?
Delete old data and re-enter new data
Double-click on the data cell to edit and enter new data
Use SQL command to update data
Delete the table and recreate it
What is the 'idNhacsi' field in the 'bannhac' table called?
Primary key field
Foreign key field
Normal field
Field with no special features
How is the selection of a composer performed when adding new data to the 'bannhac' table?
Directly enter the composer's name into the 'idNhacsi' field
Select the composer from the list linked to the 'nhacsi' table
Create a new composer before entering data
No need to select a composer, just enter the song name
What is the default character set used when creating a new database in MySQL?
ASCII
utf8mb3
Unicode 2 byte
utf8mb4
What is the data type of 'idNhacsi' when creating the 'nhacsi' table with columns 'idNhacsi' and 'tenNhacsi'?
VARCHAR
INT
TEXT
FLOAT
What is the data type of 'idNhacsi' in the table 'nhacsi'?
VARCHAR
INT
TEXT
FLOAT
Which option should be selected to make 'idNhacsi' auto-increment?
AUTO_INCREMENT
UNSIGNED
NOT NULL
DEFAULT
What action must be taken to set 'idNhacsi' as the primary key?
Select AUTO_INCREMENT
Select PRIMARY in Create new index
Select foreign key
Select VARCHAR
What is the final step to save the table after declaring it?
Close the table creation window
Press the Save button
Select Export
Select Commit
Which data type is suitable for storing the name of the musician in 'tenNhacsi'?
INT
VARCHAR
FLOAT
DATE
What is the maximum length commonly used when declaring 'tenNhacsi'?
50
100
255
500
Which shortcut can be used to add a new column to the 'nhacsi' table?
Ctrl+S
Ctrl+C
Ctrl+Insert
Ctrl+Delete
Which option should be selected to ensure 'idNhacsi' does not accept NULL values?
AUTO_INCREMENT
UNSIGNED
NOT NULL
DEFAULT
In the table structure 'banthuam(idBanthuam, idBannhac, idCasi)', which column is chosen as the primary key?
idBanthuam
idBannhac
idCasi
tenBannhac
Why is it necessary to separate the table 'casi(idCasi, tenCasi)' instead of storing 'tenCasi' directly in 'banthuam'?
To reduce storage space and avoid data duplication
To store more singers
To query faster
To manage complex music records better
In the table structure 'bannhac(idBannhac, tenBannhac, idNhacsi)', what is 'idNhacsi'?
Primary key
Foreign key
Duplicate key
Just a field
In the table structure bannhac(idBannhac, tenBannhac, idNhacsi), what is the idNhacsi column?
Primary key
Foreign key
Unique key
Not necessary
When needing to manage additional information about the birth date of singers in the database, how should it be changed?
Add a column ngaysinh to the banthuam table
Add a column ngaysinh to the casi table
Create a new table to store birth date information
No need to change
If you want to manage additional information about the birthplace of musicians, how should the database be changed?
Add a column noisinh to the nhacsi table
Add a column noisinh to the bannhac table
Create a new table to store birthplace information
No need to change
Which column in the banthuam table(idBanthuam, idBannhac, idCasi) is a foreign key?
idBanthuam
idBannhac and idCasi
tenBannhac
tenCasi
Why is it necessary to have a foreign key in a relational database?
To reduce data duplication
To create relationships between tables
To make queries faster
To manage more data
In the nhacsi table(idNhacsi, tenNhacsi), what role does idNhacsi play?
Primary key
Foreign key
Unique key
Not necessary
Which column cannot have duplicate values in the bannhac table(idBannhac, tenBannhac, idNhacsi)?
idBannhac and idNhacsi
tenBannhac and idNhacsi
idBannhac and tenBannhac
idNhacsi and tenNhacsi
What is the benefit of using the AUTO_INCREMENT data type for primary key fields?
Automatically increase value when adding new records
Ensure unique value for each record
Help query data faster
Both A and B
