Database Administration Questions


Q:

80% of 900 + 162 x 4 x ? = 113 - 99

A) 0.5 B) 1
C) 4 D) 0
 
Answer & Explanation Answer: A) 0.5

Explanation:

80x900/100 + 256 x 4 x ? = 1331 - 99

720 + 1024 x ? = 1232

? = 1232 - 720/1024

? = 512/1024 = 0.5

? = 0.5 

Report Error

View Answer Report Error Discuss

Filed Under: Percentage
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

11 6603
Q:

Wince : Pain :: Prostration : ?

A) Frustration B) Submissiveness
C) Strained D) Discomfiture
 
Answer & Explanation Answer: B) Submissiveness

Explanation:

First is the sigh of the second.

Hence, Wince : Pain :: Prostration :Submissiveness.

Report Error

View Answer Report Error Discuss

Filed Under: Analogy
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

4 6591
Q:

Ishikha got married 9 years ago. Today her age is 4/3 times her age at the time of marriage. At present her daughter’s age is one-sixth of her age. What was her daughter’s age three years ago?

A) 4 years B) 3 years
C) 2 years D) 1 year
 
Answer & Explanation Answer: B) 3 years

Explanation:

Let Ishika and her daughter present ages be p and q

 From the given data, 

p = 4/3(p - 9)

 => p = 36 years 

Hence, Ishika's present age = 36 years and

Her daughter's present age = 1/6 x 36 = 6 years 

Now, required her daughter’s age three years ago = 6 - 3 = 3 years.

Report Error

View Answer Report Error Discuss

13 6582
Q:

I am the first on Earth, the second in Heaven. I appear two times in a week you can only see me once in a year. Although I am in the middle of the sea, l am not found in month, but l am in February, June, September, October, November & December.

Who am I?

Answer

The letter 'E'.


As of the above given data,


It is in the 1st place in Earth, 2nd in Heaven and in the middle of the Sea.


It appears once in a Year and twice in a Week.


It is present in February, June, September, October, November & December.


But not in the Month.


 


Hence, it is the letter 'E'.

Report Error

View answer Workspace Report Error Discuss

18 6578
Q:

Which dml command is used in conjunction with @@identity?

A) INSERT and UPDATE B) UPDATE and DELETE
C) SCOPE_IDENTITY and IDENT_CURRENT D) Commit and rollback
 
Answer & Explanation Answer: C) SCOPE_IDENTITY and IDENT_CURRENT

Explanation:

Using automatically incrementing IDENTITY columns is very popular with database developers. You don’t need to explicitly calculate unique surrogate keys when inserting new data, the IDENTITY column functionality does that for you. The IDENTITY feature also allows you to specify useful Seed and Increment properties. When you use an INSERT statement to insert data into a table with an IDENTITY column defined, SQL Server will generate a new IDENTITY value.

 

You can use the @@IDENTITY variable and the SCOPE_IDENTITY and IDENT_CURRENT functions to return the last IDENTITY value that has been generated by SQL Server. This is very useful when you need to return the key for the row that has just been inserted, back to the caller.

Report Error

View Answer Report Error Discuss

9 6559
Q:

Solve this logical Math puzzle?

logical_thinking_puzzle1536132282.jpg image

Answer

Let that something be 'x'


From the given data,


x + x/5 = 21


5x + x/5 = 21


6x = 21 x 5


=> x = 17.5


 


Hence, that something is x = 17.5.

Report Error

View answer Workspace Report Error Discuss

9 6540
Q:

12 as a percentage?

A) 50% B) 5%
C) 0.5% D) 0.05%
 
Answer & Explanation Answer: A) 50%

Explanation:

1/2 as a percentage means

1/2 = 0.5 in decimal

Now, in percentage means 0.5 x 100% = 50%.

Report Error

View Answer Report Error Discuss

9 6528
Q:

Which value is equal to 5% of 1,500?

A) 35 B) 55
C) 75 D) 45
 
Answer & Explanation Answer: C) 75

Explanation:

In the question it is asked for 5% of 1500

5 x 1500/100 = 15 x 5 = 75.

 

Hence, 5% of 1,500 is equal to 75.

Report Error

View Answer Report Error Discuss

10 6524