An example of a command a user would use when making changes to a PRODUCT table is .
A) CHANGE PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
B) ROLLBACK PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
C) EDIT PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
D) UPDATE PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
Correct Answer:
Verified
Q2: Some RDBMSs, such as Microsoft Access, automatically
Q5: Date procedures are often more software-specific than
Q8: SQL allows the use of logical restrictions
Q18: ANSI-standard SQL allows the use of special
Q24: Some RDBMSs,such as Oracle,automatically data changes when
Q25: The SQL data manipulation command HAVING:
A) restricts
Q27: UPDATE tablename *****
[WHERE conditionlist];
The command replaces the
Q31: When joining three or more tables,you need
Q33: In Oracle,the command is used to change
Q36: The SQL command that allows a user
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