Write a SQL DML query to update the 'status' field to 'enable' in the table 'name_table' for the row matching the phone number 34657.
Ch 27: SQL Integrity Constraints
Enforcing schema-level business rules via SQL constraints, named constraints, and foreign key referential integrity actions (CASCADE, SET NULL).
16 Questions16 MCQs0 Short Questions0 Long Questions
SEMESTER PASS
CS403 - Database Management Systems Examination Practice
Timed practice exam simulation for CS403 - Database Management Systems.
Showing 11 – 16 of 16 Questions
Page 2 of 2
State the definition of Procedural DML and distinguish it from Non-Procedural DML.
Analyze the following SQL DDL statement:
```sql
ALTER TABLE exams
RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID;
```
True or False: The syntax of this ALTER TABLE statement is NOT correct.
Which DML statement changes the values of one or more columns based on some conditions, and what is its standard SQL syntax?
Analyze the following SQL DDL statement:
```sql
ALTER TABLE exams
RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID;
```
True or False: The syntax of this ALTER TABLE statement is NOT correct because standard SQL and SQL Server do not support renaming multiple columns within a single RENAME COLUMN clause.
Which Data Manipulation Language (DML) statement is used to change or modify the existing values of one or more columns in a table based on specified filtering conditions?