Introduction to SQL Which of the following SQL commands can be used to add data to a database table? UPDATE APPEND INSERT ADD UPDATE APPEND INSERT ADD ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is a view? 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. A view is a database diagram. None of these 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. A view is a database diagram. None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints gh bc ab 23 gh bc ab 23 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword BETWEEN is used: to limit the columns displayed. for ranges. as a wildcard. None of these to limit the columns displayed. for ranges. as a wildcard. None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL NULL is not a value the same as 0 for integer and blank for character the same as blank for character the same as 0 for integer not a value the same as 0 for integer and blank for character the same as blank for character the same as 0 for integer ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs Nothing TRUE Hi FLASE Nothing TRUE Hi FLASE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS