Bissoy.com
Doctors Medicines MCQs Q&A

Which of the following statement does not execute a trigger?

Which of the following statement does not execute a trigger? Correct Answer SELECT

The SELECT command does not execute a trigger. A trigger is only executed automatically by a DDL (CREATE, ALTER, DROP) statement or a DML (DELETE, INSERT, UPDATE) statement and since SELECT does not comes under any of this category, hence it does not execute a trigger.

Related Questions

The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.
A', on 9th January, 2015 agrees to sell his immovable property to 'R' and out of the total sale consideration of Rs. 3,00,000/- receives a sum of Rs. 1,00,000/- from 'B' as advance payment and agrees to vacate the property and handover vacant peaceful physical possession thereof to 'B' and to execute the Sale Deed of the property in favour of 'B' on receipt of balance sale 'consideration' on or before 9th July, 2015. 'A' fails to vacate the property or to execute the Sale Deed or to deliver possession of the property to 'B'. 'B' after waiting patiently till 31st January, 2016, on 1st February, 2016 got issued a legal notice to 'A' to take the balance sale consideration and execute the Sale Deed and deliver vacant peaceful physical possession. 'A' vide his reply received by 'B' on 17th February, 2016 denies the agreement. The limitation of three years available to 'B' for instituting a suit for specific performance is:
Which of the following types of statement can trigger a trigger execution?
In . . . . . . . . first we execute the true statement . then we check the condition if the condition is true then it again execute the true statement .
In this question, a passage and a statement related to it have been given. Read carefully the verse and review the statement based on it. Delhi, which is one of India's capital an d one of the largest cities in the world, is undergoing severe crisis, due to its high level of urbanization, increasing population and high levels of pollution. Studies have proven that are the biggest factors of pollution used for industrial and domestic use? And due to their use, people here emit large quantities of nitrogen oxides (NOx), ozone (O3), black carbon (BC) and microorganisms (PM). According to the 2015 Global Burden of Disease report, there were 1.09 million deaths due to PM 2.5 in India. Air pollution was included as one of the 10 biggest threats to health. According to the World Health Organization, 37 cities of India are among 100 worst polluted cities in the world, where PM10 was found to be the highest ever. For the production of onoos, together with sunlight and heat, nitrogen oxides (NOx) and organic compounds (VOCs) are needed simultaneously. Therefore, in the summer months, ozone is produced in large quantities in the cities. Statement: Ozone does not arise more than a boundary on the ground in the summer months in cities. Select the most suitable from the following options A-statement is absolutely true B-statement is probably true C-statement can not be reviewed D-statement is completely false
Consider the following multi-threaded code segment (in a mix of C and pseudocode), invoked by two processes P1 and P2, and each of the processes spawns two threads T1 and T2: int x = 0; // global Lock L1; // global main() { create a thread to execute foo(); // Thread T1 create a thread to execute foo(); // Thread T2 wait for the two threads to finish execution; print (x);} foo() { int y = 0; Acquire L1; x = x + 1; y = y + 1; Release L1; print (y); } Which of the following statement(s) is/are correct ?
P, Q, R, S, T and U are six persons who have different mobiles - Nokia, Vivo, Oppo, Samsung, Apple and Jio (but not necessarily in the same order). P does not have Apple mobile. U does not have Oppo nor Vivo mobile. T has a Nokia mobile. R does not have Oppo nor Apple mobile. Q does not have Samsung nor Oppo mobile. P does not have Oppo nor Jio mobile. U does not have Jio nor Apple mobile. Which of the following combinations is correct?
On a non-pipelined sequential processor, a program segment, which is a part of the interrupt service routine, is given to transfer 500 bytes from an I/O device to memory.     Initialize the address register     Initialize the count to 500 LOOP: Load a byte from device     Store in memory at address given by address register     Increment the address register     Decrement the count     If count! = 0 go to LOOP Assume that each statement in this program is equivalent to a machine instruction which takes one clock cycle to execute if it is a non-load/store instruction. The load-store instructions take two clock cycles to execute. The designer of the system also has an alternate approach of using the DMA controller to implement the same transfer. The DMA controller requires 20 clock cycles for initialization and other overheads. Each DMA transfer cycle takes two clock cycles to transfer one byte of data from the device to the memory. What is the approximate speedup when the DMA controller based design is used in place of the interrupt driven program based input-output?
In this question a passage and a statement related to it have been given. Read carefully the passage and review the statement based on it. When Shah Jahan gave his love for Mumtaz, he would have believed that the river would continue to flow. There was no solid land on which the foundation could be laid. Therefore, to reduce the level of water, he used an engineering system to use the foundation of deep well and it was filled with stone and mud. Finally, he covered them with wooden box work structure and the tomb Made Yamuna is an integral part of the creation of the Taj and there was no such predict ion that it would dry up or become narrow. But the river was narrow and it became contaminated. The timber of wood is likely to be brittle or disintegrated as the venetian made on the foundation of wood, indicates that when the wood is submerged in the wood, the age of the wood increases. When the wood does not come in contact with oxygen, then that But such creatures cannot be found who destroy them. Due to the dryness and contamination of the Yamuna, the breakdown of a wooden tree can break. Statement. To maintain the structure of the TajMahal, a revival of Yamuna river is necessary. Choose one of the following options. A. The statement is definitely true. B. The statement is probably true. C. Statement cannot be determined D. Statement is definitely wrong.
In this question a passage and a statement related to it have been given. Read carefully the passage and review the statement based on it. When ShahJahan gave his love for Mumtaz, he would have believed that the river would continue to flow. There was no solid land on which the foundation could be laid. Therefore, to reduce the level of water, he used an engineering system to use the foundation of deep well and it was filled with stone and mud. Finally, he covered them with wooden box work structure and the tomb Made Yamuna is an integral part of the creation of the Taj and there was no such predict ion that it would dry up or become narrow. But the river was narrow and it became contaminated. The timber of wood is likely to be brittle or disintegrated as the venetian made on the foundation of wood, indicates that when the wood is submerged in the wood, the age of the wood increases. When the wood does not come in contact with oxygen, then that But such creatures cannot be found who destroy them. Due to the dryness and contamination of the Yamuna, the breakdown of a wooden tree can break. Statement: Tajmahal is built on a strong solid land along Yamuna river. Choose one of the following options. A. The statement is definitely true. B. The statement is probably true. C. Statement cannot be determined D. Statement is definitely wrong.