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: […]
Category Archives: sql Certificate
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 – Using the Set Operators Set operators are used to join the results of two (or more) SELECT statements.The SET operators available in Oracle 11g are UNION,UNION ALL,INTERSECT,and MINUS. The UNION set operator returns the combined results of the two SELECT statements.Essentially,it removes duplicates from the results i.e. only one row will be listed […]