D. Criteria cell 22. Microsoft Access uses Jet Query Engine which uses 30. If you write "Like Su in criterla cell of FirstName field it will display A. MS SOL Server B. Full fedged SQL C. Dialect of SQL D. None of above A All the narnes that are like Su such as Bunu, Kunal, Puna B. All the names that begin with Su such as Suresh, Sunita, Sumit C. Blank recordset D. Error message 23. You can enclose the prompt within square braces in criteria to create A Parameter query B. Select query C. Action query D. Crosstab query 31. To create queries in Access a. You can drag and drop fiolds on query builders b. you can type the SQL command in SOL view c You can use query wizard or 24. An)is an association that Is created in a query between a leld in one table or query and a feld of the same data type in another table or query iew d. All of above A Join 32. Following is not a database mode a. network database model b. relational database model c. Object Oriented database model d. None C. Connector D. Identifier 25. in a query whon you have multiple conditions and each of them must satisfy to return the result, use 33. In table design view, which key can be usod to switch betwoen the fiid names and A AND properties panels? C. NOT c FS 26. A query that uses inforrmation from two or more tables to get the results is called a(n) 34. Which of the following is NOT a type of Microsoft Access database object? A. Informal query. B. Optional query C. Complex query D. Multitable query 27. In MS Access query, which of the fields is derived fold? Query. SELECT product.qty AS Quanty, product.rate productaty product.rate AS Amount FROM AS Rate, 35. Which of the field has width 8 bytes? 36. Which is not a view to display a table in 28. Which of the following SQL query deletes Product table from Store database? a. Datasheet View b. Design View c. Pivot Table &Pivat Chart View d. None of above A DEL Product FROM Store B. DROP Product C. DROP TABLE Product D. Any of borc 37. Which of the following database object hold data? 29. When you need to restrict the records that meets certain conditions, you can mention b, A. Filter cel d. Tables