Database Administration Questions


Q:

What is inheritance?

Answer

Inheritance is the ability to create new classes based on existing classes. It is useful to reuse existing code.

Report Error

View answer Workspace Report Error Discuss

0 2003
Q:

 Which of the following is the original purpose of SQL?

A) To specify the syntax and semantics of SQL data definition language B) To specify the syntax and semantics of SQL manipulation language
C) To define the data structures D) All of the above.
 
Answer & Explanation Answer: D) All of the above.

Explanation:

SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.

 

Purpose of SQL are ::

* To define the data structures

* To specify the syntax and semantics of SQL manipulation language

* To specify the syntax and semantics of SQL data definition language

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Analyst , Database Administration , IT Trainer

19 20001
Q:

The famous Rock Garden is located in which city?

A) Jaipur B) Simla
C) Lucknow D) Chandigarh
 
Answer & Explanation Answer: D) Chandigarh

Explanation:

The famous Rock Garden which is also known as Nek Chand's Rock Garden after its founder Nek Chand, a government official who started the garden secretly in his spare time in 1957 is in the city Chandigarh.

 

The Rock Garden of Chandigarh is a sculpture garden in Chandigarh, India.

Report Error

View Answer Report Error Discuss

93 22648
Q:

Fastest Shorthand Writer was

A) Dr. G. D. Bist B) J.R.D. Tata
C) J.M. Tagore D) Khudada Khan
 
Answer & Explanation Answer: A) Dr. G. D. Bist

Explanation:

Dr. G. D. Bist, Guinness Record Holder, the first-ever Ph.D. in Stenography in the world.

 

fastest_shorthand_writer_-_Dr._G_._D_._Bist_1562583195.jpg image 

 

He had achieved a highest speed of 250 w.p.m. in Shorthand.

Report Error

View Answer Report Error Discuss

485 66294
Q:

Default read write and execute permissions given to a file for owner, group and others are

A) 6-4-4 B) 6-4-2
C) 6-4-6 D) 6-6-6
 
Answer & Explanation Answer: A) 6-4-4

Explanation:

Default permissions given to a file are:

Owner - read write and execute - 6

group - write - 4

others - write - 4

Report Error

View Answer Report Error Discuss

6 5212
Q:

What is the default return value of a function?

A) int B) char
C) string D) None of the above
 
Answer & Explanation Answer: A) int

Explanation:

The default return value from a function is int. In other words, unless explicitly specified the default return value by compiler would be integer value from function.

Report Error

View Answer Report Error Discuss

3 3508
Q:

What is the difference between oracle,sql and sql server?

Answer

  • Oracle is based on RDBMS.

  • SQL is Structured Query Language.

  • SQL Server is another tool for RDBMS provided by MicroSoft


 

Report Error

View answer Workspace Report Error Discuss

2 2788
Q:

Which among the following keys are used to identify each row of the table uniquely?

A) Primary key B) Unique key
C) Partial key D) None of the above
 
Answer & Explanation Answer: A) Primary key

Explanation:

Primary key helps us to identify a row uniquely in a relation

Report Error

View Answer Report Error Discuss

2 3473