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 […]

SQL – Conversion Functions Questions 1. What will be the outcome of the following query? SELECT ROUND(144.23,-1) FROM dual; 140 144 150 100 Answer: A. The ROUND function will round off the value 144.23 according to the specified precision -1 and returns 140. Examine the structure of the EMPLOYEES table as given and answer the […]

SQL – Conditional Expressions Questions 1. What is true about data types in Oracle DB? They are given to columns for sorting purposes. They are given to columns for a structured representation in a table. They are given to columns to constrain the nature of the data it can store. They are not mandatory. Answer: […]