Tuesday, November 7, 2017

Kerala PSC HSST Computer science previous questions part 3

Kerala PSC HSST Computer science Previous solved question paper Part 3
Question Paper Code: 86/2016/OL
Category Code: 099/2015
Exam: HSST Computer Science SR For SC/ST
Date of Test 29-12-2016

51:-The __________ clause is used to list the attributes desired in the result of a query.
A:-where
B:-from
C:-select
D:-having
 Answer:- Option-C

52:-We express queries in QBE by
A:-Datalog
B:-Skeleton tables
C:-Entity sets
D:-SQL
 Answer:- Option-B

53:-_________ is a set of permitted values for each attribute.
A:-Domain
B:-Entity
C:-Constraints
D:-Relationship
 Answer:- Option-A

54:-Minimal super keys are called
A:-Primary key
B:-Foreign key
C:-Candidate key
D:-Unique
 Answer:- Option-C

55:-A relation is in __________, every non-key attribute is irreducibly dependent on the primary key.
A:-1NF
B:-2NF
C:-3NF
D:-4NF
 Answer:- Option-B

56:-A statement that the system executes automatically when a database related event occurs.
A:-View
B:-Alter
C:-Assertion
D:-Trigger
 Answer:- Option-D

57:-An index record appears for every Search key value in the file
A:-Dense indexB:-Sparse index
C:-Hash index
D:-Single-key index
 Answer:- Option-A

58:-In hashing, we use the term to denote a unit of storage that can store one or more records.
A:-Field
B:-Hash function
C:-Index
D:-Bucket
 Answer:- Option-D

59:-The number of transactions executed in a given amount of time is called
A:-Response time
B:-Waiting time
C:-Throughput
D:-Performance
 Answer:- Option-C

60:-_________ is a predicate expressing a condition that we wish the database always to satisfy.
A:-Authorization
B:-Deadlock
C:-QBE
D:-Assertion
 Answer:- Option-D

61:-A variation in the representation of the waterfall model is called
A:-Classic life cycle
B:-V-model
C:-Incremental process model
D:-Spiral model
 Answer:- Option-B

62:-The most common manifestation of separation of software into separately named and addressable components
is called
A:-Concern
B:-Pattern
C:-Modularity
D:-Independence
 Answer:- Option-C

63:-________ is an indication of the relative interdependence among modules.
A:-Coupling
B:-Cohesion
C:-Hiding
D:-Refactoring
 Answer:- Option-A

64:-The diagram which help you to determine the functionality and features of the software from the user's perspective.
A:-Class diagram
B:-Deployment diagram
C:-Sequence diagram
D:-Use-case diagram
 Answer:- Option-D

65:-__________ testing is focuses on the functional requirements of the software.
A:-White-box testing
B:-Black-box testing
C:-Condition testing
D:-Unit testing
 Answer:- Option-B

66:-The software metric that provides a quantitative measure of the logical complexity of a program.
A:-Cylcomatic complexity
B:-Defect removal efficiency
C:-Object-oriented metrics
D:-LOC Answer:- Option-A

67:-________ is the most widely used strategy for statistical quality assurance in industry.
A:-Pareto principle
B:-CMM
C:-Six Sigma
D:-IEEE
 Answer:- Option-C

68:-__________ is an agile software development approach.
A:-Extreme programming
B:-Quality function deployment
C:-PSPEC
D:-Unified process
 Answer:- Option-A

69:-________ provide a notation that translates actions and conditions described in a use case into a tabular form.
A:-Decision tree
B:-Pattern
C:-Linear structures
D:-Decision tables
 Answer:- Option-D

70:-________ is a project scheduling method.
A:-PERT
B:-Scrum model
C:-UML
D:-RAD
 Answer:- Option-A

71:-The bus carries bits between
A:-Microprocessor and Memory
B:-Microprocessor and I/Os
C:-Memory and I/Os
D:-Microprocessor, Memory and I/Os
 Answer:- Option-D

72:-The Gray code for the binary number `(101110)_(2)` is
A:-111101
B:-111001
C:-111011
D:-111010
 Answer:- Option-B

73:-Simplify the expression AB + A(B + C) + B(B + C) using Boolean algebra techniques is
A:-C + AC
B:-A + AC
C:-B + AC
D:-B + AB
 Answer:- Option-C

74:-How many 74154 4-line-to-16-line decoders are necessary to decode a six-bit binary number ?
A:-One
B:-Two
C:-Three
D:-Four
 Answer:- Option-B

75:-The binary equivalent for the BCD number 10000101 is
A:-`(1010100)_(2)`
B:-`(1000100)_(2)`
C:-`(1110100)_(2)`
D:-`(1010101)_(2)`
 Answer:- Option-D

0 comments

Post a Comment