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. As in the design view, you can move from field to field in the table window in the datasheet view using the ————— button.

 
 
 
 

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

 
 
 
 

3. The graphical query tool is known as

 
 
 
 

4. MS Access saves the database with the extension

 
 
 
 

5. In a relational database, a table is called

 
 
 
 

6. It makes it very simple to create a database

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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. A set of related files created and managed by a DBMS is called

 
 
 
 

13. An example of a popular DBMS is

 
 
 
 

14. A database consists of various components called

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

19. The data in the table is entered in

 
 
 
 

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

 
 
 
 

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

Important 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 Important 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

2nd Year Computer Quiz 2

The subject of Computers is the main subject in ICS exams. This MCQ-type test is about the 2nd year computer quiz that covers topics related to information technology, Programming languages, and basic concepts about computer sciences. The test is designed for students and teachers to practice online on the website and prepare for the intermediate computer science exams. There are 20 MCQs in each 2nd Year Computer Quiz from Intermediate Part II.

Please go to 2nd Year Computer Quiz 2 to view the test

2nd Year Computer Quiz with Answers

  • Which of the following database models is also referred to as an inverted tree?
  • Which one refers to the correctness and consistency of data?
  • Multiple copies of the same data are referred to as:
  • SQL stands for
  • Insert command is used to insert:
  • Create command is used to create a:
  • SQL is used for:
  • The foreign key is found in:
  • A table must have:
  • An entity related to itself in an ERD model refers to
  • Which of the following keys does not hold uniqueness property?
  • Database development process involves mapping of conceptual data model into:
  • In relational database, a table is also called a
  • A category of data or information that describes an entity is called a(n):
  • The row of relation can be of ———- order.
  • A relation is analogies to a:
  • Which of the following is the degree of a table?
  • The row of the table is also called:
  • A relation is also known as:
  • The columns of a table correspond to:
2nd Year Computer Quiz

The subject of Computer science deals with the theory and methods of processing information, the design of computer hardware and software, and the application of the computer in industry, science, business, social sciences, and arts. Computer Science is the study of hardware, software, computation, and computer technology. CS courses are being taught in colleges and universities. Students of Arts can also select this subject

Operators in R Language

Statistics and Data Analytics