NTS PAPERS PREPARATION FOR PUNJAB FOOD AUTHORITY JOB 2019

NTS PAST PAPERS MCQs
NTS PAPERS PREPARATION FOR PUNJAB FOOD AUTHORITY JOB 2019
PUNJAB FOOD AUTHORITY PAPERS PREPARATION

GENERAL KNOWLEDGE

Computer Science Test:

1.       Which of the Keys does not hold uniqueness property?

ANS: Foreign Key

Database development process involve mapping of conceptual data model into?

ANS: Implementation Model

2.       An Entity related to itself in an ERD model refers to?

ANS: Recursive relationship

3.       In ERD model, the relationship between two entities is represented by a?

ANS: Diamond symbol

4.       In hybrid distribution which kind of fragments are stored at only one site?

ANS: Non-critical fragments

5.       Customers, cars and parts are examples?

ANS: Entities

6.       In an E-R diagram, a rectangle represents a?

ANS: Entity

7.       A Person’s name, birthday and social security number are examples of?

ANS: Attributes

8.       A technique for physically arranging the records of a file on secondary storage devices is called?

ANS: File Organization

9.       A Factor to consider when choosing a file Organization is?

ANS: Fast data retrieval, Security, Efficient storage

10.   A Primary key that consists of more than one attribute is called a?

ANS: Composite Key

11.   An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a?

ANS: Foreign Key

12.   Which field listed below is the most appropriate primary key?

ANS: A person’s Social Security Number

13.   An attribute (Or attributes) that uniquely identifies each row in a relation is called?

ANS: Primary key

14.   Organizing the database in computer disk storage is done in?

ANS: Physical design

15.   In 3NF which form of dependency is removed?

ANS: Transitive

nts paper preparation

16.   The goal of normalization is to?

ANS: Get simple and stable data structure

17.   The attribute on the left-hand side of the arrow in a functional dependency is?

ANS: Determinant

18.   A rule that states that each foreign key value must match a primary key value in the other relation is called?

ANS: Referential Integrity constraint

19.   Different attributes in two different tables having same name referred to as?

ANS: Homonym

20.   The Goal of Normalization is to?

ANS: Gen simple and stable data structure

21.   A relation is in third normal form if it is in second normal form and?

ANS: Has no transitive dependencies

22.   A functional dependency between two or more non-key attributes is called?

ANS: Transitive dependency

23.   Microsoft access saves the database with the extension?

ANS: MDB

24.   A collection of data that consists of name, address and email of a person is called?

ANS: Record

25.   Which of the following view in MS-Access is used to define the structure of table?

ANS: Design view

26.   How many table views are available in Microsoft Access?

ANS: Two

27.   Which of the following is NOT suitable for an input mask?

ANS: Street address

28.   What command is required to actually execute a filter on a table?

ANS: Apply Filter

29.   Find and Replace Command is found in?

ANS: Edit Menu

30.   Which format property displays test in uppercase?

ANS: Greater than sign

31.   Which field type can by indexed?

ANS: Number

32.   Why are validation rules used in a database?

ANS: To make sure there is no incorrect data entered & to avoid typographical errors

33.   A Program whose job is to store and retrieve user data in the database is called?

ANS: Database Management System

34.   The description of structure and organization of data in a database is contained in?

ANS: Data Dictionary

35.   Information including a table’s name, field names and data types is stored in?

ANS: Data Dictionary

36.   A request for information from a database in database terminology is called?

ANS: Query

37.   A printed or onscreen display of data or information in the database is called a?

ANS: Report

38.   The name for software to build reports that summarize data form 3 database is?

ANS: Report Generator

39.   A collection of data that includes name address, phone number etc. of a person is?

ANS: Record

40.   SQL is used for?

ANS: Data definition and manipulation

41.   Create command is used to create?

ANS: Table

42.   The foreign key is found in?

ANS: Dependent table

43.   A two-dimensional table of data is called a?

ANS: Relation

44.   Insert Command is used to insert?

ANS: New Record

45.   A Collection of Raw facts and figure is called?

ANS: Data

46.   The processed data is called?

ANS: Information

nts papers preparation

47.   Which of the following is an example of a database?

ANS: Phone Book, Library catalog and Student records

48.   Which of the following data model is more flexible?

ANS: Indexed Sequential File

49.   SQL is a?

ANS: Structured Language

50.   Which of the following may be a temporary file?

ANS: Transaction File

51.   The Type of files from usage point of view include?

ANS: Master file, Transaction file and Backup file

52.   A database in an organized collection of ______ related data?

ANS: Logically

53.   The most commonly used database model in current database development is?

ANS: Relational

54.   Which of the following data model has general shape of an organization chart?

ANS: Hierarchical Data Model?

55.   Texts are entered in?

ANS: Cells

56.   Shortcuts for select entire worksheet is?

ANS: Ctrl + A

57.   Shortcut Key for format Cell is?

ANS: Ctrl + 1

58.   To move to the next worksheet in a workbook press?

ANS: Ctrl + page down

59.   To Move to the previous worksheet in a workbook press

ANS: Ctrl + page up

60.   Web Page option exist in?

ANS: File Manu

61.   The function that is used to get date and time simultaneously?

ANS: Now ()

62.   To move to the next worksheet in a workbook press?

ANS: Ctrl + Page down

63.   To combine two or more cells into one is called?

ANS: Merge

64.   The Function that is used to count the number of entries in the given range is Called?

ANS: Count

65.   Shortcut key to open old workbook is?

ANS: Ctrl + F6

66.   A Computer can be linked to the Internet through?

ANS: DSL, A Phone Line Modem, Cable Modem

67.   Which of the following is used to find information on World Wide Web?

ANS: Search Engine

68.   The length of IP Address is?

ANS: 32 Bits

69.   The four numbers in an IP Address are called?

ANS: Octets

70.   Junk mail is called?

ANS: Spam

71.   Text are entered in?

ANS: Cells

72.   Which is an Email client?

ASN: Outlook Express

73.   Which of the protocol is used to access Web Pages on World Wide Web?

ANS: HTTP

My Steemit Blog Link

https://steemit.com/@sidhar

SHARE

Milan Tomic

Hi. I’m Designer of Blog Magic. I’m CEO/Founder of ThemeXpose. I’m Creative Art Director, Web Designer, UI/UX Designer, Interaction Designer, Industrial Designer, Web Developer, Business Enthusiast, StartUp Enthusiast, Speaker, Writer and Photographer. Inspired to make things looks better.

• 
• 
• 
• 
•