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?
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 ()
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://saglamproxy.com
ReplyDeletemetin2 proxy
proxy satın al
knight online proxy
mobil proxy satın al
6PEBO