1.display list of all users from ur data base.what is the
query?

Answers were Sorted based on User's Feedback



1.display list of all users from ur data base.what is the query?..

Answer / nivitha

select * from dba_users order by desc;

Is This Answer Correct ?    18 Yes 5 No

1.display list of all users from ur data base.what is the query?..

Answer / srinivas

select * from all_users;

Is This Answer Correct ?    5 Yes 0 No

1.display list of all users from ur data base.what is the query?..

Answer / a.swarna devi

select * from user_tables;

Is This Answer Correct ?    0 Yes 8 No

Post New Answer

More Oracle General Interview Questions

How to create index-by table in oracle?

3 Answers  


How do I call oracle stored procedures that take no parameters?

0 Answers  


How to create a testing table in oracle?

0 Answers  


What are the four Oracle system processes that must always be up and running for the database to be useable?

0 Answers  


A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?

7 Answers   Cognizant, IBM,






How to start a specific oracle instance?

0 Answers  


There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

0 Answers  


When system tablespace is created?

0 Answers  


What is connection pooling in oracle?

0 Answers  


what is foreign key?

5 Answers  


How to export data with a field delimiter?

0 Answers  


What is a heap related to database ?

1 Answers   TCS, University of Edinburgh,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)