What are the wildcard characters ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What are the wildcard characters ?

Q;What is "LINK" used for in WHERE clause? What are the wildcard characters

AN:
LINK is used for partial string matches. "%" ( for a string of any character ) and '_' ( for any single character ) are the two wildcard characters.

(Continued on next question...)

Other Job Interview Questions

• What is minimum authority required for one to create a tablespace?
• What is the use of VALUE function?
• What are aggregate functions?
• What is the result of this query if no rows are selected: SELECT SUM(SALARY) FROM EMP WHERE QUAL='MSC'; ?
• Apart from cursor, what other ways are available to you to retrieve a row from a table in embedded SQL?
• Explain the use of the WHERE clause?
• Suppose I have five SQL SELECT statements connected by UNION/UNION ALL ...
• What is the difference between static and dynamic SQL?
• What is a synonym?
• We have a table with a CHARACTER data type field
• More...