Oracle interview Questions

1.What are the various types of queries ?

The types of queries are:

• Normal Queries
• Sub Queries
• Co-related queries
• Nested queries
• Compound queries

Linux Interview Questions

Linux Interview Questions:

1. How can you determine the space left in a file system? 

Level: Low 

Expected answer: There are several commands to do this: du, df, or bdf 

2. How can you determine the number of SQLNET users logged in to the UNIX system? 

Level: Intermediate 

Expected answer: SQLNET users will show up with a process unique name that begins with oracle, if you do a ps -ef|grep oracle|wc -l you can get a count of the number of users.