BIS Quiz sample - AFAFAFAFA PDF

Preview

Summary

AFAFAFAFA...

Description

Open database FM-REVISION-DB-Ver1 and answer Questions 1 to 10

Question 1: What type of query is “Employee Sales Query”? (a) Simple Query  double click, and it will straight away shows you (b) Calculated field Query  find it in the design view (there should be a calculation like total cost on one of the fields) (c) Dates between Query  find it in the design view (between this date to another date) (d) Dynamic Query  if it opens a parameter (ask for inputs) open brackets and close brackets

Question 2: Which statement about “Employee Sales Details Query” is FALSE. (a) This query has two criteria. (b) Displays male staff whose designation is “Sales Rep” (c) All selected fields are displayed  there is no tick on the show button, hence the data will not show up (d) None of the above

Question 3: Which one of the following statements about the database is FALSE. (a) In the sales-details table “Sales-ID” and “Prod-ID” are both foreign keys.  open up database tools and under the relationship diagram, look at sales-details (b) The relationship between Product-list and Sales-details tables is “one-to-many”  relationship shown in the table (c) The relationship between Sales and Staff tables is “many-to-one” (d) SALES-ID is the primary key in the sales-details table  it links between the Sales-Details table and Sales table

Question 4: Which field in the sales table occupies the least space?  talking about the yes/no field (stored as 0 & 1) (a) SALES-ID (b) PAYMENT-TYPE (c) MEMBERSHIP (d) INVOICE-AMT

Question 5: In this database the relationship between the sales table and the staff table is (a) One sales to many staff a. Many sales to one staff  can be seen in the diagram b. Many sales to many staff c. One sales to one staff

Question 6: In the staff table, what is an appropriate mask for the NRIC-NUMBER field. (a) L9999999L (b) L0000000L (c) L9999999? (d) A9999999L

Question 7: Which of the below statements about the database is FALSE. (a) Table sales-details has five attributes (b) Attribute IN-STOCK in table PRODUCT-LIST has a data type NUMBER. (c) In the sales-details table “Sales-ID” and “Prod-ID” are both foreign keys. (d) There are five entities in this database  there is only four entities (tables) Question 8: Which field in the sales table, is most appropriate for a dropdown list validation? (frequently appearing) (a) STAFF-ID  no point putting drop down for foreign key (b) MEMBERSHIP (c) PAYMENT-TYPE (d) SALES-DATE  every day, the date will change hence no need to put dropdown list Question 9: Employee sales detail report is a .. (a) Simple report (b) Simple group-by report  grouped by the same person (c) Report based of a query  did they use a query or table to create the report? Not these as based on first query, it only has 4 fields, second query (parameters). (d) Report with a calculated field  no formulas inside the report and it is coming directly from the table

Question 10: Which statement about the Employee Sales form is false (a) The form makes use of three entities  only 2 entities (sales and sales-details) (b) It is a form with a sub-form  have sales and sales details (2 tables involve and the relationship will be one-to-many) (c) It allows you to enter the sales and the sales details in one for (d) You can navigate through the sales details records using this for  there are 2 navigation sets on the form Question 11: Prof. Francis Mahendran’s class has the most number of students with “HD” for 2017. The above statement is a result of: (a) Predictive Analytics  start forecasting (sales for 4 th quarter?), predicting on the future based on past data (b) Descriptive Analytics  related to average, mean, median, mode, describe a set of data (c) Prescriptive Analytics  (d) None of the above

Question 12: Colin uses PMT function to determine the monthly instalment for Hammer Wines expansion loan. Colin is using: (a) Predictive Analytics (b) Descriptive Analytics (c) Prescriptive Analytics  have the formula (input-process-output) (d) None of the above

Open Excel file FM-REVISION-EXCEL-Ver1 and answer Questions 1 to 10 Question 13: Column M: Compute the One-Time SG50 Bonus. If Years of Experience is more than 10 years and Basic Salary is less than $3000 and Sales Region is Bedok, then One-Time SG50 Bonus = $1,000 Else If Years of Experience is more than 10 years and Basic Salary is less than $3000 and Sales Region is other region, then One-Time SG50 Bonus = $500, Else One-Time SG50 Bonus = 0 Which is the formula used in cell M4: (a) (b) (c) (d)

=IF(AND(D4>10,J410,J410,J4...