Which one of the following is descriptive of the effect of an Intent Shared Lock on other transactions? CHOICE1: A Read Lock that prevents writes CHOICE2: A Read Lock that prevents other reads
Does View occupy memory? If we delete the base table of existing view, What happens?
Latest Answer: Actually view is a stored select statement and its code is stored in data dictionary. It doesn't occupy space in the memory. whenever view is called, the stored select statement executes and fetches the data from the base table.If base table is deleted, ...
Where clause restricts rows, what does having clause restricts ?1. only group results.2. rows results.3. both rows and groups result.
Latest Answer: Having Clause: Restricts Aggregate or Group function result set. can be used with Group By CaluseWhere Clause: Restricts ...
Latest Answer: The columns which are used in SELECT clause should appear in GROUP BY clause except the column used in aggregate function. ...
There is a table having the following columns :-student id marks1 marks2 maxmarks1 10 20 202 25 30 303 30 10
Latest Answer: This can simply be done by using below written update statementUPDATE studentSET max_marks=greatest(marks1,marks2); ...
Have 2 table Emp1 (Column Name: Ename), 2nd table Emp2 (Column Name: First and Column Name: LastTable Name :Emp1ENameHunt, MichaelGraham, SmithNelson, Ryan Table Name: Emp2First LastMichael HuntSmith GrahamRyan NelsonNeed
Latest Answer: CREATE TABLE emp3 AS SELECT * FROM emp2;DROP TABLE emp2;RENAME emp1 TO emp2;RENAME emp3 TO emp2; ...
what is difference between nested query,sub query and nested query? explain clearly with an example?
Latest Answer: query inside the query is nested query.
it is also called as sub query.
Correlated subquery runs once for each row selected by the outer query. It contains a reference to a value from the row selected by the outer query.
Nested subquery runs only ...
How can I select column values from a table without knowing the column name ?Suppose , select employee_id from employees , now I don't know the column name and I want to select the column.Please let
Latest Answer: If you do not know the column name you want to select from the table, I would simply suggest you that, follow this command:
SELECT * FROM table_name
here * let you choose all the column name from the respective table. ...
Latest Answer: You can perform any DML operations in dual table provided that you have been given the privilege to do so.However never try to perform any DML operations (delete/insert/update) in dual table because dual is basically used to work with scalar query. If ...
WE using Last_value()analytical function but the result do not match according to me?
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
