Introduction to SQL Which one of the following sorts rows in SQL? SORT BY ORDER BY ALIGN BY GROUP BY SORT BY ORDER BY ALIGN BY GROUP BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? EXISTS operator LIKE operator BETWEEN operator None of these EXISTS operator LIKE operator BETWEEN operator None of these 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 SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? TRUNCATE DELETE COMMIT ROLLBACK TRUNCATE DELETE COMMIT ROLLBACK 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
EXAMIANS