Sawaal
  • Home/
  • Searching for F

 Searching for "F"

Q:

Which command is used to return maximum value from result set?

A) MAX B) MIN
C) MAXIMUM D) MAXI
 
Answer & Explanation Answer: A) MAX

Explanation:

MAX command is used to return maximum value from result setMAX 

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Job Role: Database Administration

Q:

Can’t update primary table’s primary key if row being modified has related rows in secondary table once referential integrity is enforced

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

Q:

We Can still delete a row from primary table if there are related rows in secondary table once a refferential integrity is enforced

A) TRUE B) FALSE
Answer & Explanation Answer: B) FALSE

Explanation:

Can’t delete a row from primary table if there are related rows in secondary table.

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

Q:

Breaking of relationships is allowed once referential integrity on a database is enforced

A) TRUE B) FALSE
Answer & Explanation Answer: B) FALSE

Explanation:

Breaking of relationships is prevented once referential integrity on a database is enforced

Report Error

View Answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

Q:

STUFF and REPLACE are used to replace characters in a string

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

They both are used to replace characters in a string

Report Error

View Answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

Q:

The interest on Rs.750 for 2yrs is the same as the True Discount on Rs.960 due 2yrs hence . If the rate of interest is same in both cases,it is:

A) 12% B) 14%
C) 15% D) 16
 
Answer & Explanation Answer: B) 14%

Explanation:

S.I on Rs.750= T.D on Rs. 960 

This means P.W of Rs. 960 due 2 years hence is Rs.750 

Therefore , T.D= Rs. (960 - 750) = Rs. 210 

Thus, S.I on Rs. 750 for 2 years is Rs. 210 

Rate =[ (100 x 210) / (750 x 2) ] % = 14%

Report Error

View Answer Report Error Discuss

Filed Under: True Discount

Q:

What is the difference between a Local and a Global temporary table?

Answer

Local :


Only available to the current Db connection for current user and are cleared when connection is closed.


Multiple users can’t share a local temporary table.


 


Global:


Available to any connection once created. They are cleared when the last connection is closed.


Can be shared by multiple user sessions

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

Q:

The True discount on Rs1760 due after a certain time at 12% per annum is Rs160. The time after which it is due is?

A) 15months B) 5months
C) 12months D) 10months
 
Answer & Explanation Answer: D) 10months

Explanation:

P.W = Rs. (1760 - 160) = Rs.1600  

S.I on Rs.1600 at 12% is Rs. 160 

Time = (100 x 160)/(1600 x 12)  = 5/6 years = (5/6) x 12 months = 10 months

Report Error

View Answer Report Error Discuss

Filed Under: True Discount