Sbi Bank Clerk Computer Based Sample Questions Posted by Free
Sbi Bank Clerk Computer Based Sample Questions Posted by Free
Sbi Bank Clerk Computer Based Sample Questions Posted by Free
Ans (2)
Ans (3)
Ans (4)
Ans (1)
6. The NOT EXISTS keyword will be true if:
any row in the subquery meets the condition.
all rows in the subquery fail the condition.
both of these two conditions are met.
neither of these two conditions is met.
Ans (2)
7. How can you find rows that do not match some specified condition?
EXISTS
Double use of NOT EXISTS
NOT EXISTS
None of the above is correct.
Ans (2)
8. Before any changes to database structure are attempted one should first:
clearly understand the current structure and contents of the database only.
test any changes on a test database only.
create a complete backup of the operational database only.
All of the above should be done.
Ans (4)
Ans (3)
10. The data model that is produced from reverse engineering is:
1. a conceptual model.
2. an internal model.
3. a logical model.
4. None of the above is correct.
Ans (4)
11. A tool that can help designers understand the dependencies of database st
ructures is a:
dependency graph.
data model.
graphical display.
None of the above is correct.
Ans (1)
12. How many copies of the database schema are typically used in the redes
ign process?
One
Two
Three
Four
Ans (3)
Ans (3)
15. What SQL command can be used to delete columns from a table?
MODIFY TABLE TableName DROP COLUMN ColumnName
MODIFY TABLE TableName DROP ColumnName
ALTER TABLE TableName DROP COLUMN ColumnName
ALTER TABLE TableName DROP ColumnName
Ans (3)
Ans (1)
18. What SQL command will allow you to change the table STUDENT to add t
he constraint named GradeCheck that states that the values of the Grade
column must be greater than 0?
ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade >
0);
ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0)
;
ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Gra
de > 0);
None of the above is correct.
Ans (3)
Ans (1)
20. Because of the importance of making data model changes correctly, man
y professionals are __________ about using an automated process for datab
ase redesign.
optimistic
skeptical
ambivalent
None of the above is correct.
Ans (2)