Breaking Employment News

1. Food Corporation of India notifies Combined Recruitment for Assistant Grade III in General, Depot, Technical and Account Cadres in the FCI-2013 No. of Vacancies : 6545 Last Date: 21.09.2012 2. Central Railway, Mumbai requires 2572 Trackmen, Hamal, Khalasi, Safaiwala and Asstt Pointsman, etc. Last Date: 25.09.2012 3. East Central Railway, Patna requires 2226 Porter, Trackman, Helper-II, Safaiwala & Grade 'D' (Engg & Store) Last Date : 10.10.2012 4. South East Central Railway requires 2079 Porter, TMO/ KSI, Helper-II, Trackman, etc. Last Date : 05.10.2012 5. South Western Railway, Hubli requires 790 Trackman, Helper, Porter/ Hamal/Sweeper-cum- Porter/Optg and Safaiwala/ Medi Last Date : 28.09.2012 6. Railway Recruitment Cell, East Coast Railway, Bhubaneswar requires 400 Helper-II Last Date : 24.09.2012 7. Vijaya Bank, Bangalore requires 800 Probationary Clerk Closing Date for online registration: 05.09.2012 8. Indian Bank, Chennai requires 215 Specialist Officers Closing Date for online registration: 05.09.2012 9. Steel Authority of India Limited, Salem requires 54 Attendant-cum-Technician- Trainee Last Date : 10.09.2012 / ** span>

sbi bank clerk computer based sample questions

1. Database redesign is not terribly difficult if the:
database is structured.
database is well-designed.
database has no data.
database is relatively small.
Ans (3)

2. A regular subquery can be processed:
from the top down.
from the bottom up.
by nesting.
None of the above is correct.

Ans (2)

3. Which of the following SQL statements are helpful in database redesign?
Correlated subqueries only
EXISTS/NOT EXISTS expressions only
Both of the above are helpful
None of the above are helpful.

Ans (3)

4. Which is not true of a correlated subquery?
EXISTS/NOT EXISTS is a form of a correlated subquery.
The processing of the SELECT statements is nested.
They can be used to verify functional dependencies.
They are very similar to a regular subquery.

Ans (4)

5. The EXISTS keyword will be true if:
any row in the subquery meets the condition only.
all rows in the subquery fail the condition only.
both of these two conditions are met.
neither of these two conditions is met.

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)

9. The process of reading a database schema and producing a data model from that schema is known as:
data modeling.
database design.
reverse engineering.
None of the above is correct.

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 structures 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 redesign process?
One
Two
Three
Four

Ans (3)

13 Which SQL-92 standard SQL command can be used to change a table name?
RENAME TABLE
CHANGE TABLE
ALTER TABLE
None of the above is correct.
Ans (4)

14.What SQL command can be used to add columns to a table?
MODIFY TABLE TableName ADD COLUMN ColumnName
MODIFY TABLE TableName ADD ColumnName
ALTER TABLE TableName ADD COLUMN ColumnName
ALTER TABLE TableName ADD ColumnName

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)

16. To drop a column that is used as a foreign key, first:
drop the primary key.
drop the table containing the foreign key..
drop the foreign key constraint.
All of the above must be done.
Ans (3)

17. Which of the following modifications may not succeed?
Changing a column data type from char to date
Changing a column data type from numeric to char
Both of the above actions should succeed.
Neither of the above actions will succeed.

Ans (1)

18. What SQL command will allow you to change the table STUDENT to add the 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 (Grade > 0);
None of the above is correct.

Ans (3)

19. Changing cardinalities in a database is:
a common database design task.
a rare database design task, but does occur.
a database design task that never occurs.
is impossible to do, so a new database must be constructed and the data moved into it.

Ans (1)


20. Because of the importance of making data model changes correctly, many professionals are __________ about using an automated process for database redesign.
optimistic
skeptical
ambivalent
None of the above is correct.

Ans (2)

1 comments:

