DBMS Software (MS-Access) MCQs > FREE SET - 1

	1. The relationship database consists of a collection of -
	A Keys B Fields C Records D Tables Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	2. In table design view, which key can be used to switch between the filed names and properties panels in MS Access?
	A F1 B F6 C F12 D F10 Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	3. A Data Base Administrator (D
	A is a __________.\x0d\x0aA) Program B Person C Application D Operating System Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	4. In MS Access the __________ name must be unique within a database.
	A Field B Record C Character D Table Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	5. A __________ consists of a collection of interrelated data and a collection of programs to access that data.
	A Database B Schema C DBMS D DBA Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	6. Which of the following is most popular commercial DBMS?
	A Microsoft SOL Server B Microsoft Access C MySQL D Oracle Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	7. Which of the following is an invalid type of database key?
	A Atomic primary key B Structured primary key C Primary key D Composite primary key Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	8. Database redesign is not terribly difficult if the
	A Database is structured B Database is well-designed C Database is relatively small D Database has no data Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	9. In MS-Access, a table can have primary Key/keys.
	A One B Two C Three D Four Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	10. What are different views to display a table in MS Access?
	A Pivot Table & Pivot Chart View B Design View C Datasheet View D All of the above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	11. Inheritance is the ability of an object to pass on its characteristics to its ____________.
	A Sub Classes B Off Spring C Super Classes D Parents Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	12. What key links records from one database table to a record or records in another database table?
	A Primary key B Principal Key C Foreign key D Link key Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	13. Which of the following is a subset of a data warehouse?
	A Relational database B OLAP C Intelligent Agent D Data mart Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

---