To insert non-sequential data into a MySQL table that uses AUTO_INCREMENT ________.
A) Disable AUTO_INCREMENT
B) Temporarily remove AUTO_INCREMENT
C) Use the AUTO_INCREMENT_INSERT command
D) Both A and C are correct
Correct Answer:
Verified
Q60: Logging into the MySQL DBMS is done
Q61: The MySQL keyword to close and exit
Q62: The MySQL statement used to complete the
Q63: To run a single SQL command in
Q64: The MySQL command line utility is _.
A)MySQL*Plus
B)the
Q66: The MySQL keyword to create a cursor
Q67: A new MySQL database is created using
Q68: The MySQL keyword used to retrieve a
Q69: The MySQL delimiter that must be used
Q70: The MySQL SQL/PSM code structure defines variables
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents