⟩ Explain about the oracle disaster recovery scenarios?
USE DBNAME
go
EXEC sp_change_users_login 'Update_One', 'LoginUserid', 'LoginUserid'
Note: if you are using a different SQl login userid then this 'Login Userid' ,'NewloginUserid'
USE DBNAME
go
EXEC sp_change_users_login 'Update_One', 'LoginUserid', 'LoginUserid'
Note: if you are using a different SQl login userid then this 'Login Userid' ,'NewloginUserid'
Explain How do we replace a comma (,) with a blank in a select statement?
Explain Can a view be updated/inserted/deleted?
Explain What are the different types of SQL?
Explain some PL/SQL Exceptions?
Explain What is a Cartesian product?
Explain What is an Integrity Constraint?
Explain How do we eliminate the duplicate rows?
Explain What is meant by SORTING and GROUPING?
Explain What is the maximum number of triggers, can apply to a single table?
How to use SQL to build SQL, what is this called and give an example?