Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: REMOVE FROM CUSTOMER ... UPDATE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... REMOVE FROM CUSTOMER ... UPDATE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is a view? A view is a database diagram. A view is a special stored procedure executed when certain event occurs. A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are. None of these A view is a database diagram. A view is a special stored procedure executed when certain event occurs. A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are. None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters." True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; None of these SELECT SYSDATE - SYSDATE FROM DUAL; SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; None of these SELECT SYSDATE - SYSDATE FROM DUAL; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements. True False True False ANSWER DOWNLOAD EXAMIANS APP