Anonymous November 7, 2012 at 11:22 PM


nice piece of information, I had come to know about your internet site from my friend vinay, delhi,i have
read atleast 12 posts of yours by now, and let me tell you, your website gives the best and the most
interesting information. This is just the kind of information that i had been looking for, i'm already your rss
reader now and i would regularly watch out for the new post, once again hats off to you! Thanx a ton once
again, Regards, Free Online Bank Clerk Test CWE | Bank Clerk Free Online Mock Test | Free Online Mock Test For Bank Clerk Exams PO

COMPUTER GENERAL KNOWLEDGE QUIZ

COMPUTER GENERAL KNOWLEDGE QUIZ COMPUTER QUIZ

Objective 10 questions


1. Why the document you created at home displays with a different font at school?

Because you have a different printer at school than at home Because you have a different monitor at school than at home

font you used at home is not installed on your school computer Because the version of Windows is different

2. Which keyboard shortcut centers selected text?

Ctrl+C Alt+C There is no keyboard shortcut for this operation Ctrl+E

3. What is the default file extension for all Word documents?

TXT WRD FIL DOC

4. Which key moves your cursor from one cell to the next in a table?

Tab Shift Enter Ctrl+Enter

5. How many different documents can you have open at one time?

No more that three Only one As many as your computer memory will hold No more than your Taskbar can display

6. In order to email a Word document from within Word:

Go to File/Send To/Mail Recipient Save the file as an email attachment Start Outlook and attach the file while open in Word This is an impossible operation

7. Which keystroke will take you at the beginning or the end of a long document?

Ctrl+PageUp and Ctrl+PageDown Shift+Home and Shift+End Ctrl+Home and Ctrl+End The only way is by using the right scroll bar

8. How many margins are on a page?

Two (header and footer) Four (top, bottom, right, left) Two (landscape and Portrait) Two (top and bottom)

9.In order to save a Word document as a web page you need to:

Put the appropriate graphics and links on the document Save the document in simple text format Use your web browser as an editor and save as URL Save as HTML

10. A document in portrait prints:

The same characters per line with the same document in landscape More characters per line than the same document in landscape Less characters per line than the same document in landscape Smaller fonts in order to fit the same amount of characters per line with landscape

CURRRENT GK QUIZ

CURRENT GENERAL AWARENESS QUIZ

OBJECTIVE QUESTIONS 10


1. Femina Miss India World award for 2012 has been awarded to –

Vanya Mishra
Prachi Mishra
SimranKaur Mundi
Crystle Stewart

2. Who among the following is the winner of the Rajiv Gandhi Khel Ratna Award for the year 2011? –

Sachin Tendulkar
Saurav Ganguli
Sanjeeva Kumar Singh
Gagan Narang

3. The Mascot of the 2008 Olympic Games was-

Fuwa
Izz
Izz
Cobi

4. Which among the following has won 2012 IPL Tournament?

Chennai Super Kings
Kolkata Knight Riders
Deccon Chargers
Delhi Daredevils

5. Who has written “Unaccustomed Earth” ?

Jhumpa Laheri
Kiran Desai
Arundhati Roy
Khushwant Singh

6. Which of the following has been selected for best parliamentarian of the year award 2007 ?

Priya Ranjan Das Munshi
Mani Shankar Aiyyar
P.Chidambaram
Sushama Swaraj

7. Duwuri Subbarao's name was in news recently as he has taken over as the Governor of
RBI
SBI
SEBI
Bihar

8. ISRO has launched successfully RISAT-1 satellites through PSLV-C19 on -

15th March,2012
30th March,2012
26th April,2012
4th May,2012

9. Which country was host 15th SAARC Summit in 2008 ?

Maldives
Sri Lanka
India
Pakistan

10. Who among the following is the winner of the Wimbledon open Tennis Tournament 2008 of the Women's Single Title ? 

Serena Williams
Venus Wlliams
Maria Sharapova
Ana Ivanovic

Ana Ivanovic