now one user in online.now i want drop him..how do u drop him?
Answer Posted / suman
DROP USER USERNAME CASCADE;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how does an oracle clusterware manage crs resources?
What are statistics, under what circumstances they go out of date, how do you update them?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What is transparent data encryption? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
What is a correlated sub-query? : sql server DBA
What is a system database and what is a user database? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
what are the performance views in an oracle rac environment?
What are the commands used in dcl? : sql server DBA
what is the diffrence between core dba and apps dba?