Database Administration Questions


Q:

Digitized information can be used by computers.

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

Explanation:

TRUE. The computers and electronic devices use digitized information which is easily understood by them.


 


Digitization is the process of converting analog signals or information of any form into a digital format that can be understood by computer systems or electronic devices. The term is used when converting information, like text, images or voices, and sounds, into binary code.

Report Error

View Answer Workspace Report Error Discuss

6 4149
Q:

Cloud computing uses Server virtualization.

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

Explanation:

Cloud computing :: 


Cloud computing is an information technology (IT) paradigm that enables ubiquitous access to shared pools of configurable system resources and higher-level services that can be rapidly provisioned with minimal management effort, often over the Internet.


 


Server virtualization :


Server virtualization is a virtualization technique that involves partitioning a physical server into a number of small, virtual servers with the help of virtualization software. In server virtualization, each virtual server runs multiple operating system instances at the same time.


cloud-computing_server_virtuaization1532503685.jpg image


 


Server virtualization is more for a good reason. It offers the potential to dramatically save space and improve server efficiency. Vendors are in fierce competition to offer the most advanced tools that they hope will earn them the virtualization crown.


 


Hence, the given statement that 'Cloud computing uses Server virtualization.' is TRUE.


 


 

Report Error

View Answer Workspace Report Error Discuss

37 4126
Q:

Grand Central Terminal Park Avenue is the world's

A) smallest railway station B) largest railway station
C) longest railway station D) None of above
 
Answer & Explanation Answer: B) largest railway station

Explanation:

Grand Central Terminal also referred to as Grand Central Station or Grand Central is the world’s largest railway station in terms of platforms in New York City with 44 platforms covering 48 acres.

Report Error

View Answer Report Error Discuss

4 4116
Q:

I shrink smaller every time I take a bath.

What am I ?

Answer

A Soap.


Yes, it gets shrinks smaller every time we take a bath.

Report Error

View answer Workspace Report Error Discuss

2 4110
Q:

One light year is approximately equal to

A) 10^12 mts B) 10^16 mts
C) 10^11 mts D) 10^13 mts
 
Answer & Explanation Answer: B) 10^16 mts

Explanation:

Light year is the unit of to express astronomical distances, that light can travel in one year. Light moves at a velocity of about 300,000 kilometers (km) each second. So in one year, it can travel about 10 trillion km. More precisely, one light-year is equal to 9,500,000,000,000 kilometers.

 

Approximately, 1 light year = 10^16 mts.

Report Error

View Answer Report Error Discuss

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

4 4107
Q:

A lady who remains unmarried

A_lady_who_remains_unmarried1553081869.jpg image

A) Bachelore B) Prissy
C) Spinster D) Anthrope
 
Answer & Explanation Answer: C) Spinster

Explanation:

A lady who remains unmarried never have a child or divorsed is called as Spinster.

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

0 4102
Q:

Which of the following describes a relational database?

A) It retrieves data related to its queries B) It provides a relationship between floats
C) It provides a relationship between integers D) It consists of separate tables or related data
 
Answer & Explanation Answer: D) It consists of separate tables or related data

Explanation:

A relational database is a digital database based on the relational model of data, a database structured to recognize relations between stored items of information. A software system used to maintain relational databases is a relational database management system.

 

Computer database in which all data is stored in Relations which (to the user) are tables with rows and columns. Each table is composed of records (called Tuples) and each record is identified by a field (attribute) containing a unique value. Every table shares at least one field with another table in 'one to one,' 'one to many,' or 'many to many' relationships. These relationships allow the database user to access the data in almost an unlimited number of ways, and to combine the tables as building blocks to create complex and very large databases.

Report Error

View Answer Report Error Discuss

36 4096
Q:

Difference between Candidate key and Primary key?

Answer

Candidate Key – A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Keys in one table. Each Candidate Key can qualify as Primary Key. 


Primary Key – A Primary Key is a column or a combination of columns that uniquely identify a record. Only one Candidate Key can be Primary Key.






        • One needs to be very careful in selecting the Primary Key as an incorrect selection can adversely impact the database architect and future normalization. For a Candidate Key to qualify as a Primary Key, it should be Non-NULL and unique in any domain.




Report Error

View answer Workspace Report Error Discuss

6 4087