In MS Access query, which of the fields is derived field? Query: SELECT product.qty AS Quantity, product.rate AS Rate, product.qty*product.rate AS Amount FROM product;
A. Quantity
B. Rate
C. Amount
D. Product
Microsoft Access MCQS
Microsoft Access MCQS Microsoft Access 2007, Microsoft Access 2009 MCQS, Microsoft Access 2013 MCQS Microsoft Access 2016 MCQS, Microsoft Access 2017 MCQS. All MS Access MCQS, MS Access Design, MS Access Page layout MCQS, MS Access Best MCQS, MS Access Online MCQS MS Access Pages, MS Access toolbar mcqs, MS Access Queries MCQS, MS Access RDBMS MCQS, MS Access Database. best of Microsoft Access mcqs for FPSC exams preparation BPSC exams preparation PPSC exams preparation SPSC exams preparation KPPSC exams preparation NTS tests preparation OTS tests preparation CTS tests preparation PTS tests preparation BTS tests preparation CTSP tests preparation
A query that uses information from two or more tables to get the results is called a(n)
A. Informal query.
B. Optional query.
C. Complex query.
D. Multitable query.
In a query when you have multiple conditions and each of them must satisfy to return the result, use
A. AND
B. OR
C. NOT
D. XOR
A(n) _____ is an association that is created in a query between a field in one table or query and a field of the same data type in another table or query.
A. Join
B. Link
C. Connector
D. Identifier
You can enclose the prompt within square braces in criteria to create
A. Parameter query
B. Select query
C. Action query
D. Crosstab query
Microsoft Access uses Jet Query Engine which uses
A. MS SQL Server
B. Full fledged SQL
C. Dialect of SQL
D. None of abovFull-fledged
Which statement does not hold true?
A. A relationship establishes the association between common fields in two tables.
B. An AutoNumber field can be related to a field of either type AutoNumber or type Text.
C. Joins specify that each pair of rows that satisfy the join conditions will be combined in the results to form a single row.
D. Access will automatically create a join only if the field names in both tables are the same.
If you write “Like Wa*” in criteria cell of FirstName field it will display
A. All the names that are like Su such as Bunu, Kunal, Purna
B. All the names that begin with Su such as Wahab, Wajid, Waris
C. Blank recordset
D. Error message
When you need to restrict the records that meets certain conditions, you can mention them in
A. Filter cell
B. Sort cell
C. Show cell
D. Criteria cell
Which of the following SQL query deletes Product table from Store database?
A. DEL Product FROM Store
B. DROP Product
C. DROP TABLE Product
D. Any of B or C