How to open a Database using Unix Command Please Do Reply

Answers were Sorted based on User's Feedback



How to open a Database using Unix Command Please Do Reply..

Answer / shradha

sqlplus user/password@host

Is This Answer Correct ?    23 Yes 3 No

How to open a Database using Unix Command Please Do Reply..

Answer / pavithra

Answer for Mysql:

mysql -u uname -h hostname -ppwd

Is This Answer Correct ?    23 Yes 6 No

How to open a Database using Unix Command Please Do Reply..

Answer / my name

isql -Uuname -Ppswd -Ddbname -Sdbservername -c

Is This Answer Correct ?    6 Yes 0 No

How to open a Database using Unix Command Please Do Reply..

Answer / srinivas panguluri

Answer for DB2:

db2 connect to database_name user schema_name using password

For rest of the SQL queries add db2 as alias

ex: db2 select * from tablename.

Is This Answer Correct ?    5 Yes 1 No

How to open a Database using Unix Command Please Do Reply..

Answer / navneet

sqlplus/enter
username
password

Is This Answer Correct ?    4 Yes 0 No

How to open a Database using Unix Command Please Do Reply..

Answer / pradeep

in sybase
isql_r -S Servername -U username -P Password
go
//write your query

Is This Answer Correct ?    0 Yes 0 No

How to open a Database using Unix Command Please Do Reply..

Answer / arvind kumar

Sudo -U Postgres psql Database_name;
It will prompt you for password give correct password and
you can access the given database if it exist.

Is This Answer Correct ?    1 Yes 2 No

How to open a Database using Unix Command Please Do Reply..

Answer / kiruthiga

for state database replica in unix(SVM command)

metadb -i

Is This Answer Correct ?    0 Yes 1 No

How to open a Database using Unix Command Please Do Reply..

Answer / srihari

vi or editor command

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Unix Commands Interview Questions

distinguish between user mode and kernel mode?

4 Answers   Infosys,


What difference between cmp and diff commands?

0 Answers  


what is the command to print last 8 lines of any text file.

10 Answers  


Name the various commands that are used for the user information in unix.

0 Answers  


Explain iostat, vmstat and netstat.

3 Answers   CTS, Wipro,


what is the advaantage of each user having its own copy of the shell?

2 Answers   Infosys,


What is the difference between pipe and xargs?

2 Answers   Amazon, CTS,


What is merge command in unix?

0 Answers  


What does grep v do?

0 Answers  


What is the use of awk command in unix?

0 Answers  


Which command is used to delete all files in the current directory and all its sub-directories?

0 Answers  


Give the command for finding the current date.

0 Answers  


Categories