As a developer, you inherit this table as part of a project:
CREATE TABLE exam (
Exam_id INTEGER UNSIGNED NOT NULL PRIMARY KEY,
Examinee_id INTEGER UNSIGNED UNIQUE,
Score INTEGER UNSIGNED
)
What change should you make to ensure that examinee_id is an integer value throughout the table?
Which three view types are not updateable?
A MySQL command- line client is started with safe updates disabled.
Mysql - -safe – updates=0
What happens when you execute an UPDATE statement without a WHERE clause?
You attempt to create a temporary table by using the following statement:
CREATE TEMPORARY TABLE employeesMAIN
SELECT * FROM employees1
UNION ALL
SELECT * FROM employees2;
What is the result?
Copyright © 2021-2024 CertsTopics. All Rights Reserved
