What is the most suitable technique for fighting deadlock for the following? CPU, Memory, storage devices, files? and why?
A man spends half of his salary on household expenses, 1/4th for rent, 1/5th for travel expenses, the man deposits the rest in a bank. If his monthly deposits in the bank amount 50, what is his monthly salary?A. Rs.500B. Rs.1500C. Rs.1000D. Rs. 900
How many columns are retrieved from this query:SELECT address1||','||address2||','||address2 "Address" FROM employee;A. 1B. 2C. 3D. 0
How many mashes are there in 1 square meter of wire gauge if each mesh is 8mm long and 5mm wide?A. 2500B. 25000C. 250D. 250000
If table contains 100 rows and it is truncated, how many rows get updatedA. 0B. 1C. 100D. No rows updated
A view is aA. A Table in the database belonging to different schema.B. A query stored in the database in the form of an object.C. A part of a tableD. All the above.
Select 'oracle' from dual where null = null;A. oracleB. nullC. error outD. no rows selected
Which of the following is TRUE about a FUNCTION?A. can return a valueB. can be used in SQL statementC. all of the aboveD. none of the above
Difference between %TYPE and %ROWTYPEA. %ROWTYPE used to declare the field and %TYPE used to declare the recordB. %ROWTYPE used to declare the record and %TYPE used to declare the fieldC. BOTH ARE SAMED. %ROWTYPE gives an error.
For referential integrity to be maintained.A. Every foreign key value must have a corresponding primary/unique key valueB. No foreign key should have a corresponding primary key value.C. There should be an index on the tables.D. The tables should be in different schemas of the database.
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
