puu (p)
1313n.irtp (o) olicu (q) :st aapultuoa aqj uri uogutumu laptiojA (3) (q)
0
(E) Jo Bun oatrixis anL
aalupd (e) andjno Adoapirq 0) pasn sr aa!Aap liu!Attolloj atn jo qapiA NioAwN (p) pallor:13v (3) lanuaD (q) (c :s! saalAap 3U•103S Astupuoaas pug ‘indlno lindu! ol Ssiapi pin 1011.133 4tu 031Aau (p) ammuos aauland (3) ammuos waisAs (q) °Jumps wolsrn (t :pawn sr asn umo s,Surdtuoa alp ioi Allraupads padoiaAap asemuoi
•
(P)
auou (p) 89L*17ZOT (p) VOA (p) (P)
Amenb aim* (p)
17 (3) Z (q) (E eavcci auo tel! slvl Aueui MOI Cu JO say( (3) 0.10Z Jo auo (q) illo uo (E :s! 41q e Jo amen pip jo 2upieatu ay xplew TOG (D) larAut (q), Jasei (t valupd Jalsej st 2uyinonol 044 Lip!tsjil 009408 (3) 00V*0179 OSt*Ot79 (E Uogniosa) VDA
VOX (3)
VS3A (c1) OVD
:sr Aeicisw spRideiLiolo3 Jo' uonniosai 150/1/101 34 E (3) (q) n (E
aavetta asenene am slue, s3Ndei2 #o sadAT Aueui pm)! Ailsuaa (3) uonniosau (q) laxid (E
UODelDS 4D110113)
s a)! ianuop lossinD (p) sAal 10
apedspes (p)
poN )
alataa
• L, II It fr, 01%
na%", amens •21,41„,„,..,
(q) moRsAof (E :sr apptap 2unupd e Jo aidillexa ul sAal mopum (q) sikal aig2o1 (E :papa sAaN iiA0JJ old (q) DS
ZIOS-11113 04110 llai aten. ol Japentp atp. sanou.9.1 AaN tippv UnilidS (0 4.4 , 8311tINU (3) NeJoAci (q) A183NCO (E :ayi sg pasn ANOLLIWOD Isms' s! leyneunol pieociAan alsi
uonenua2 elea (p) a2eiols (3) lnchnoirdui (q) Oti!ssapaid (t :papa we tila4si aye Aq pawnua2 uonewialut 2unuasaid pue JaIndatoa elep 2upalua tio siftem a4 u2!saci (p) cpge tilog (3)
asiemlios (p)
walsAs (q) uopeDgeldv (i :5! ammljos jo A.102a4B3 Jorew 2uileinDIED (3) swawr000 (q) -aelempie :panel aie Jelndwo3 aye una imp uopprulsul du::c ALI Jal Inchno (3) swm piciu! (q) a2esiolsr,tuptioDas :u! paons aie Ad) Aq pasn 2upq lou swealaid pue eiep ietrionwp auoN (p) aleivepleH (3) weawd (q) o_ievs%Allos (t
auoN (p)
21.1!SS 3041d (3)
:Jo aiduiexa ue si nd uoRewemittl (ti) eleG
:pane) sr ain2u pue sy el mei jo uonDailop •uogsanb Lir )peh, tri! Ilyvx sapeip WOW JO MAI nUnnj ao Zumnp •sapsip Diu ou uad Javew asn :a4oN ar:C
•
VON Jaide43
Chapter 2 Computer
1. The row of relation can be of order. (LUR-17)
(A) Any (B) Same (C) Sorted (D) Conse
2. The row of table is also called: (AJK-16)
(A) Entity (B) Attributes "(C) Cell (D) Re-ord
5. Which of the following keys, does not hold uniqueness property? (SGD-21)
(A) Foreign (B) Candidate " -(C) Primary (D) Secondary
_ 7. Which of the foliowing can be a primary key? (RWP-22). (LHR-19)
(A) Last name (B) Salary - * (C) Customer iD (D) Region
6. Which of the following keys possesses the uniqueness property? (SGD-22)
; (A) Foreign key (B) Secondary Key (C) Sort Key ; (D) Composite Key
8. Who is responsible ta design, implement and maintain a databases? (MTN-21)
(A) Database administrator (B) End users
, (C) Application programmer (D) Web designer
3. Which object is used to define the structure and stores the data? (ASK-16)
(A) Query (B) Form - (C)Macro — (D) tabie
4. A relation is aiso known as: (FBD-21)
(A) Table (B) Tuple - (C) Entity (D) Attribute
.9. Atable is a two dimensional structure that consist of: (MTN-18)
(A) X and Y coordinates: ~ _ (B) Matrix elements .
, (C) Row and column | -, (D) Intersection of data
- 10. Arelation is analogous to a: . . (BW 'P-17)
. (A) Table (B)Field (C) Record (D) Row
_ 11; An Attribute is also known as: . (RWP-21)
" ° (A) Relation _. . (B) Row (C) Field . (D) Tuple
- $2. Walch is used to indicate characteristics of an object? (FBD-17)
- (A) Relationship (B) Cardinality - (C) Modality (D) Attribute 7
13.. A Table must have a: ‘ Oe (DGK.21)
| . , (A) Primary key . (B) Secondary key. (C) Composite kev . (D) Sort key .
14. Which of the following fs also known as‘control key? , (SGD-19)
* (A) Foreign key (B) Composite key. (C) Primary key (D) Sort key ; upd
48. Foreign key isfoundin: = oy ONE Gee
" ._(A)Parent Table (B) Dependent Table___(C) Pivot Table (D) Index Table —
\////////////////////////\\\\\\\\\\\\\\\\\\\\/////////
1. The columns of a table correspond (o: - NF U7,
(A) Table (B) Records field (1) Cell
2. The category of data that describes an entity is called: (RWP-16)
KAY Attribute (B) Data items (C) Record (D) Tuple
3. The data or information that describes an entity is called: (DGK-18)
| Attribute (B) Record (C) Tuple (D) Data Item
4 ‘Teacher, students and cars are example of: (GUJ-16)
(A) Relationship Entities
: (C) Attributes (D) Identifiers
5. Which of the following is not included in the definition of entity? (LHR-14)
: (A) Person — (B) Object Concept (D) Action
6. The selected candidate key is called: (MTN- 16)
(A) Foreign (B) Composite key Primary key (D) Super key
-7. In admission table, Student Roll no. is used as a (FBD-22)
(A) Sort Key (B) Foreign key Primary key — (D) Secondary key
8. An index may be created on: (FBD-15)
(A) Secondary key : Primary key
vg, GiForcign key " (D) Allofthese =
iB? ane Uae AE On canarelationhave? = , (DGK-14)
10. A primary key that y On - - (C)No Limit (D) Three
(A) Sort key (B) Candidate vo or
more attributes of a relation is called: = (BWP-21)
Cee y | ey (C) Sub key Composite key
Chapter 3 Computer
1. In E-R diagram, a diamond represent a (n): (RWP. 19) ,
(A) Attributes (B) Relationship (C) Entity (1D) Modality Q:
2. In ERD model, the relationship between two entities is represented by a: (LHR-2y ro)
(A) Diamond Symbol (B) Rectangular box (C) Oval Symbol (1D) Line | (ii
3. Merging the relation is also known as: : . (RWP-18) Gi
(A) View integration (B) View entities (i
(C) View tables (D) View relations (Vv
4. Organizing the database in computer disk storage is done in: (GUJ-2]) (v
(A) Logical design (B) Analysis O
(C) Physical design (D) Conceptual design (s
5. All the hardware cost are considered during: : (SWL-19) (\
(A) Project planning. (B):Requirements analysis (i
' (C) Feasibility study — (D) Data analysis Cc
6. Which of the following is not included is the definition of entity? (SGD -16) (i
(A) Person (B) Object (C) Concept (D) Action (
| 7. The degree of relation refers to the numberof: (SWL-17) (
(A) Rows: oe (B) Tables .- = (C)Data (D) Columns c
8. The relationship between teacher and students is _ (FBD-22) (
(A) One to One —— .. (B) One to Many (
. (C) Many to Many . (D) Many to One (
_9. An entity related to itself in an ERD model refers to relationship: (SWL-22), (MTN-21) (
(A) Recursive (B) One to many
7 (C) Many to many . -. (D).One to one |
10. In an E-R Diagram, a rectangle represents a (n): (BWP-21-22) |
{A) Entity . (B) Attributes (C) Relationship . (D) Field
AL: is used to define / describe characteristics of.an entity / object. (GUJ-19)
(A) Objects ' (B) Attributes (C) Records (D) Files ,
’ 12. Which of the following is used to associate entities with one another? (LHR-18)
+. (A) Entity, . an (B) attribute |
~ ° * (C) Relation - | , (D) Relationship
| 43, A person's name, birthday and social security number are examples of: (MTN- 18)
(A) Attributes (B) Entities © =~ (C) Relationships (D) Descriptors
14, Which of the following is a one- to - many relations? (DGK-18)
> + ‘(A) Student- Reg No (B) Mother -daughter
: , (C) Person- Date of Birth (D) Country- Capital .
_ 4& Which of the following Is not a basic data distribution strategy? (DGK -14)
Be (A) Centralized (B) partitioned (C) Replicated (D) Duplicated
1. Customers, Cars are example of: — (LHR-21)
Entities (B) Attributes (C) Cardinals (D) Relationship
2. Color of car is an example of: , (AJK-16)
_ (A) Entity Attributes (C) Relation — (D) Relationship
4. Which of the following defines the nature of relationship? (GUJ-14)
+ Modality . (B) Decision tree os
(C) Attribute | | (D) None of the above
‘> Asset of related item in a table is called: 7 | (GUJ-15)
om SC s«(A*) Fille : Record — (C) Query - -(D) Report .
= Duplicate data in multiple data files is called: Se (DGK-18)
(CA) Data Integrity | . ,(B) Data Consistency . ,
Be | Program Dependency MD Data Redundancy . |
Chapter 4 Computer
1. Arelation that contains minimal redundancy and allows easy use called: (RWP-16)
(A) Clean (B) Simple (C) Complex (D) Weti- ste ..ctured
2. A row of relation is called: (FBD- 16)
(A) Attribute (B) Entity (C) Tuple (D) Relation
3. Data inconsistency is caused by: (AJK-16)
(A) Organized data (B) Integrated data
(C) Independent data (D) Redundant data
4. A primary key value cannot be null is what kind of integrity? (GUJ-21)
(A) Referential integrity (B) Entity integrity
(C) Data integrity (D) Security integrity
$. Referential integrity is applied on: (DGK-14)
(A) Foreign key (B) Composite key (C) Primary key (D) Sart key
6. In 3 NF (Third Normal Form), a non- key attribute must not depend on a: (GUJ, FBD-22)
(A) Non- key attributes (B) key attributes .
- (C) Composite key - (D) Sort key
7. Aconstraint between two attributes is called: {RWP-18)
(A) Functional Relation (B) Attribute Dependency
(C) Functional Dependency . (D) Relation Constraint
8. Transitive dependency is removed in: (AJK-16)
(A) 1* Normal Form (B) 2% Normal Form — (C) 3“ Normal Form (D) 4° Normal Form
9. The Goal of Normalization isto: so " (LHR-16)
_ (A) Increase (B) Increase Inconsistency Redundancy .
(C) Get Stable Y . (D) Increasing Anomalies Data Structure
10. Which one refers to the correctness and consistency of data? (GUJ-14)
(A) Data independence . - (B) Data integration
(C) Data integrity - -. . (D) Data made!
‘11. Why are Validation rules used in a database?. (BWP-14)
(A) Ensure correct data is entered (B) To avoid typing errors
(C) Both A and B (D) neither A or B
12. Mattipie copies of the same data is referred to as: (DGK-18)
(A) Data integrity - (B) Data inconsistency
. (C) Data redundancy _ * (D) Data isolation
13. Which of the following is. correct association? (SWL-19)
(A) File= column (B) Record = row ~ (C) Field= row (D) Record ~ table
54, Two or more attributes having different names but same meaning are called: (SGD-16)
(A) Homonyms . _ (B) Aliases
__ {C) Synonyms ~ — (D) Altemate Attributes
1%. ts 3NF, which form of dependency is removed? (FBD -21)
3. (A) Functional (B) Non- Functional (C) Associative (D) Transitive
4. Areferential integrity COR in
P | | (MEIN-21)
- (A) Columns of two tables Two columns of same table
" (C) Rows of two table (D) Attribute of two tables :
2. In relational database, a table is also called: (DGK, LHR-22), (SWL-18)
. (A) Tuple WEE Relation (C) File (D) Schema
3. Every relation must have key. | oo (LHR-19)
- (A) Candidate (B) Foreign Primary (D) AH of these
f° 4, When two different names are used for the same information or attribute creates a
ae roblem known as (SGD, BWP-22)
, i Synonym (B) Acronym ‘(C) Homonym (D) Antonym
& In 2NF, which form of dependency is removed? (RWP-22), (B WP-21)
gv (A) Functional Partial (C) Associative (D) Transitive
, Different Attributes in two different tables having same name are referred to as:
4 . . OO (SWL-22), (LHR-21)
- - (A)Synonym Homonym (C) Acronym (D) Mutually exclusive
/////////////////////////////////////////////////////////////////////////////////////////////////////
Chapter 5 Computer
1. The example of popular DBMS is: ; f
(A) MS- Word (B) MS- Access (C) MS-Excel (D}) MS- Power Pu
2. In MS-Access, table contains: AY
' (A) Field (B) Record (C) Character (D) File
3. Which of the following object of database is used to retrieve data from database?
(A) Queries - (B) Forms (C) Reports (D) Tables
4. Which object is the output of a database application?
(Se
5 (A) Form * (B) Query (C) Tables (D) Report
. The output of the query is in the form of: (RWP-22), (1
‘ “) Table = =———(B) Form (C) Report (D) Query .
(A) Report storm from a database in database terminology is called: (FE
€
7. SQL is used for: . (C) Table (D) Query
(a) Data definition (B) Data manipulati (GUI-22), (St
Data definition and manipulati pulation
& It makes very simple to create a datab _ _ €B) Data creation
(A) Sample database ase: . (G
9 (C) Common standard o wizar d :
. M i .
ay acess saves eae with the extension: “ster Programming (FB
10. Which of (C) .ppt BD-22), (M
(A) Table the rotowrg ney a database objects? Pp (D) .mdb
11. A database consis (C) Form (Li
(A) Topls (By prone components called: oun £oMS-Word
12, Which objects is used to store dat (C) Entities J, LHR, DGK-22), (LH
a (A) Macro (8) Table ata indatabase? © (D) Objects
. Which strategy is (C) Hybrid
ta (A) Panttiones” ™B) Deseret ata single site? " (D) Centralized (LH
* —__ is used to ret (C) Relat
1s A oiaero . BT from one or more tables. (D) Non- retated
(A) Table? Pe based on: (©) Query mM
able D MT
(B) Relationship (D) Form
UT AO Irae ee (C) Form (RH
Bean FETT EG (D) A .
Ray nribute
AEST
a write short answer to SECTION ~ | Mee YD
ine tw any SI ;
0 database objects. Xx (6) Questions;
. (12
////////////////////////////////////////////////////////////////////////////////////////////////
Chapter 6 Computer
Fe eR Ee em 4
1. The maximum number of tables in a database are: Rip, (
(A) 0! (B) 02 (C) 03 (D) Man (
2. The data in table is entered in: , (DGK 22), (N64; (
(A) Design view (B) Data sheet view (
(C) Normal view (D) Layout view (
3. What is the default field size of a text data-type in MS- Access. CASK yt
(Ay2 (B) 5 (C) 20 (D) 50 (
4. Create Command is used to insert: . (LHR, DGK-22), (SGN.44 (
(A) Table (B) View (C) Report (D) Query (
5. How many query views are available in MS- Access? (adk-p (
(A)2 (B) 3 (C)4 (D)5 (
6. Which wildcard replaces one character only? (ny (
(A)* (B)? (C): (D)! (
7. How many types of relationship? (
(A) 5 (B)4 (C)3 (D)2 : (
8. Which of the following is degree of a table? iS Lf
(A) Total number f rows (B), Total number of columns ]
(C) Total number of cells (D) Total number of foreign keys ‘
5. Which key is used to move jleld to field in table window in datasheet view? (SGD-I: *
(A) Tab (B) Esc (C) Enter ' (D) Spacebar
10. Every table must have a: : (BWP-22), (MTN-10 |
(A) Foreign key (B) Composite key (C) Primary key (D) Sort key
11. To find a name that start with S, the criteria is written as: (MTN-Ib
(A) S#? {B) S# (C) 9S (D) s* ‘
12. Which field type can be indexed? . (GUS-1
- (A) Memo (B) Number (C) Hypertink (D) DLE
13. Te find four character names that starts with H the criteria is specified as?
, (SGD, GUJ, RWP-22), (FBD-:
(A)H%a (B)H?4 (C)H272? (D) Ht
14. In a relational database, x single piece of infermation is called: (BWP-22), (M¥N-2)
(A) Field (B) Record (C) Entity (D) Attribute
1S. Each separate piece of information stored in a record is called: (DGK.I!
(A) Form (B) Field (C) Table (D) Relation ,
i el
6---2
. VU TAIL GE WF REP PRE ee YON Pe SPORE ae eee Ce Neh .
(A) Layout view — (B) Design view @ Datasheet view (D) Divot view ;
|. Which view is used to add, edit or delcte record from table: (GUJ-21)
(A) Record view Ms) Datasheet view (C) Design view (D) Edit view
|. A virtual table that is constructed from other tables is called: (RWP-19)
(A) Tuple (B) Table ; ia view (D) report
‘. table views are available in Microsoft Access? (B an | (SWL, FBD, LHR-22)
@r (B)2 (C)3 4
5, The maximum length of text type field in MS- Access is: (GUJ-18)
* (A)S0 characters (B) 250 characters (C) 155 characters MUD 255 characters
6. Which dats type can be used to define a field that consist of any numbers to be used in
calculations? (SGD-18)
~ (A) Text . Number (C) Memo (D) Data & Time
7, Which data type can be used to defined a field that contains data content such as chart, picture
or graphic object? ; (SWL-21)
(A) Hyperiink (B) memo BE OLE Object (D) Auto Number
& Which symbol indicates that you are editing a record? ‘ (LHR-1I6)
: (A) Pencil (B) Black arrow (C) Key Asterisk
. is used to retrieve data from one or more tables. (MTN-16)
. ® Macro (B) Table rc Query (D) Form
10, To find af) names start with M from student table, the criteria is: (LHR-18)
(A) Like "M?" (B) Like “"M-" (C) Like "M#" V1 Like "M *"
11. A request to get information from Database is called? (AJK-18)
tb mw oehlcalty Query (C) Table (D) View
ray que is KNOWN as: LHR-19
- A) Guey grid Ral Desien grid (C) Query form (D) View form ( 4
13. Which data type is default type in Access? (SWL-19)
mal } Memo (B) Number Text (D) Auto number
/////////////////////////////////////////////////////////////////////////////
Chapter 7 Computer
1. Which of the following is the building block of the GUI? Seen
(A) Form (B) Text boxes (C) Methods (P) Command FAR! 7
2. A form that contains a sub form is called: ‘ld f ( .
(A) Form (B) Main form (C) Report (D) Child orm
3. Which of the following is used to retrieve data form database and represent it to the user
in a formatted way? (BWP-22), (AJK-19)
(A) Form (B) Query (C) Table (D) Report
4. Which shortcut key is used to open an existing database in MS-Access? (DGK-17)
(A)CTRL+N (B)CTRL+S (C)CTRL +0 (D) CTRL +Z
5. The forms are designed to: (SGD-17)
(A) Data capturing (B) Data manipulation —
(C) Analysis (D) Managing output result
6. How many form layouts are available in MS- Access? (LHR-16)
(A)2 (B)3 (C) 4° (D) 5
7. A form within another form is called: (RWP-18)
(A) Sub Form (B) Main Form (C) Multi Form (D) Form
8. Asub form can be created by using:
. (MTN- 14,
(A) The form wizard (B) Drag and drop method
9 (C) Sub form wizard (D) All of these - :
. auto form displays one record at a time «
* (MTN-17)
(A)Columnar _ (B) Tabular _ (C) Datasheet / (D) Justified
10. A report may be based on: : (MTN-1)
(A) Table (B) Relationship (C) Form . .
11. How many reports layout are? . : . (D) Attribute
(A)2 (8)3 (C)4 (LHR-17)
12. Forms and controls are collectively recognized as: () 5
(A) Properties (B) Methods (C) Events — (RWP-14)
13. Which form property will put text in the tithe (D) Objects
, bar of the form?
(A) Title (B) Caption (C) Border t . (RWP-14)
14. A form is an object of: ext (D) Header
(A) Table (B) Database (DGK-16)
1S. A SUBFORM ls a form that is Placed (©) Query (D) Repon
in a parent form, called
(A) Main Form —(B) Parent Form (C) Sub-Form t
7-----2
1. It is used to make short keys or form with buttons: —
Switch Board (B) Linker (C) Border text (D) Justified
~ 2. It provides quick result from database.
(A) Forms Report
(C) Columnar (D) Objects .
3. Which command is used to execute commands in MS-Access forms:
‘(A) Execute (B) Open Run (D) None of these
?????????????????//////////////////////////////////????????????????????????????????????????????
Chapter 8 Computer
1. Which of the following language provided the basis for the developmen’ « Dh fOGD-1Y
- (A)B (B) C++ (C) Pascal (D) Com:
2. The statements written by programmer are called: (BY P-.21)
(A) Source code (B) Object code _ (C) Syntax (D) Debugging
3. The process of converting source code into object code is known as: (FBD-18)
(A)Compiling — (B) Executing (C) Linking (D) Saving
4. In assembly language, long machine language instructions are replaced with F.nglish like
words called: (GUJ-21)
(A) Statements (B) Mnemonics (C) Directives (D) Instructions
5. Cis a: . (BWP, DGK-22), (MTN-19)
(A) High Level Language (B) Low Level Language
(C) Assembly Language (D) Machine Language
6. exe file is produced by the: ‘SGD-21
(A) linker (B) loader (C) compiler (D) int af a
7. C statement ends with: . . interprets (RWP-21)
(A) Period (B) Comma . . °
8. B was developed in’the year: (©) Colon . (D) Semi colon
- (A) 160-70 (B) 1965-75 “19 (RWP-15)
72-
9. The programmer usually enters source code a8 . (D) 1989-1994
(A) Compiler (B) Text edit nto a computer using: (DGK-19)
10. C-Language was developed in: (C) Debugger (D) Linker
(A) 1962 - (By) 1969 . (C) 1970 (AJK-17)
11. 'C was designed to write Program for: —~ (D) 1972
(A) Windows Operating System ° . . (SWL-2E
(C) Unix Operating System “ Solaris Operating System )
12, Which of the following key is used to Io é ) OS/2 Operating System .
(A) Shift+F9 (BY) Cirl ae 4 Program in memory to run?
; tri + F9 (C) Alt + Fo (AJK-28)
13. Which of the key is used to load a p ram i (D) Ah + F4
(A) Alt + F9 (B) Ctr + rogram in memory to run?
14. Preprocesso F9 (C) Ctrl + § (GUJ-18)
. wen r directive are commands for: (D) Att+ F5
tcroprocessor-
(C) C preprocessér (B) Language processop 922 (LHR-21)
1S. Which header file contains inf (D) Loader
; ormation about standard input/out
(A) stdio. . siput functions?
h (B) conio.h, (C)stringh (FBD-21)
| _ (D) math.h
TAN PR FD wes
hich is low level language? . . (D) Fortran
I. we ‘sto Mh Machine (C) Visual Basic MTN 14
2. An IDE consists of: GEE All of thes |
(A) Text editor (B) Compiler (C) Debugger (LHR-22), (MIN. i6,
3. Which of the following key is used to save a file? Es (D) F9
F2 (B) F3 (C) (SWL, LHR-22), (MTV.2),
4. Turbo C++ can compile: nly
(A) Assembly program cx programs on") 5
(C) Machine program C and C++ program (GUI-19)
5. The extension of C Program file is:
(A) txt (B) .obj (C).h a « (S121
6. The output of the compiler is: eee
(A) Library code. (B) Linked code Object code (D) Source code
7. Which of the following is used to donate preprocessor directives? (LHR-17)
(A)% (BS mm (D) @
8. The extension of header file is: (GUS-18)
(A) .c (B) txt (C) .hf A
9. Every C program must have: . (MTN-21)
(A) scanf function (B) getche function i main function (D) print function
10. C-Language programs are divided into units called: (GUI-14)
- (A) Section (B) Syntax a Function ' - (D) Debug:
Il. A set of rules that must be followed to develop a program is called: (GUJ-21)
(A) bug . (B) debugging (C) preprocessor syntax
12, ais a rules for wre em is high lever Ooeuage is called: (RH P-22)
elimiter (D) Loader
13. a ound “alent nf to a group of “One enclosed in: SGD-22), (RWP-21)
14. A program syntax error is detected by: (D) ,
is (a) jcinker HE Compiicr (C) Loader (D) Debugger (Ome 2)
. ich error occur when the program directs the computer to perform an illegal Operation?
Runtime error (B) Logical error” . (FBD-21)
16. Which of the following language requires no ta syn et error (D) Conceptual error
(A)C (B)C++ aM oF to execute the program? (DGK-21)
17. The lowest level of Programming language is: Aenine language (D) Assembly Language
(A) Java it Assembly Language (C) Pascal (FBD-22), (BWP-18)
18 nich of the following is the native language or (D)C ++
(A) Assembly language. c pomputer? - (SGD-22)
(C) Visual Basic ii anguage
Machine Language
~ SHORT ANSWER QUESTIONS ..
QI. Write the use of Turbo C++.
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\////////////////////////////////////////////////////////////////
Chapter 9 Computer
1. The data type which is used to store NUNMNOT I 00 *
(A) char (B) int (C) float (Dy deuhle
2. Number of bytes used by long double data type is: MTN 16)
(A) 4 (B)8 (C) 10 (DD) 12
3... The number of digits after a decimal point is called: SODA
(A) Significance (B) Range (C) Preciston (D) Scope
4. The set of values and a set of operations on those values are known as: (SGD-22)
(A) Data Science (B) Database (C) Data Type (D) Data Files
5. intisa in C. (SGD-18)
_ (A) Special word = (B) Key word (C) Cut ward (D) First word
6. Memory is allocated to a local variable at the time of its: (SWL-22), (RWP-18)
j (A) Declaration (B) Relational operator
(C) Conditional operator (D) Arithmetic operator
7, The value of logical operator OR will be if: (RHP-ID
: (AVA=0&B=1 (B)A=1&B=0 (C)A=1&B 1 (D) All of these
8: Logical operators are: (RHP-I4
(A) AND (B) OR (C) NOT (D) All
8.- The Operators to compare operands and decide if the relation is true or false: (BWP-I9)
(A) Arithmetic operators (B) Logical Operators
(C) Relational Operators (D) Syntax Operators
9, The Modulus Operator is used for: (BwP-2F
(A) Exponent (B) Multiply (C) Division ;
10. Fi : (D) Remainder
. Find the output of the following expression 10* (24/(5-2)}+13:
. ; (DGK-I9
(A) 80 (B) 90 (C) 93 (D) 96 .
11. . The expression 0% 4 has a value equal to: ;
(BWP-
(A)4 (B) | (C)2 (D) 0
12. Another name for Keyword is: , ‘
- (A) Reserved Word (B) Special word (C)Comments ae
. . (D) identifier
13. A:variable name cannot begin with: . (0G
(A) Underscore (B) Upper case (C) Number (D) case
14. Ia C, the maximum length of variable name is: : ; ;
(A) 25 characters (B) 255 characters (C) 31 charecters 3
: D) 55 characters
15. A memory location with some dats that Can be changed is calted ae: (0) 55 j
(A) Constant (B) Variable (C) Address . (0) N 1 constant .
Aa identifier whose value can be change during the execution of the program is called: (DGK- /4
(A) Token (B) String (C) Constant a Variable
Variables are created in: (DGK-22), (GUI-1.
GRAM (B) ROM (C) Hard Disk (D) USB
Total number of keywords in C is: (GUJ-2.
(A) 30 32 . (C) 34 (D) 36
Variable and constant name cannot contains a(n): (MTN-18
(A) Letter (B) Underscore EF Period (D) Number
Which term describes the kind of values that s variable can store? (SGD-16
a Data type (B) Variable name (C) Variable type (D) Variable size
Which of the following is a valid character constant? (LHR-18
(A)A aft ‘'@' (C) "ce" (D) =
Which is a valid character constant? (GUJ-21
(A)A (B) "Hello" Ms (D) =
The number of bytes used by int data type in C is: (SWL-18
(A)8 (B) 6 (C)4 2
, The number of bytes an un-signed integer data type consumes is: (AJK-18
(A)! H2 (C)4 (D) 8
§. Which is a numeric data types? (MTN-14,
(A) Floating point (B) Integer [Both (A) and(B) —_ (D) None of these
1. How many bytes the float data type takes in memory? (ASK-19,
(A)2 (B) 3 m- (D) 8
2. Which is numeric data type with decimal points? (DGK-18,
$i front (B) int (C) char (D) long
3. Whieh data type is the most appropriate for storing a name? (FBD-19,
(A) Float (B) Int BB char (D) Long
4, The expression 3% § has a value equal to: . (FBD-15}
ws i: (C)2 (D) 1 .
iS The expression 14% 3 has a value equal to: (FBD-22)
(A)2 wi« (C) 4, 66 (D) 11
4 ‘The expression p- = q is equivalent to: (MTN-17)
» Aena-p (B)p=q-! GEp-p-q (D)q=p-p
. The expression M +N is equivalent to: (MTN-17)
(N+=M _(B)M=+N MRM=M+N (D) N=N+ M
& Thesymbols that perform operations on data are called: “(GUS-14)
”, Pt pion : &) eperand HB Operators (D) Operation code
consists of: ' (SGD-14
14; 2) Operators | Both A & C ' (C) Operands (D) None )
PSORM operstors allow you to values. MTN-
2; Becerpare “@) Add (C) Multiply (D) Divide OtTN-18)
7 the following is not relational operator? —~ (SGD-22)
Wid n catations! OY on falne, i has aa: @)==
so t expression is it has the value: ,
ty, ator "@)One = (C)Leasthan Zero. = (D) Two OP
r ' “aa ate enene that uses a relational operator is known as: (DGK-17)
yr pee (B) Sequential (c Serial lon BB Relational
: Bes ut ' ae take compos condition.
oe Pr Rian Logical (C) Bitwise (D) Relational (SGD-19)
a a PP
25. Which of the following is not logical operator? w ; (GUL Ty
(A) && (B) |l (C)! i> =
26. Which logical operator is used in C? b) « (RWP.2y,
(A)/ (B)+ ue _— (D)
27. Allof the following are logical operator OR will be 1 if. - (RWP.1g)
(A) NOT (B) AND (C) OR m-
28. A=A+B is equivalent to: (ASK-16)
(A)A=A+B i (C)B=+A (D)B+=A
29. The symbol of " =" represents: (BWP-22), (LHR-2))
(A) Comparison ER Assignment (C)Equalto (D) Logical
30. Single Line Comments start with: (BWP, LHR-2y
(A) # (B) */ (Cl M
31. This means to increase a value by one: (DGK-1))
(A) Modulus “tis Increment (C) Decrement (D) None of these
32. A type of operator that works with one opperand is called: (DGK-1))
(A) Binary operator it Uniary operator (C) Ternary operator (D) Relational operator
33. Which of the following is equivalent to ( P > = q)? (DGK-I6) |
(A) P < q WP < a) (C)P >q (D)!P ==B A! =B (D)A==B
40. = 2 and y = 3, what will be the output of the expression: x > y ?x+y: x * yz (LHR-19
iy 6 (B) 5 (C12, (D) 10
41. Select an operator with the highest precedence? (RWP-21)
a ! (B) + (C)= (D) ==
42. ich of the following data type offers the highest precision? ‘ (DGK-23}
i Float (B) Long int
(C) Long Double . (D) Unsigned long int .
43. The result of C expression 9/ 4 *2 will be equal to: a (FBD- 21,
M45 (B) 4.0 (C)5 (D)4
re .®
-->
///////////////////////////////////\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\????????????????????????????????????
Chapter 10 Computer
1, Which programming structure executes program statements in order: Pe misery)
(A) Relation (B) Decision (C) Sequence (D) Repetition
2. The function that is used to display output on careen is called: (SWL-21)
(A) Scanf (B) Pow (C) Display (D) Printf
3. Which character signifies the beginning of an escape sequence? (SWL-19)
(A) { (B) // (C)* (D)\
4. Which escape sequence moves the cursor st the beginning of current line? (FBD-21)
(A)\a (B) \b (C)\n (D)\r
5, The ASCII code for escape key: : (SGD-16)
(A) 27 (B) 28 (C) 29 (D) 30
6. The function getch ( ) is defined in: (DGK-22), (LHR-21)
(A) Stdio.h (B) Conio.h (C) String.h (D) Math.h,
7. The escape sequence for tab is: (DGK-21)
(A)\ (B) \b (C) \n (D)\t
8. Which escape sequence is used to begin new line? (MTN-21)
(A) \a (B) \b (C)\m (D) \n
9. Which of the following format specifier is used for string? (GUS-19
(A) % f (B) %d (C) %c (D)%s -
10. The general form of format specifier for floating point value is: (BWP-22)
(A) % maf (B) m.n%f (C) m%n.f (D) m%nf
11. Which of the following things are determined by format specifier? (BWP-14)
(A) Data Type (B) Format of the value
(C) Field Width (D) All of these :
12. Stdio stands for: : (DGK-18)
(A) Standard Input output (B) Simple Input output
(C) String Input output (D) Start Input output
13. An ampersand (&) before the name of the variable name, denotes: (GUJ-21)
(A) Actual value (B) Variabie name (C) Address (D) Data type
14. Which is output fanction in C program? {RWP.22)
(A) Printf) (B) Scanf() (C) gets) (D) getch() .
15. Format specifier starts with symbol: (FBD-22), (AJK-1)
1A\e% (R)* C) # i
===...
af () a:
reer wed mm Burtt in function
(C) Loca! furction (D) User defined function .
2. How many variables can be used in one printf function? (FBD-17)
(A) One (B) Two (C) Ten (1D) Many
3, The Format specifier You is used for: (SGD-16-22)
(A) Integer BBB Unsigned short (C) Unsigned float (D) Unsigned long int
4 The Format specifier %f is used for : (BWP-21)
(A) Character (B) Integer (C) Double BBB Fice:
The Format specifier % Is used for: (MTN-21)
(A) A Integers (B) Float (C) Double (BB character
6 Which of the following format specifier is used for integer data type?
Bw (B) %ec (C) %ef (D) %s
7. escape sequence used to move cursor one character back is: (GUS-21)
me (ByA (C)/n (Dyer
& What will be the vatue of x after executing the following code? (GUJ-18)
For (x = 0 5.4< 97; ve);
Priat £(" Yd” ,x)i
(A) $ (B)7 i: (D)I
@. Escape sequence \\ is used to print: (SWL-22), (LHR-21)
(A) New line (BB Backstash (C) Space (D) Tab
16. The general form of format specifler for Noating point value is: (DGK-19)
(Ay% m.nf (B) m.n% (C) m%.nf TR m.n%!
11. The escape sequence for carriage return ts: (SWL-17)
{ (A) \a (B)\c ae (D)\t
12, Which of the follow not a valid escape code? (RWP-18)
(A)¥ W (C)ry (D) \f
13. & symbol in scaaf fenction indicate variable’s
i Accs (B) Value (C) Format (D) Data type (GUS21)
14. te statement scanf(" ec", & kes); Km isa (n): (FBD-21) .
(A) integer variable [Character variable (C) Float variable (D) String variable
1S. getch () stands for: (DGK-IS
(A) ge character [i get character (C) Give character (D) All o
////////////////////////\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\????????????????/????????????========================
Chapter 11 Computer
“< * Choose the correct answer ane ve? aa (D) Nested: it TNT)
1. What is the simplest selection structu (C) If - else ram instruction?
(A) If (B) Switch are there to organize prog (RWP-22), (MTN.2
2. How many kinds of control structures (D) 5 )
(c)4 (LHRY
A)3 (B)2 led: )
3. Ae if statement inside another if statement Is *) We else staternent
(A) If- statement ' (D) Switch statement (ScD.
C) Nested if statemen ®
4. Wie keyword is not used in switch statemewe) Case (D) Fr BD-22) (awe
A) Default (B) . . D-22), (BWP.
5. Arother term for conditional operator is: (C) Byte (D) Iteration Rwe
(A) Ternary (B) By - else statement from the following: 2,
6. Choose an alternative to the If-e (B) Relational operator
(A) Logical operator ehmetic tor
(C) Conditional operator . — (D) Arithmetic of (RWP-2
7. Which key word is used for loop? () loop (D) if
(A) While (B) nese tina switch? (RWP.
8. Which of the following are valid case statemen ue (D) case 1.5:
t: (B) case x <4 -="" -else="" -if="" .="" 0="" 1.="" 10="" 11.="" 12="" 13.="" 14="" 15.="" 1:="" 1="" 2.="" 3.="" 3="" 4.="" 5.="" 6.="" 7.="" 7="" 9.="" a="" ab="" alternate="" alternative="" an="" ane="" anexpression="" another="" as="" asex="" ay="" b="" binary="" bu="" by:="" c="" called:="" called="" case="" casex="" chart="" comparison="" computer="" conditional="" d="" decision.="" decision="" e-r="" ee="" election="" else="" expression="" flow="" following="" for="" form="" four="" given="" graphical="" has="" if-="" if-else="" if-statement="" if="" ifa="" ii-statement="" in="" is:="" is="" it="" iteration="" j-15="" logic="" makes="" making="" nested-="" nested="" none="" of:="" of="" one="" operand="" operational="" operator="" program="" programming="" relation="" relational="" repetition="" representation="" represented="" see="" sequence="" sequential="" serial="" simplest="" statement:="" statement="" structure="" switch="" swl="" takes:="" term="" ternary="" that="" the="" these="" three="" to:="" true="" two="" used="" uses="" valid="" value:="" way="" which="">1: (D) Case 1.5:
8: The last statement of each case block in switch () structure must be:: (GUJ-14)
Default (B) ste ture end ©) Break (D) Else
9. The case block in switch () structure ends with : . ; (LHR-19
(A) End selett foop to terminate early: Png Case (0) Case else
+< statement causes pts : RWP-19
(\ QO aM is WER QUESTIONS a ,
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Chapter 12 Computer
Choose the correct answer and fil! up the OUDDICS SO".
1. What is the final value of | after executing the code: For (inti = 1; i< 5; i+=2) “_HR-18)
(A)7 (B) $ (C)6 (D)9
2. is a loop statement.
OR Which of the following is a loop statement in Cc? (RWP-19)
(A) lf (B) If -else (C) Switch (D) For
3. Ifyou want a user to enter exactly 20 values, which loop would be the best to use? —s-- (FBD-16)
(A) While (B) Do- while (C) Infinite (D) FOR
4. This statement may be used to stop a loop current iteration and begin next one: (FBD-18)
(A) Increment (B) Decrement (C) Break (D) Continue
§. This is a control structure that case a statement or group of statements to repeat: (DGK-19)
(A) Decision statement (B) Sequential
(C) Loop (D) Logical
6. The part of for loop executes only once: (GUS-21)
(A) Condition (B) Increment (C) Decrement (D) Initialization
7. How many types of loop structure are present? (BWP-22), (GUJ-19
(A) 1 (B)2 (C)3 (D) 4
& Which of the following ts not a Loop structure in C? (BWP-18)
(A) While (B) Condition (C) Do- While - (D) For
9. Which ts an example of multiple branches from single expression? (LHR-14)
(A) If statement (B) Switch statement (C) While loop (D) For loo
10. Which of the following loop is available in C? P (SWL-19)
(A) While- wend — (B) For- next (C) Sequence (D)Do- white -
tI. catering loop. when you know how many times you want to loop to iterate in ndvance q .
(A) While (B) For : (.
12. A loop within a loop is called: (C) Do-while (D) Nested
(A) Complex (B) Nested (C) Infinite (LHR-21) =
13. One execution of a loop is knowa as (n): (D) For
(A) Test (B) Iteration . (C) Duration (FBD, DGK-22), (AJK-19) |
14. One iteration of loop is known as: (D) Integer
(A) Iteration (B) Duration (C) Cycle _ (MTN-ID
15. im which loop, statement terminator Is a part of its syntax? (D) Repetition 1
(A) For (B) While (C) Do- while > (SGD-22), (LHR-19
Ems RCS eee CO ST SUEBARC HIN , For- cach
Laie Via ks: ot '
1. Which of the following is a loop statement? a EMEA
"Be white (B) if (C) If-else (D) Nested if
2. Select the programming structure that executes program statements in order: (DGK-21)
(A) Decision _ (B) Repetition Ml Secuence (D) Iteration
3, While toop is also called: (SGD-19)
A Conditional loop (B) Do - while loop (C) For loop (D) All of these
4. In white loop, the loop control variable is always initialized? : (SWL-17)
(A) Outside the program _ (B) Inside the loop body
(C) After loop ends - my Outside the body of ioop :
5. iterates at least once if condition is false: (GUJ-14)
(A) While loop Do-while loop (C) For loop (D) All of these .
6. The do-while loop structure always ends with: (DGK-14)
_ (A) Comma Semi coton (C) Colon (D) Brace
4. loop structure always executes at least once. (LHR-19)
(A) Nested (B) FOR (C) While - BE Do-while
8 In which loop the condition comes after the body of the loop? . (SWL-22), (MTN-19)
(A) For (). (B) While () rs Do-while () (D) Nested for (}
9. In for statement, the expression is executed only once (SWL-19)
0 “) Validation BES tnitialization (C) Test (D) Condition
. ich is a loop stunt? , ,
(A) If - "(B) ifetse Switch (D) For (APs)
11. What will be the final value of b after executing the code: (b =2; b <7 -="" -in="" .="" 09="" 0="" 1.="" 10.="" 105="" 10="" 11="" 12.="" 12="" 13.="" 13="" 14.="" 14="" 15.="" 15="" 1="" 1s="" 2.="" 22="" 2="" 2p="" 3.="" 3="" 4.="" 4="" 5.="" 6.="" 6="" 7.="" 7="" 8.="" 9.="" :="" _="" ___="" a-sequence="" a.="" a:="" a="" abit="" about="" ac="" accessibitity="" activates="" actua="" actual="" after="" all="" allocated="" allofthese="" also="" an="" and="" another="" answer="" are:="" are="" argumens:="" argument="" arguments="" argumeuis="" arithmetic="" as:="" as="" as___="" at="" atie="" automatic="" b="" bb="" be="" bedy="" bere="" binary="" bits="" body="" braces="" break="" built-="" built="" bv="" by="" bytes="" c-="" c-program="" c-sialenest="" c="" ca="" cache="" cail="" calied:="" call="" called:="" called="" calling="" can="" cannot="" case="" ccion="" center="" chapter="" character="" characters="" choose="" colon="" compile="" compiler:="" compute="" computer="" constant="" continue="" conversion="" correct="" counter="" cram="" created="" curly="" cz:="" d="" data="" dck-22="" declaration:="" declaration="" defined="" definition="" delivering="" design="" device="" different="" disk="" do-="" ds:="" dumiy="" dummy="" e="" eaccute="" eae...="" ee="" ength="" ere="" eruiments="" executing="" existing="" expression="" expressions="" f:="" f="" farameters="" file.="" file="" filtering="" final="" firs="" firsi="" first="" fis="" following="" fopen="" for="" formal="" fro="" from="" fuction="" function:="" function="" functions="" gb="" giba="" global="" hard="" header="" heed="" her="" hnown="" i:="" i="" iable="" icop="" il.="" il="" image="" imtn-17="" in-="" in.="" in:="" in="" infor="" information="" initial="" inp="" input="" int="" inthe="" intrinsic="" ir="" is:="" is="" iteration="" its:="" iw="" iy="" j.="" jo="" kao="" keyword="" kilobyt="" knatye="" known="" language="" le="" lhrsg="" library="" line="" lo="" lobytes="" local="" loo="" loop:="" loop="" lower="" lsh.="" m="" may="" me="" memory="" mo="" mode="" multiple="" multiplication="" must="" n="" nal="" name="" ne="" no.of="" not="" nr="" o="" object="" occurin="" of="" omuains="" only="" oo="" opening="" or="" original="" ot="" output="" p.="" p="" parameier="" paramete:="" parameter="" parameters="" part="" passed="" pe="" period="" poi="" pointer="" pp="" printfis="" process="" programmer="" prototype="" provides="" ps="" r="" ram="" read="" receive="" redefined="" redzfined="" referenced-argurien="" referenced="" refers="" refi="" register="" represents="" retum="" reture="" return="" returned="" rg="" rgumments="" ritten="" rom="" run="" s="" same="" scope="" sd="" semi="" sen.="" sending="" separate="" sequence="" set="" should="" siaiement="" sounter="" source="" specified="" specify="" sre="" start="" statement="" static="" stop="" stream="" subprograms="" subroutine="" takes="" tatement="" teen="" ter="" terminate="" text="" that="" the-cbde="" the="" these="" time="" title="" to:="" to="" type="" u="" used="" user-="" user-defined="" user="" ut="" v.="" value.="" value="" vari="" varia="" variabic="" variable="" variables="" w="" wane="" what="" whatis="" which="" white="" wi="" wp="" wt="" x="" ya="" yom="" ype=""> RWP-22
7, Which memory location contains the address of another memory location? ( -22)
(A) Function (B) Program _ {(C) Variable pointer ;
8. On successful closing a file, the fclose () returns: (FBD, LHR-22), (RWP-19)
(A) Null in 0 (zero) (C) | (One) . (D) File pointer
9. Which of the given function is used to write a string to a file? (SWL-22)
(A) puts (B) put c () io f puts () (D) f gets()
10. Which of the method will close a file? (SWL-22)
(A) Close all (B) Append @ Close (D) Exit
Il. A file is stored in: (DGK-22), (BWP-18)
(A) RAM Hard disk (C) ROM (D) Cache
12, A can store text only: ' (GUIJ-1 7.
(A) Binary File Text File (C) exe File - (D) Object File
13. In text file data is stored in: : (GUJ-14)
(A) ASCll-code —_(B) Binary code (C) Octal-code Text'code
14. Which of the following function is used to write a character to a file? (LHR-16)
(A) gete ( ) (B) fputs ( ) HM pute () (D) fgets ()
15. An array subscript should be: ; : . : , (MTN-18)
16. BB i f the follo Oe tune Wy, double oe
Q01)
-
-
-
- None of these
Answer:
Explanation:
Q02)
-
-
-
- None of these
Answer:
Explanation:
Q03)
-
-
-
- None of these
Answer:
Explanation:
Q04)
-
-
-
- None of these
Answer:
Explanation:
Q05)
-
-
-
- None of these
Answer:
Explanation:
Q06)
-
-
-
- None of these
Answer:
Explanation:
Q07)
-
-
-
- None of these
Answer:
Explanation:
Q08)
-
-
-
- None of these
Answer:
Explanation:
Q09)
-
-
-
- None of these
Answer:
Explanation:
Q10)
-
-
-
- None of these
Answer:
Explanation:
Q11)
-
-
-
- None of these
Answer:
Explanation:
Q12)
-
-
-
- None of these
Answer:
Explanation:
Q13)
-
-
-
- None of these
Answer:
Explanation:
Q14)
-
-
-
- None of these
Answer:
Explanation:
Q15)
-
-
-
- None of these
Answer:
Explanation:
Q16)
-
-
-
- None of these
Answer:
Explanation:
Q17)
-
-
-
- None of these
Answer:
Explanation:
Q18)
-
-
-
- None of these
Answer:
Explanation:
Q19)
-
-
-
- None of these
Answer:
Explanation:
Q20)
-
-
-
- None of these
Answer:
Explanation:
Q00)
-
-
-
- None of these
Answer:
Explanation:
PDF Questions
CSBoxer.Com
https://www.csboxer.com/p/about.html
2023
ICS Part ii Short Question
Chapter 1-5
By: Mirza Jamshaid Baig
Chapter 1
Q2. Write short answer to any SIX (6) Questions
1) Define Data?
2) Define Information.
3) What is meant by file Organization?
4) Define data file.
5) Define Data integration.
6) Define Data Integrity.
7) Why is report generator used in database system?
8) What is the purpose of Backup and recovery?
9) What is direct access file and sequential file?
10) What is the main purpose of database system?
11) What is Database System?
12) Why do people use Database? -
13) What is the purpose of index file? . |
14) Differentiate between database, (DBA) and (DBMS).
15) List the file types from usage point of view. |
16) List the file types from functional point of view.
17) What is the use of DML? ,
18) What is file? OR Define Data set. |
19) Define Program.
20) What is meant by Data Reproduction?
21) Define program file with example.
22) Define Database.
23) List different objectives of Database?
24) Write any two advantages of Database Management System.
25) What is the use of DDL?
26) What is the use of data dictionary?
Chapter No 2
1) How can we describe Data Handling in File System?
2) How a relation is formed in DB?
3) What is Table In DataBase?
4) Define RDBMS.
5) List any two data distribution Strategies.
6) What is Key? Why are keys defined in Tables?
7) List different types of keys.
8) Define composite key or concatenate key.
9) Define forcign key attributes in database.
10) What is the purpose of foreign key? OR Define foreign key.
11) Define "End User" Or Clients?
12) Who is user or End User? :
13) Who is data administrator? OR write the responsibility of data admini
14) Write down the two or four responsibilities of database administrator.
15) Define an Entity or Object. Also give Example.
16) Define Indexes.
17) Define the term index.
18) Enlist Four different properties of a relation.
19) What.do you remember about any two properties of relation?
20) Define the term table or relation. =.
21) Differentiate between database and table.
22) Define Field. : :
23) (Differentiate between parent table and dependent table.
24) Differentiate between parent table and child Table.
25) How-would you differentiate bétween tables and views?
26) What is a view? .
27) What is the purpose of using views?
28) Write down the basic purpose of using views.
29) Define view. And its types.
30) Define primary key.
31) Define secondary key.
32) Define candidate and alternate keys.
33) Write three important characteristics of a primary key.
Chapter NO 3
Write short answer to any Six Questions
1) What is project planning?
2) What is analysis in database?
3) What is the concept of cardinality of Database .
4) Define Modality of a relation? OR Define the term Modality.
5) State the purpose of database design process
6) List three uses of logic flow diagram. Or DFD OR ERD
7) What is the purpose of logical database design?
8) Explain Implementation,
9) How would you present the concept of Data Volum and usage analysis in physical
database design?
10) List four data distribution Strategy.
11) How is database integrity maintained?
12) Define cardinality and describe its purpose.
13) Distinguish between Entity and Entity Instance.
14) Write any two criteria to select file Organization.
15) Define an attribute. State an attribute with one example. .
16) Give two examples of entity.
17) Define the term analysis.
18) What is the purpose of analysis?
19) Why is requirement analysis conducted?
20) Enlist different types of relationships.
21) Define Entity or Objects.
22) What is entity Integrity.
23) Give one example of one - to - one relationship.
24) Differentiate between Cardinality and Modality.
25) What is the concept of Data Distribution Strategy”
26) List any four components of physical database design.
27) What is the major objective of physical Database Design’”’
28) Write the purpose of feasibility study. .
29) What can you say about feasibility study in database design process
Chapter No 4
Q2. Write short answer any Six Questions.
1) How first normal form is Achieved?
2) When a relation will in First Normal Form?
3) What is Normalization? OR What is meant by Normal Form?
4) Why is Normalization used?
5) How second normal form is achieved?
6) How do we attain Entity Integrity In database?
7) Define functional dependency with example:
8) Define database integrity, and its use.
9) What do you mean by data Integrity?
10) Define Synonym.
11) What is homonym? OR Define Homonym.
12) Define 3rd normal form. any SIX (6) questions:
13) Define repeating group.
14) What is the concept of transitive dependency?
15) What is meant by Transitive dependency’? |
16) Differentiate between partial dependency and transitive dependency.
17) How partial dependency is differing from transitive dependency.
18) When is a relation in second normal form?
19) When does an insertion anomaly occur?
20) Define partial dependency.
21) OR) What is partial dependency in Relation? .
22) viii) What are Database Anomalies? Only list their names.
23) Define Insertion Anomaly.
24) Write short answers to any SIX (6) questions:
25) What is the purpose of database integrity?
26) When is referential integrity used?
27) Define Entity Integrity. What do you mean by Entity Integrity?
28) How Homonyms create problems in Database?
29) Why is normalization used?
30) Define referential integrity.
31) What is referential integrity? .
32) How would you define referential integrity? .
33) Differentiate between Entity Integrity and Referential Integrity?
34) How data redundancy is controlled in relational databases”
35) Write down conditions for a table to be in 2NE.
Chapter No 5
Q2. Write short answer any Six Questions.
1) Define four Object of database
2) What is query?
3) List different buttons available in Microsoft Access as DMS.
4) Write the use of database window in MS Access,
5) What is use of toolbars in MS Access?
6) What is the use of title bar in MS-Access?
7) What is the extension of database file in MS-Access?
8) What is Database wizard?
9) Define Wizard in MS-Access.
10) What is Microsoft ACCESS? |
11) List down any two advantages of Microsoft Access.
12) Write two benefits of using Access. -
13) List any two facilities provided by RDBMS.
14) List advantages of RDBMS
15) List any four parts of Application Window in MS-Access.
16) How is MS-ACCESS loaded? (RWP. 2021) 5.1
17) Which database object is used to create and format printed output?
18) List-any five buttons available on. Access Database. window.
19) What are reports?
20) Write two advantages of form.
21) Write definition of Reports. .
22) How MS-ACCESS exiting from Windows?
23) Describe Menu Bar.
24) List any four properties of relational database management system.
25) What is sample database?
26) List advantages of MS-ACCESS.
27) What is the-use of MS-Access? |
28) Write uses of query. —
29) Define Scroll Bar and its use.
30) What is Navigation Buttons and Navigation Bars.
Welcome to CSBoxer, as you guys know. CSBoxer is all Computer Science's fundamentals.
All published articles are organized in simple, easy, and short English sentences to familiarize the students with computer science.
In that respect today's article is contentWaper
Find
![Important 100+ [A-Z] MS Word shortcut keys For EntryTest](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYIMidwgy65yY5eyjb2cNy8JVYYV1gNqAnGazi59z4kINMUZvBuCCCWLJGYwbFToNawN-P7FovySo547mTx3OgOdATrfbxK69TEl4LF87Dryrj2Xn6UMcnclGTHTDhvbpbQU7VKvIKmwgX-1MQEU3w1t1wrkwRfr7YJgAWpXuu4HDZ50CuWLo-e02f/w100/Ms-Word-ShortCut-Keyes-min.png)
0 Comments