Introduction to SQL Which of the following join is also called as an 'inner-join'? Non-Equijoin Equijoin None of these Self-Join Non-Equijoin Equijoin None of these Self-Join ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL NULL is the same as blank for character not a value the same as 0 for integer the same as 0 for integer and blank for character the same as blank for character not a value the same as 0 for integer the same as 0 for integer and blank for character ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The FROM SQL clause is used to... specify range for search condition specify search condition None of these specify what table we are selecting or deleting data FROM specify range for search condition specify search condition None of these specify what table we are selecting or deleting data FROM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the meaning of LIKE '%0%0%' Feature begins with two 0's Feature has two 0's in it, at any position Feature ends with two 0's Feature has more than two 0's Feature begins with two 0's Feature has two 0's in it, at any position Feature ends with two 0's Feature has more than two 0's ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? Data Manipulation Language(DML) Both of above Data Definition Language(DDL) None Data Manipulation Language(DML) Both of above Data Definition Language(DDL) None ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is a view? 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 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. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS