what is oltp (online transaction processing)? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
What will be the output for the below Query Select 'High' from dual where null = null;
what is the difference between granting and creating a view?
What is diff between bulk collect and forall
Explain the insert into statements in sql?
Explain how exception handling is done in advance pl/sql?
What is a heap in sql?
what is 'mysqladmin' in mysql? : Sql dba
Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.
What are inbuilt functions in sql?
sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)
What is a left inner join?
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)