MS Access and Database

Total Questions: 32

1 - A set of possible data values is called -------:

A ) Attribute
B ) Domain ✅
C ) Tuple
D ) Degree

4 - -------- is a unit of information in a ----:

A ) Field, Record ✅
B ) Record, Field
C ) Field, Database
D ) None of these

5 - Which object is the output of the database application?

A ) Form
B ) Query
C ) Table
D ) Report ✅

6 - A collection of interrelated files in a computer is a------:

A ) Field
B ) Database ✅
C ) File manager
D ) None of these

7 - Collection of related tables is called----:

A ) Record
B ) Field
C ) Database ✅
D ) Cell

8 - Data that changes continuously and cannot have discrete values is called-----:

A ) Analogue data
B ) Continuous Data
C ) Both A and B ✅
D ) None of these

9 - Which of the following is a database management system?

A ) Dos
B ) Oracle ✅
C ) Window
D ) None of these

10 - How can we get data from user?

A ) Pages
B ) Form ✅
C ) Report
D ) Query

11 - When creating a new table which method can be used to choose fields from standard database and tables?

A ) Create table using wizard ✅
B ) Create table by entering data
C ) Create table in design view
D ) None of these

12 - In data base each row is called?

A ) Table
B ) Field
C ) Factor
D ) Record ✅

13 - The structure or format of data is called:

A ) Semantics
B ) Struct
C ) Syntax ✅
D ) None of these

14 - Primary key is -------

A ) Cannot be repeated
B ) Uniquely identifies each record
C ) Auto number is example of primary key
D ) All of these ✅

15 - Which of the following does not belong to queues for processes?

A ) Device queue
B ) Ready queue
C ) PCB queue ✅
D ) Job queue

16 - Which of the following is not a valid data type in MS Access?

A ) Numeric
B ) Text
C ) Picture ✅
D ) Time

17 - SQL stands for ------:

A ) Structure Query language ✅
B ) Software quality language
C ) Syntax Query language
D ) System query language

18 - Which type of table constraint will prevent the entry of duplicate rows?

A ) Unique ✅
B ) Foreign key
C ) Check
D ) Primary key

19 - Functional dependencies are the type of constraints that are based on:

A ) Key revisited
B ) Key ✅
C ) Superset key
D ) None of these

20 - After creating the table which of the following is correct------:

A ) Fields cannot be deleted
B ) Fields cannot be added
C ) Fields can be added but only once
D ) None of these (Fields can be added and deleted as needed) ✅

21 - MS Access is used for ------:

A ) Data table ✅
B ) Tool development
C ) Create web page
D ) None of these

26 - What is the best way to store electronic record backups?

A ) Paper-based backup
B ) Hashing
C ) To duplicate the data ✅
D ) None of these

27 - How can you ensure the security of electronic data in databases?

A ) Using graphic design
B ) Regularly updating software
C ) Implementing encryption ✅
D ) Increasing database size

28 - In MS Access to create a new table, in which method you don't need to specify the field type and size?

A ) Create Table using wizard
B ) Create Table by Entering data ✅
C ) Create table in design view
D ) All of these things

30 - Which function is used to find the string length in "PPSC" and gives the answer as"4"

A ) Length ("PPSC ")
B ) Len ("PPSC") ✅
C ) Steel (PPSC)
D ) None of these

31 - The first phase of the systems development life cycle is -------:

A ) Systems analysis ✅
B ) Systems design
C ) Systems maintenance
D ) Systems investigation

32 - What Cascade Delete option is used for?

A ) It repeats the recent delete operation to all the records of the current table
B ) It ensures that all the related records will be deleted automatically when the record from the parent table is deleted. ✅
C ) It is used to delete all the records of all tables in a database
D ) None of these