Un-Answered Questions { SQL PLSQL }

What is the difference between nvl function, ifnull function, and isnull function?

597


How to add a column ‘salary’ to a table employee_details?

595


What is the command used to fetch the first 5 characters of a string?

712


What is the difference between local variables and global variables?

616


What are all the different normalization?

564


What is a field in a database?

572


Can a table contain multiple primary key’s?

631


What is the sql case statement?

581


Explain sql data types?

629


What is the largest value that can be stored in a byte data field?

521


What are operators available in sql?

591


How to fetch values from testtable1 that are not in testtable2 without using not keyword?

759


What are user defined functions?

584


What is auto increment in sql?

589


How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

910