Database Administration Questions


Q:

The capacity to change the conceptual schema without having to change external schemas or application programs is called

A) Physical Data Independence B) Logical Data Independence
C) Both A and B D) None
 
Answer & Explanation Answer: B) Logical Data Independence

Explanation:

LDI is the capacity to change the conceptual schema without having to change external schemas or application programs.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

0 3983
Q:

6 B in an O?

A) 6 books in an order B) 6 balls in an over
C) 6 bats in an odd D) None of the above
 
Answer & Explanation Answer: B) 6 balls in an over

Explanation:

6 b in an o means 6 balls in an over in cricket.

Report Error

View Answer Report Error Discuss

4 3981
Q:

Manisha went to shop with certain amount, with which she can buy 50 Chacobar or 40 Fivestar. She uses 10% amount for petrol and out of the remaining balance, she purchases 20 Fivestar and some Chacobar. Find the number of Chacobar she can buy?

A) 20 B) 24
C) 26 D) 28
 
Answer & Explanation Answer: A) 20

Explanation:

Let the total amount be 200 {L.C.M of 40 and 50}

Chacobar C.P. = 200/50 = 4

Fivestar C.P = 200/40 = 5

Remaining Money after petrol = [200 - 200×10%] = 180

Remaining money after buying fivestars = [180 - 20×5] = 80

So number of Chacobar she can buy = 80/4 = 20

Report Error

View Answer Report Error Discuss

17 3958
Q:

Which Indian city is named after the snake Anantha of Lord Vishnu?

A) Trivandrum B) Tiruchirappalli
C) Tanjavore D) Vellore
 
Answer & Explanation Answer: A) Trivandrum

Explanation:

Thiruvananthapuram also known as Trivandrum, is the capital and the largest city of the Indian state of Kerala is named after the snake Anantha of Lord Vishnu.

Report Error

View Answer Report Error Discuss

16 3957
Q:

What's the difference between GET() and POST() method?

Answer

We can send 1024 bytes utilizing GET() yet POST() can exchange extensive measure of information and POST is the protected strategy than GET technique .

Report Error

View answer Workspace Report Error Discuss

Subject: PHP
Job Role: Database Administration

1 3949
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

6 3936
Q:

The command to eliminate a table from a database is

A) REMOVE TABLE CUSTOMER; B) UPDATE TABLE CUSTOMER;
C) DELETE TABLE CUSTOMER; D) DROP TABLE CUSTOMER;
 
Answer & Explanation Answer: D) DROP TABLE CUSTOMER;

Explanation:

The SQL DROP TABLE statement is used to remove a table definition and all data, indexes,...

Report Error

View Answer Report Error Discuss

4 3916
Q:

In latest generation computers, the instructions are executed

A) Sequentially only B) Parallelly only
C) Both sequentially and parallelly D) None of the above
 
Answer & Explanation Answer: C) Both sequentially and parallelly

Explanation:

In_latest_generation_computers,_the_instructions_are_executed1556257673.jpg image

 

In latest generation computers, the instructions are executed both sequencially and parallelly.

Report Error

View Answer Report Error Discuss

3 3900