[ NOC ] Database Management System ( MS - Access ) [ Nepal Oil Corporation 4th level ] नेपाल आयल निगम लिमिटेड सहायक ( कम्प्यूटर )

Anil Pandit
0
FOR NOTE PDF - Visit End of the page


1. What is the definition of data?






2. Which of the following is an example of unstructured data?






3. What type of data does a relational database store?






4. Which type of database is best suited for storing complex data models that include documents and multimedia?






5. Which of the following is NOT a characteristic of a database?






6. Which of the following is an example of a relational database?






7. What is the role of a DBMS?






8. Which of the following is NOT a function of a DBMS?






9. What is a disadvantage of using a DBMS?






10. Which of the following types of databases organizes data in a tree-like structure?






11. Which of the following is a feature provided by a DBMS to prevent data conflicts when multiple users access the database simultaneously?






12. Which of the following is an advantage of using a DBMS?






13. What is the main purpose of data in an organization?






14. Which of the following is an example of semi-structured data?






15. Which DBMS function ensures that only authorized users can access and modify the data?






16. Which of the following is an example of an object-oriented database?






17. What is the relationship between data, database, and DBMS?






18. Which of the following DBMS ensures scalability by distributing data across different locations?






19. What is the key advantage of using structured data in databases?






20. What is an important characteristic of unstructured data?






21. What is the role of a table in MS Access?






22. In a table, each row represents a _____.






23. Which of the following is NOT a field data type in MS Access?






24. What does a primary key in a table do?






25. Which of the following is NOT a feature of a form in MS Access?







26. Which of the following types of forms in MS Access is directly linked to a table or query?






27. Which of the following is a benefit of using forms in MS Access?






28. Which MS Access view allows users to design and customize the layout of a form?






29. A Select Query in MS Access is used to _____.






30. Which type of query asks the user for input every time it is run?






31. What does a Crosstab Query in MS Access do?






32. Which of the following SQL queries will retrieve customers who registered after August 1, 2023?






33. Which of the following is a benefit of using queries in MS Access?






34. Which query type would you use to modify existing data in a table?






35. Which tool in MS Access allows you to summarize data using functions like SUM and AVG?






36. What is the main relationship between tables, forms, and queries in MS Access?






37. What is the maximum number of characters that can be stored in a "Short Text" field in MS Access?






38. Which data type in MS Access is used for storing large amounts of text, such as paragraphs or descriptions?






39. Which of the following is not a field size option for the "Number" data type in MS Access?






40. What is the field size of the "Currency" data type in MS Access?






41. Which data type in MS Access is most appropriate for storing Boolean values such as True/False or Yes/No?






42. What is the maximum storage size for an OLE Object field in MS Access?






43. Which data type should be used in MS Access to store a unique, automatically generated number for each record, often used as a primary key?






44. What is the maximum number of characters that can be stored in a "Hyperlink" field in MS Access?






45. In MS Access, which data type would you use if you wanted to store a file attachment, such as a document or image, in a record?






46. The "Lookup Wizard" in MS Access is primarily used for:






47. Which MS Access data type should be used for monetary values to avoid rounding errors in calculations?






48. What is the largest integer that can be stored using the "Large Number" (BigInt) data type in MS Access?






49. In MS Access, which of the following is not a valid size for the "Number" data type?






50. Which data type allows you to create a field where the value is calculated automatically based on other fields in the same table?






51. What is the purpose of the "Date/Time" data type in MS Access?






52. What kind of values can be stored in a "Memo" data type in MS Access?






53. What is the main limitation of using the "Short Text" data type in MS Access?






54. Which data type would you use for storing large amounts of text that may exceed 255 characters?






55. Which function can be used to calculate the average of a set of numbers in a query in MS Access?






56. In MS Access, which of the following is a valid way to create a new query?






57. What is the purpose of the "Criteria" row in a query in MS Access?






58. In MS Access, what does the "Sort" option do in a query?






59. In MS Access, how can you create a relationship between two tables?






60. Which of the following is NOT a type of relationship that can be established in MS Access?






61. How can you create a form using the Form Wizard?






62. In Form Design View, which control is used for entering text?






63. How can you modify a control in a form?






64. Which method allows you to generate a report automatically based on a selected table or query?






65. What is the purpose of the Report Wizard in MS Access?






66. To delete a form in Access, which steps must be followed?






67. When modifying reports, how can you add a text box?






WhatsApp Group Join

कुनै Answer गलत भएमा Comment गर्नु होला 

Note

Post a Comment

0Comments

Post a Comment (0)