Un-Answered Questions { SQL PLSQL }

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

798


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

770


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

928


What is the difference between local variables and global variables?

800


What are all the different normalization?

744


What is a field in a database?

760


Can a table contain multiple primary key’s?

806


What is the sql case statement?

749


Explain sql data types?

830


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

709


What are operators available in sql?

786


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

958


What are user defined functions?

759


What is auto increment in sql?

825


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

1160