There can be only one column per table with the AUTO_INCREMENT attribute.
A. True
B. False
Answer: Option A
Solution (By Examveda Team)
This question is asking about the AUTO_INCREMENT attribute in MySQL tables.AUTO_INCREMENT is a special attribute that automatically assigns a unique, increasing number to each new row inserted into a table.
The question asks if only one column per table can have this attribute.
The answer is A: True.
In MySQL, you can only have one column per table with the AUTO_INCREMENT attribute. This is because the attribute is used to create a unique primary key for each row, and having multiple columns with this attribute could lead to conflicts.
So, the correct answer is Option A: True.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network

Join The Discussion