aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • Oracle SQL and Database Concepts
  • What does the following query Do?
Multiple choice technology databases

What does the following query Do?

  1. Null

  2. The Null values of COMMISSION column will be displayed as Null after addition to sal

  3. The Null values of COMMISSION column will be changed to 0 & will be added to sal

  4. Syntax error

Reveal answer Fill a bubble to check yourself
C Correct answer

Keep practicing — related questions

  • If commission is null then the text “Not Applicable” must be displayed, instead of blank space. How do I wr...
  • Consider the AGENTS table with columns AGENT_ID, AGENT_NAME, SALARY, SALES_QTY, Commission_Paid Write a que...
  • What will be the result of the given query? SELECT NULLIF(4,4) from dual
  • While doing an ascending order sort on a column having NULL values, where does the NULLs show up in the res...
  • What is the output of the the query: select 'Sql' from dual where null is null;
  • what is the output of the the query: select 'Sql' from dual where null = null;
  • What are the operations performed in modify stage?
  • Comparison with NULL is different in Sybase and MSSQL. How should it be handled in MSSQL?
Play the full quiz 🎤 Practise this topic out loud

Practice this topic

  • Database and SQL (3929 questions)
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy