Sawaal
  • Home/
  • Searching for I

 Searching for "I"

Q:

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Answer

Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

What are the Referential actions supported by FOREIGN KEY integrity constraint?

Answer

UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode?

Answer

Complete database recovery from disk failure is possible only in ARCHIVELOG mode. Online database backup is possible only in ARCHIVELOG mode.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

What is a DBA?

Answer

A DBA is a Database Administrator, and this is the most common job that you find a database specialist doing. There are Development DBAs and Production DBAs.


- A Development DBA usually works closely with a team of developers and gets more involved in design decisions, giving advice on performance and writing good SQL.


  That can be satisfying at a human level because you are part of a team and you share the satisfaction of the teams accomplishments.


- A Production DBA (on the other hand) is responsible for maintaining Databases within an organization, so it is a very difficult and demanding job. He or she, often gets involved when all the design decisions have been made, and has simply to keep things up and running.


  Therefore, of course, it is also a rewarding job, both financially and in terms of job satisfaction. But it is a more "lonely" job than being a Development DBA.


. 

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

Q's mother is sister of P and daughter of M. S is daughter of P and sister of T.How is M related to T?

A) Father B) Grandfather
C) Grandmother D) Either Grandmother or Grandfather
 
Answer & Explanation Answer: D) Either Grandmother or Grandfather

Explanation:

Q's mother is sister of P &  daughter of M.[sex of P and M are not clear]

 

S is daughter of P and sister of T.  [sex of P and T is not clear]

 

M's children : Q's mother and P

 

P's children  :S[female] and T

 

M is either Grandmother or Grandfather of T

Report Error

View Answer Report Error Discuss

Filed Under: Blood Relations
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Bank Clerk

Q:

Pointing to a man, a woman said "His mother is the daughter of my mother's  only daughter" . How is the man related to that woman?

A) Son B) Father
C) Brother D) Grand Son
 
Answer & Explanation Answer: D) Grand Son

Explanation:

My mother's only daughter means the woman itself. Woman's daughter is the mother of man in question.Therefore, the woman (speaker) is the grand mother of man. Thus, man is the grandson of the woman.

Report Error

View Answer Report Error Discuss

Filed Under: Blood Relations

Q:

In the following question select the one which is different from the other three responses .

1. DEB   2. RTP    3. HIF    4. NOL

Answer

Answer : (2)


1. D(E)B  --------> vowel in the middle


3. H(I)F   --------> vowel in the middle


4. N(O)L  --------> vowel in the middle


Option(2) ,No vowel in the middle.   

Report Error

View answer Workspace Report Error Discuss

Subject: Classification

Q:

Four of the following five are alike in a certain way and so form a group. which one does not belong to that group?

1. Metre   2. Furlong    3. Yard   4. Mile    5.Acre

Answer

Answer : (5)


Acre measurers area whereas others are distance measures.

Report Error

View answer Workspace Report Error Discuss

Subject: Classification