There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.
2 4445table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.
2 3933table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004
2 4074Post New Maruti Suzuki SQL PLSQL Interview Questions
Explain reduceByKey() Spark operation?
What is iot in tcs?
Can we place an excel file in a shared location and and use it to develop a report and refresh it in regular intervals?
Explain about the page-new method?
what is gridrotor resistance starter
How do we implement inheritance in c++?
What are the websphere editions available?
When we create a pf and did not fill up maint parameter, then by default which access path will the system take & why?
What are the different types of communications?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
what is the broker domain?
What is the difference between Role Based and Object Based Security Model in MSCRM?
Where is jre installed?
What is a a tag?
List out some key features of apache cassandra?