Database Administration Questions


Q:

What's the difference between Session and Cookie?

Answer

The principle distinction amongst sessions and cookies is that sessions are put away on the server, and cookies are put away on the client's PCs in the content record position. Cookies can not hold various variables,But Session can hold numerous variables.We can set expiry for a cookie,The session just stays dynamic the length of the program is open.Users don't have admittance to the information you put away in Session,Since it is put away in the server. Session is mostly utilized for login/logout reason while cookies utilizing for client movement following.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP
Job Role: Database Administration

6 10427
Q:

Prophet of New India is

A) Dayanand Saraswathi B) Sri Ramakrishna
C) Swamy Vivekananda D) Raja Ram Mohan Roy
 
Answer & Explanation Answer: B) Sri Ramakrishna

Explanation:

Sri Ramakrishna is called as the Prophet of New India.

Sri Ramakrishna (1836-86) mostly known as Ramakrishna Paramhamsa was a spiritual genius now respected in India and abroad as an outstanding saint of our times. His life and thoughts represents the highest and best of modern Hindu philosophy and practice.

Reverence and admiration for him amongst Bengali elites led to the formation of the Ramakrishna Mission by his chief disciple Swami Vivekananda. His devotees look upon him as an incarnation or Avatara of the formless Supreme Brahman as described in the Vedanta while some devotees see him as an avatara of Vishnu.

Report Error

View Answer Report Error Discuss

20 10403
Q:

Which of the following is true about cloud computing?

A) Cloud computing has brought about a drop in hardware and software sales, while augmenting service revenues B) You can access your data from any computer in the world, as long as you have an Internet connection.
C) Both A & B D) It's always going to be less expensive and more secure than local computing.
 
Answer & Explanation Answer: C) Both A & B

Explanation:
Report Error

View Answer Report Error Discuss

34 10332
Q:

What is the difference between mysql_connect and mysql_pconnect?

Answer

There is a decent page in the php manual on the subject, in short mysql_pconnect() makes a persevering association with the database which implies a SQL join that don't close when the execution of your script closes. mysql_connect()provides just for the database new association while utilizing mysql_pconnect , the capacity would first attempt to locate a (relentless) connection that is as of now open with the same host, username and password. On the off chance that one is found, an identifier for it will be returned as opposed to opening another connection... the connection with the SQL server won't be terminated when the execution of the script ends. Rather, the link will stay open for future use.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP
Job Role: Database Administration

4 10317
Q:

The cricket match proved to be a big draw. (Idioms & Phrases)

A) a huge attraction B) a game without any result
C) a keen contest D) a lovely spectacle
 
Answer & Explanation Answer: A) a huge attraction

Explanation:

Here it is an idiom that says The cricket match proved to be a big draw means it stands as a huge attraction.

Report Error

View Answer Report Error Discuss

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

2 10267
Q:

Computer storage units smallest to largest?

Answer

The smallest unit of data storage in a computer is called Bit (Binary Digit). Half a byte (four bits) is called a Nibble.


 


1 bit (binary digit) = the value of 0 or 1


8 bits = 1 byte


1024 bytes = 1 kilobyte


1024 kilobytes = 1 megabyte


1024 megabytes = 1 gigabyte


1024 gigabytes = 1 terabyte


1024 terabytes = 1 petabyte


 


Hence, Computer storage units smallest to largest i.e, in ascending order is


 1 bit  <  1 byte  <  1 KB  <  1 MB  <  1 GB  <  1TB  <  1 PB.

Report Error

View answer Workspace Report Error Discuss

9 10237
Q:

Buses start from a bus terminal with a speed of 20 km/hr at intervals of 10 minutes. What is the speed of a man coming from the opposite direction towards the bus terminal if he meets the buses at intervals of 8 minutes?

A) 5 kmph B) 6 kmph
C) 7.5 kmph D) 8 kmph
 
Answer & Explanation Answer: A) 5 kmph

Explanation:

Let p be the speed of man in kmph

According to the given data in the question,

Distance travelled by bus in 10 min with 20 kmph == Distance travelled by man in 8 min with (20 + p) kmph in opposite direction

=> 20 x 10/60 = 8/60 (20 + p)

=> 200 = 160 + 8p

=> p = 40/8 = 5 kmph.

Report Error

View Answer Report Error Discuss

14 10218
Q:

Expansion cards are inserted into

A) Peripheral Devices B) Pegs
C) Slots D) The back of the computer
 
Answer & Explanation Answer: C) Slots

Explanation:

In computing, the expansion card or board or accessory card is a printed circuit board that can be inserted into an electrical connector or expansion slot, on a computer motherboard, to add functionality to a computer system via the expansion bus.

Report Error

View Answer Report Error Discuss

13 10213