Best MCQs MS Access Intermediate CS Part-II (5)

The post is about MCQs MS Access Intermediate CS from part II. There are 20 multiple-choice questions related to query, report, forms, database, tables, find and research, search criteria, etc. Let us start with MCQs MS Access Intermediate CS Part II Quiz.

Online MCQs about Intermediate Computer Science Part II

1. The data in the table is entered in

 
 
 
 

2. To find a four-character name that starts with H, the criteria are specified as follows:

 
 
 
 

3. The wildcard ———- Sal[ei]ma.

 
 
 
 

4. Which of the following buttons of the find and replace dialog box is clicked to start the search process?

 
 
 
 

5. In a relational database, a table is called

 
 
 
 

6. Which object is the output of a database application?

 
 
 
 

7. The graphical query tool is known as

 
 
 
 

8. How many table views are available with Microsoft Access?

 
 
 
 

9. In a relational database, a single place of information is called

 
 
 
 

10. As in the design view, you can move from field to field in the table window in the datasheet view using the ————— button.

 
 
 
 

11. The rule that a record from a table cannot be deleted if it’s associated record exists in a related table is called the ———- rule.

 
 
 
 

12. Which object is used to store data in a database?

 
 
 
 

13. A database consists of various components called

 
 
 
 

14. The relationship between countries and their capitals is an example of ———— relationships.

 
 
 
 

15. Which of the following is not a database object?

 
 
 
 

16. A set of related files created and managed by a DBMS is called

 
 
 
 

17. An example of a popular DBMS is

 
 
 
 

18. The output of the query is in the form of

 
 
 
 

19. It makes it very simple to create a database

 
 
 
 

20. MS Access saves the database with the extension

 
 
 
 

MCQs MS Access Intermediate CS Part II Quiz

MCQs MS Access Intermediate CS With Answers
  • It makes it very simple to create a database
  • MS Access saves the database with the extension
  • In a relational database, a table is called
  • A set of related files created and managed by a DBMS is called
  • Which object is the output of a database application?
  • A database consists of various components called
  • Which object is used to store data in a database?
  • The output of the query is in the form of
  • Which of the following is not a database object?
  • An example of a popular DBMS is
  • The graphical query tool is known as
  • In a relational database, a single place of information is called
  • The data in the table is entered in
  • How many table views are available with Microsoft Access?
  • As in the design view, you can move from field to field in the table window in the datasheet view using the ————— button.
  • To find a four-character name that starts with H, the criteria are specified as follows:
  • Which of the following buttons of the find and replace dialog box is clicked to start the search process?
  • The rule that a record from a table cannot be deleted if it’s associated record exists in a related table is called the ———- rule.
  • The relationship between countries and their capitals is an example of ———— relationships.
  • The wildcard ———- Sal[ei]ma.

https://itfeature.com, https://rfaqs.com

Best MCQs Computer Science Class 12 (4)

The post is about MCQs Computer Science Class 12. There are 20 multiple-choice questions on MS Access, Database, Query, Relationship between entities, primary key, secondary key, and ERO Model. Let us start with the MCQs Computer Science Class 12 Quiz.

Please go to Best MCQs Computer Science Class 12 (4) to view the test

MCQs Computer Science Class 12

MCQs Computer Science Class 12 Quiz with Answers
  • Which one of the following is used to associate entities with each other?
  • An entity related to itself in an ERO model refers to the relationship
  • A relationship between countries and capitals is an example of the relationship
  • Which of the following defines the nature of the relationship?
  • Which of the following is not a basic data distribution strategy?
  • In 3NF, which form of dependency is removed?
  • In a relational database, a table is also called a
  • Different attributes in two different tables having the same name are referred to as
  • Every relation must have a
  • Transitive dependency is removed in
  • Two or more attributes having different names but the same meaning are called
  • Referential integrity is applied on
  • A primary key that consists of two or more attributes of a relation is called
  • Microsoft Access saves the database with the extension
  • A database consists of various components called the
  • Which of the following objects of the database is used to retrieve data from the database?
  • The output of a query is in the form of a
  • Which object is used to retrieve data from the database and present it in a formatted way?
  • In access, the structure of a table is created in ———– view.
  • Which shortcut key is used to open an existing database in MS Access?
gmstat.com MCQs Computer Science class 12 quiz with answers

https://rfaqs.com, https://itfeature.com

MCQs Computer Science Intermediate Part-II (3)

The post is about MCQs Computer Science Intermediate Part-II. The quiz covers topics related to MS-Access database, ERD model, relationship between entities, foreign key, primary key, and secondary key. Let us start with MCQs Computer Science Intermediate Quiz.

Please go to MCQs Computer Science Intermediate Part-II (3) to view the test

MCQs Computer Science Intermediate Quiz

MCQs computer Science Quiz with Answers
  • Which of the following is not included in the definition of entity?
  • Which of the following is used to associate entities with one another?
  • In MS Access, the table contains
  • Views are also called:
  • A virtual table that is constructed from other tables is called
  • A key that consists of more than one attribute is called
  • The selected candidate key is called
  • ————- key does not hold uniqueness property.
  • A table must have a
  • Foreign key is found in
  • How many primary keys can a relationship have?
  • All the hardware costs are considered during
  • In an E-R diagram, a rectangle represents a(n)
  • ———– is used to define the characteristics of an entity/ object.
  • To find all names starting with M from the student table, the criteria is
  • In an E-R, a diagram represents a(n)
  • In the ERD model, the relationships between two entities are represented by
  • Customers, cars, and parts are examples of
  • Which one is not related to an entity?
  • The color of the car is an example of
gmstat.com Test Preparation Website CS & IT Quiz

https://rfaqs.com, https://gmstat.com