Câu hỏi về SQL và CSDL

To retrieve data from the table 'banthuam' with specific conditions on the field 'idbannhac', what command do we use?

• SELECT * FROM banthuam;

• SELECT * FROM banthuam ORDER BY idbannhac ASC;

• SELECT idbannhac, idcasi FROM banthuam;

• SELECT * FROM banthuam WHERE idbannhac = 1; -- Assuming the value of idbannhac to find is 1

To query data in SQL, what do we use?

• ORDER BY clause

• SELECT statement syntax

• Using BETWEEN...AND operator

• INSERT statement

In the interface of a database management system, to retrieve data from other tables based on relationships, what can users do?

• Use data fields

• Use data query software like SQL queries or graphical tools

• Use data query tools like SQL queries or graphical tools

• Use properties

To retrieve data from tables that have relationships with each other, what must users do?

• Users need to use primary keys

• Users use third-party software

• Users need to use the JOIN statement to combine tables based on foreign keys

• Users use fourth-party software

A camera with high resolution will?

• Capture a broader image

• Capture images with more details

• Capture images with higher clarity and detail

• Capture a smaller image

Capturing images with more detail and higher clarity is equivalent to?

• You can enlarge the image while maintaining better quality

• You can shrink the image while maintaining better quality

• You can change the size while maintaining better quality

• You can change the image while maintaining better quality

The first step in the process is?

What is the first step to create a relational database?

• Create one or more forms

• Create one or more reports

• Create one or more questionnaires

• Create one or more tables

Which of the following actions is not a data update operation?

• Enter initial data

• Edit data that is not suitable

• Add records

• Copy the database to a backup

After which clause in SELECT - FROM - WHERE is the selection performed?

• GROUP BY HAVING

• SELECT

• WHERE

• FROM