what is host string in sql plus? how does it related to
database?



what is host string in sql plus? how does it related to database?..

Answer / sudipta santra

Host string is the instance name of the database in the server.

when we are using sqlplus then we use to give the
username/password@<hostname>

It relate the user as a connectivity with that specified
instance.

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More Oracle General Interview Questions

what is null value?

9 Answers  


What is the purpose of a cluster?

1 Answers  


Can you drop an index associated with a unique or primary key constraint?

0 Answers  


If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

7 Answers   IBM,


Is a rollback possible to any savepoint?

0 Answers  


How index is implemented in oracle database?

0 Answers  


What are the uses of linked server and explain it in detail?

0 Answers  


How do I escape a reserved word in oracle?

0 Answers  


How can we Update a table with out using UPDATE command?

1 Answers  


Explain oracle’s system global area (sga).

0 Answers  


16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.

1 Answers   Wipro,


write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c

1 Answers   KPIT,


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • 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)