FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

SQL INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
6. What is the difference between ISNULL and IS NOT NULL operators?
  The IS NULL and IS NOT NULL operators are used to find the NULL and not NULL values respectively. The IS NULL operator returns TRUE, when the value is NULL; and FALSE, when the value is not NULL. The IS NOT NULL operator returns TRUE, when the value is not NULL; and FALSE, when the value is NULL.
Your Name Your Email-ID
Your Answer
 
7. What are the types of database users?
  Oracle is a multi user database management system and has predominantly two types of users :
  • DBA (Database Administrator)
  • Normal User
  Posted by ALEKHYA. (Nov 29, 2013)
 

1. Application programmers or Ordinary users
2. End users
3. Database Administrator (DBA)
4. System Analyst
  Posted by Rakesh. (Sep 26, 2013)
 

Sys & System

Your Name Your Email-ID
Your Answer
 
8. What are the types of character data types?
  There are seven character datatypes that can be used for defining columns in a table :
  • CHAR
  • VARCHAR2
  • CLOB
  • LONG
  • NCHAR
  • NVARCHAR2
  • NCLOB
Your Name Your Email-ID
Your Answer
 
9. What is reports server?
  Reports server is also a component of the middle tier and is hosted in the same node of the concurrent processing server. Reports server is used to produce business intelligence reports.
Your Name Your Email-ID
Your Answer
 
10. What is Oracle HTTP server?
  Oracle HTTP server is the Web server which is used by Oracle Applications. It processes all the requests received from the clients. The Web server includes a couple of additional components like Web listener, Jserv (Java Servlet Engine) and Java Server Pages.
Your Name Your Email-ID
Your Answer