Database Administration Questions


Q:

Which of the following is not a valid escape code?

A) " B) \
C) ' D) =
 
Answer & Explanation Answer: D) =

Explanation:

The valid escape codes in programming languages are ', ", \, n, or t are the valid escape codes. 

 

For example, the sequence \n usually represents a newline, while the escape sequence \\ represents a backslash, \t usually represents a newtab.

Report Error

View Answer Report Error Discuss

80 31143
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

105 30589
Q:

The calendar for the year 2018 will be the same for the year

A) 2023 B) 2027
C) 2029 D) 2022
 
Answer & Explanation Answer: C) 2029

Explanation:

How to find the years which have the same Calendars : 

 Leap year calendar repeats every 28 years. 

Here 28 is distributed as 6 + 11 + 11.

  

Rules:

a) If given year is at 1st position after Leap year then next repeated calendar year is Given Year + 6.

 b) If given year is at 2nd position after Leap year then next repeated calendar year is Given Year + 11.

 c) If given year is at 3rd position after Leap year then next repeated calendar year is Given Year + 11

 

Now, the given year is 2018

We know that 2016 is a Leap year.

2016  2017  2018  2019  2020

 LY    1st     2nd    3rd    LY

Here 2018 is at 2 nd position after the Leap year.

According to rule ( b) the calendar of 2018 is repeated for the year is 2018 + 11 = 2029.

Report Error

View Answer Report Error Discuss

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

99 30192
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

30 29420
Q:

5 C in an OF?

A) 5 Cards in an Old Fan B) 5 Circles in an Olympic Flag
C) 5 Colors in an Old Football D) 5 Colors in an Old Flag
 
Answer & Explanation Answer: B) 5 Circles in an Olympic Flag

Explanation:

5 C in an OF denotes 5 Circles in an Olympic Flag.

These are riddles of type

12 S of the Z

52 W in a Y.

Report Error

View Answer Report Error Discuss

192 28936
Q:

Brightness of bulb depends on voltage or current?

A) Current B) Voltage
C) Both A & B D) None
 
Answer & Explanation Answer: C) Both A & B

Explanation:

Brightness of bulb depends on both voltage and current. The brightness depends on power.

Since we know that  Power (P) = Voltage x Current = V I

So whether you increase the current or the voltage the brightness will increase.

 

Example Illustration:

 If you connect a long bulb and a round bulb in series, the long bulb glows but the round bulb does not. Both of them have the same current flowing through them (they are in series) but the long bulb has a greater voltage across it because it has more resistance (even though V= IR is not obeyed exactly, voltage drop does depend on the resistance). If you connect a round bulb and a long bulb in parallel, however, it is the round bulb that is brighter because now the voltage across both bulbs is the same but the current is larger through the round bulb (smaller resistance).

 

Hence, the brightness of a bulb depends on power i.e, both voltage and current.

Report Error

View Answer Report Error Discuss

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

31 28864
Q:

The First Mechanical Computer Designed by Charles Babbage was called?

A) Super Computer B) Abacus
C) Calculator D) Analytical Engine
 
Answer & Explanation Answer: D) Analytical Engine

Explanation:

Computer was invented by Charles Babbage.

The First Mechanical Computer Designed by Charles Babbage, a British mathematician was called as Analytical Engine which resembles today's modern machines  between 1833 and 1871.

Report Error

View Answer Report Error Discuss

145 28339
Q:

52 C in a P?

Answer

52 C in a P represents 52 Cards in a Pack.


Similar to 


12 S of the Z 


5 C in an OF

Report Error

View answer Workspace Report Error Discuss

67 27091