Interested to Buy Any Domain ? << Click Here >> for more details...
What is the advantage of specifying WITH GRANT OPTION in
the GRANT command?
- 2 Answers
- 9613 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kunal sain
the said user will be eligible to grant the privilege to
other user.
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / soni
the user to whom we give privilege by with grant
option,he/she will also have authority to give privilege
to others.
| Is This Answer Correct ? | 10 Yes | 0 No |
What happens on checkpoint?
What is for xml in sql server?
How is table type constraint applied to a table?
What is use of except clause? How it differs from not in clause?
How to find out what is the default collation in a database?
What are partitioned views?
hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting
What is the difference between index seek vs. Index scan?
* CREATE TABLE [dbo].[t_Colors]([ColorId] [int] NOT NULL,[ColorName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ColorDesc] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,[ColorIndex] [int] NULL) ON [PRIMARY] GO * insert into [t_Colors] values(101,'Red','',1) insert into [t_Colors] values(101,'Red1','',2) insert into [t_Colors] values(102,'Blue','',1) insert into [t_Colors] values(102,'Blue1','',2) insert into [t_Colors] values(102,'Blue2','',3) * In this table i need to delete DELETE FROM t_Colors WHERE ColorIndex=1 AND ColorId=102 After delete above condition i need to update the ColorIndex set to 1 for Blue1[ColorName] and 2 for Blue2[ColorName] select * from [t_Colors] Note:- how can i get updates the ColorIndex values after delete. for example we need to update Blue1 ColorIndex set to 1 and Blue2 ColorIndex set to 2
Explain the collation?
Write a query to find 5th highest amount paid from the customer table.
What is meant by Active-Passive and Active-Active clustering setup?
-
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)
