SQL Certificate Mock Exams 1. What will be the outcome of the following query? SELECT ROUND(144.23,-1) FROM dual; 140 144 150 100 2.In which of the following cases, parenthesis should be specified? When INTERSECT is used with other set operators When UNION is used with UNION ALL When MINUS is used for the queries None […]
Author Archives: user
SQL Certificate – Useful Resources The following resources contain additional information on SQL Certificate. Please use them to get more in-depth knowledge on this topic. Useful Links on SQL Certificate − Database Language SQL (Proposed revised text of DIS 9075) July 1992 (Second Informal Review Draft). − DB2 resource for SQL users. − Oracle SQL […]
SQL – Using DDL Statements Using DDL Statements to Create and Manage Tables A schema is the collection of multiple database objects,which are known as schema objects.These objects have direct access by their owner schema.Below table lists the schema objects. Table – to store data View – to project data in a desired format from […]