Dear Aspirants, Our IBPS Guide team is providing a new series of Computer Awareness Questions for IBPSRRB PO/Clerk Mains 2019 so the aspirants can practice it on a daily basis. These questions are framed by our skilled experts after understanding your needs thoroughly. Aspirants can practice these new series questions daily to familiarize with the exact exam pattern and make your preparation effective.
IBPS RRB PO Clerk/Mains Computer Questions 2019 (Day – 41)
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 10 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Average score
Your score
Categories
Not categorized0%
maximum of 10 points
Pos.
Name
Entered on
Points
Result
Table is loading
No data available
Your result has been entered into leaderboard
Loading
1
2
3
4
5
6
7
8
9
10
Answered
Review
Question 1 of 10
1. Question
Which one of the following language is used in 3GL?
Correct
Answer: d)
3rd – High level languages
->FORTRAN II – IV
->COBOL
->PASCAL
->BASIC
->ALGOL68
Incorrect
Answer: d)
3rd – High level languages
->FORTRAN II – IV
->COBOL
->PASCAL
->BASIC
->ALGOL68
Question 2 of 10
2. Question
Which one of the following is used to stores the data in tabular format?
Correct
Answer: b)
RDBMS
->RDBMS stores data in tabular form.
->Normalization is present in RDBMS.
Incorrect
Answer: b)
RDBMS
->RDBMS stores data in tabular form.
->Normalization is present in RDBMS.
Question 3 of 10
3. Question
Which one of the following commands is used to allow specified users to perform specified tasks?
Correct
Answer: c)
Grant
-> Allow specified users to perform specified tasks.
Incorrect
Answer: c)
Grant
-> Allow specified users to perform specified tasks.
Question 4 of 10
4. Question
Which one of the following commands is used to cancel previously granted or denied permissions?
Correct
Answer: c)
Revoke
-> Cancel previously granted or denied permissions.
Incorrect
Answer: c)
Revoke
-> Cancel previously granted or denied permissions.
Question 5 of 10
5. Question
Which one of the following has no transitive functional dependencies?
Correct
Answer: c)
3NF
->A relation is in third normal form, if there is no transitive dependency for non-prime attributes is it is in second normal form.
->A relation is in 3NF if at least one of the following condition holds in every non-trivial function dependency X –> Y.
Incorrect
Answer: c)
3NF
->A relation is in third normal form, if there is no transitive dependency for non-prime attributes is it is in second normal form.
->A relation is in 3NF if at least one of the following condition holds in every non-trivial function dependency X –> Y.
Question 6 of 10
6. Question
If every attribute in that relation is singled valued attribute then it is in ____ Form
Correct
Answer: a)
1 NF
->A relation is in first normal form if every attribute in that relation is singled valued attribute.
->If a relation contain composite or multi-valued attribute, it violates first normal form or a relation is in first normal form if it does not contain any composite or multi-valued attribute.
Incorrect
Answer: a)
1 NF
->A relation is in first normal form if every attribute in that relation is singled valued attribute.
->If a relation contain composite or multi-valued attribute, it violates first normal form or a relation is in first normal form if it does not contain any composite or multi-valued attribute.
Question 7 of 10
7. Question
A relation is in ______ if it has No Partial Dependency is dependent on any proper subset of any candidate key of the table
Correct
Answer: b)
2 NF
->It should be in second normal form, a relation must be in first normal form and relation must not contain any partial dependency.
->A relation is in 2NF if it has No Partial Dependency, i.e., no non-prime attribute (attributes which are not part of any candidate key) is dependent on any proper subset of any candidate key of the table.
Incorrect
Answer: b)
2 NF
->It should be in second normal form, a relation must be in first normal form and relation must not contain any partial dependency.
->A relation is in 2NF if it has No Partial Dependency, i.e., no non-prime attribute (attributes which are not part of any candidate key) is dependent on any proper subset of any candidate key of the table.
Question 8 of 10
8. Question
Which one of the following cannot be decomposed into any number of smallertables without loss of data?
Correct
Answer: d)
5NF
->A table is in 5th Normal Form only if it is in 4NF.
->It cannot be decomposed into any number of smaller tables without loss of data.
Incorrect
Answer: d)
5NF
->A table is in 5th Normal Form only if it is in 4NF.
->It cannot be decomposed into any number of smaller tables without loss of data.
Question 9 of 10
9. Question
Which one of the following is the act of secretly listening to a private conversation, typically between hosts on a network?
Correct
Answer: b)
Eavesdropping
-> It is the act of secretly listening to a private conversation, typically between hosts on a network.
Incorrect
Answer: b)
Eavesdropping
-> It is the act of secretly listening to a private conversation, typically between hosts on a network.
Question 10 of 10
10. Question
Which one of the following shortcut key is used to insert a page break?
1) Which one of the following language is used in 3GL?
a) COBOL
b) PASCAL
c) BASIC
d) All of these
e) None of These
2) Which one of the following is used to stores the data in tabular format?
a) DBMS
b) RDBMS
c) Both a and b
d) Dbase
e) None of These
3) Which one of the following commands is used to allow specified users to perform specified tasks?
a) Call
b) Rollback
c) Grant
d) Revoke
e) None of These
4) Which one of the following commands is used to cancel previously granted or denied permissions?
a) Commit
b) Rollback
c) Revoke
d) Grant
e) None of These
5) Which one of the following has no transitive functional dependencies?
a) 1 NF
b) 2 NF
c) 3 NF
d) 4 NF
e) None of These
6) If every attribute in that relation is singled valued attribute then it is in ____ Form
a) 1 NF
b) 2 NF
c) 3 NF
d) 4 NF
e) None of These
7) A relation is in ______ if it has No Partial Dependency is dependent on any proper subset of any candidate key of the table
a) 1 NF
b) 2 NF
c) 3 NF
d) 4 NF
e) None of These
8) Which one of the following cannot be decomposed into any number of smallertables without loss of data?
a) 2NF
b) 3 NF
c) 4 NF
d) 5 NF
e) None of These
9) Which one of the following is the act of secretly listening to a private conversation, typically between hosts on a network?
a) Phishing
b) Eavesdropping
c) Spoofing
d) Direct-access attacks
e) None of These
10) Which one of the following shortcut key is used to insert a page break?
a) Ctrl + A
b) Ctrl + D
c) Ctrl + Enter
d) Shift + F3
e) None of These
Answers :
1) Answer: d)
3rd – High level languages
->FORTRAN II – IV
->COBOL
->PASCAL
->BASIC
->ALGOL68
2) Answer: b)
RDBMS
->RDBMS stores data in tabular form.
->Normalization is present in RDBMS.
3) Answer: c)
Grant
-> Allow specified users to perform specified tasks.
4) Answer: c)
Revoke
-> Cancel previously granted or denied permissions.
5) Answer: c)
3NF
->A relation is in third normal form, if there is no transitive dependency for non-prime attributes is it is in second normal form.
->A relation is in 3NF if at least one of the following condition holds in every non-trivial function dependency X –> Y.
6) Answer: a)
1 NF
->A relation is in first normal form if every attribute in that relation is singled valued attribute.
->If a relation contain composite or multi-valued attribute, it violates first normal form or a relation is in first normal form if it does not contain any composite or multi-valued attribute.
7) Answer: b)
2 NF
->It should be in second normal form, a relation must be in first normal form and relation must not contain any partial dependency.
->A relation is in 2NF if it has No Partial Dependency, i.e., no non-prime attribute (attributes which are not part of any candidate key) is dependent on any proper subset of any candidate key of the table.
8) Answer: d)
5NF
->A table is in 5th Normal Form only if it is in 4NF.
->It cannot be decomposed into any number of smaller tables without loss of data.
9) Answer: b)
Eavesdropping
-> It is the act of secretly listening to a private conversation, typically between hosts on a network.
10) Answer: c)
Ctrl + Enter
->Insert a page break.
5 / 5. Reviews 2
Be the first to rate this post.
IBPSGuide Recommends Affairs Cloud Current affairs PDF
