In Access which wild card is not mostly used?
Answer: A) !
In Microsoft Access, wildcard characters are used in queries to search for records that match a particular pattern.
Common wildcard characters include:
- \* (Asterisk): Represents zero or more characters. Example: A* matches Apple, Access, etc.
- ? (Question Mark): Represents exactly one character. Example: J?n matches Jan and Jon.
- \# (Hash): Represents any single digit (0–9). Example: A# matches A1, A2, A5, etc.
- ! (Exclamation Mark): Used in a character list to exclude characters in certain pattern searches, but it is not commonly used as a standalone wildcard.
Therefore, the expected answer is A. !
### व्याख्या (ने
Microsoft Access मा Query मार्फत कुनै निश्चित Pattern अनुसार Record खोज्न Wildcard Characters प्रयोग गरिन्छ।
मुख्य Wildcard Characters:
- \* (Asterisk): शून्य वा सोभन्दा बढी अक्षरलाई जनाउँछ। उदाहरण: A* ले Apple, Access आदि खोज्न सक्छ।
- ? (Question Mark): एउटा मात्र अक्षरलाई जनाउँछ। उदाहरण: J?n ले Jan वा Jon खोज्न सक्छ।
- \# (Hash): एउटा अंक (0–9) लाई जनाउँछ। उदाहरण: A# ले A1, A2, A5 आदि खोज्न सक्छ।
- ! (Exclamation Mark): Character List भित्र केही अक्षरहरूलाई हटाएर खोज्न प्रयोग हुन्छ। तर यो सामान्य Wildcard जस्तै धेरै प्रयोग हुँदैन।
त्यसैले अपेक्षित उत्तर A. ! (Exclamation Mark) हो।
Exam Tip:
* = Zero or more characters
? = Exactly one character
# = Any single digit (0–9)
! = Excludes characters in a character list
ध्यान दिनुहोस्: Access मा ANSI-89 र ANSI-92 जस्ता Query Pattern Standards अनुसार Wildcard Characters फरक हुन सक्छन्। माथिका *, ?, # र ! को व्याख्या ANSI-89 शैलीमा आधारित छ।