Database Administration Questions


Q:

In which of the following state Bandipur National Park is located?

A) Karnataka B) Andhra Pradesh
C) Himachal Pradesh D) Madhya Pradesh
 
Answer & Explanation Answer: A) Karnataka

Explanation:

Bandipur National Park is located in the state of Karnataka.

Report Error

View Answer Report Error Discuss

Filed Under: Indian Geography
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Bank PO , Database Administration , IT Trainer

7 4620
Q:

What operator tests column for the absence of data?

A) NOT operator B) IS NULL operator
C) EXISTS operator D) All of the above
 
Answer & Explanation Answer: B) IS NULL operator

Explanation:

SELECT "column_name"


FROM "table_name"


WHERE "column_name" IS NULL.

Report Error

View Answer Report Error Discuss

1 4530
Q:

Find the Missing Number Puzzle for the Given

number011517998001.jpg image

A) 8 B) 16
C) 9 D) 12
 
Answer & Explanation Answer: C) 9

Explanation:

Given

 

6 = 3 => Number of letters in SIX = 3

 

12 = 6 => Number of letters in TWELVE = 6

 

14 = 8 => Number of letters in FOURTEEN = 8

 

Similarly,

 

22 = 9 => Number of letters in TWENTY TWO = 9

 

 

 

 

 

Therefore, 22 = 9.

Report Error

View Answer Report Error Discuss

18 4516
Q:

Shamma lends Rs.40,000 to two of her friends. She gives Rs.24,000 to the first at 8% p.a. simple interest. Shamma wants to make a profit of 10% on the whole. The simple interest rate at which she should lend the remaining sum of money to the second friend is:

A) 13% B) 8.5%
C) 9.5% D) 11.25%
 
Answer & Explanation Answer: A) 13%

Explanation:

The ratio of money she lended is

24000 : 16000 = 3 : 2

Let the rate of interest be R%

 

8%                   R%
     

           10

 

3          :           2

 

R = 13%.

Report Error

View Answer Report Error Discuss

Filed Under: Profit and Loss
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration

10 4511
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

0 4498
Q:

Which planet rotates clockwise?

A) Uranus B) Saturn
C) Venus D) Earth
 
Answer & Explanation Answer: C) Venus

Explanation:

Venus is the only planet that rotates in clockwise where all other planets in the solar system rotates in anti - clockwise direction.

 

which_planet_rotates_clockwise1556602727.jpg image

Report Error

View Answer Report Error Discuss

6 4491
Q:

Which layer 4 protocol is used for a Telnet connection?

A) UDP B) IP
C) TCP D) TCP/IP
 
Answer & Explanation Answer: C) TCP

Explanation:

Telnet uses TCP at layer 4. It uses IP at layer 3. We know that Telnet uses TCP/IP protocol, but in the question, it is asked specifically at layer 4 what is used in Telnet. So it is TCP at layer4 and IP at layer 3.

Report Error

View Answer Report Error Discuss

0 4485
Q:

On simple interest an amount becomes Rs. 812 in two years and Rs. 924 in four years. What is the rate of interest on that amount?

A) 7.2% B) 8%
C) 8.5% D) 9.3%
 
Answer & Explanation Answer: B) 8%

Explanation:

We know, 

S.I = PTR/100 where P = principal amount, T = time, R = rate of interest

Here in the given data,

Interest for two years S.I = 924 - 812 = Rs. 112

Now, Principal amount P = 812 - 112 = Rs. 700 

Now,

R = S.I x 100/PT

R = 112 x 100/700 x 2

R = 11200/1400

R = 8%

 

Hence, the rate of interest R = 8%.

Report Error

View Answer Report Error Discuss

7 4471