Database Administration Questions


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 19948
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 19924
Q:

Find the next number in the given number series?

2, 19, 0, 21, –2, ?

A) 23 B) 25
C) 27 D) 29
 
Answer & Explanation Answer: A) 23

Explanation:

The given number series 2, 19, 0, 21, –2, ? follows a pattern,

2

2 + 17 = 19

19 - 19 = 0

0 + 21 = 21

21 - 23 = -2

-2 + 25 = 23

 

Hence, the next number in the series is 23.

Report Error

View Answer Report Error Discuss

2 19890
Q:

Find the next number in the sequence?

28, 16, 28, 76, 274

A) 1233 B) 1243
C) 1256 D) 1276
 
Answer & Explanation Answer: B) 1243

Explanation:

Given number sequence is 28, 16, 28, 76, 274

Here the sequence follows a pattern that

28

28 x 0.5 + 2 = 14 + 2 = 16

16 x 1.5 + 4 = 24 + 4 = 28

28 x 2.5 + 6 = 70 + 6 = 76

76 x 3.5 + 8 = 266 + 8 = 274

274 x 4.5 + 10 = 1233 + 10 = 1243

 

Hence, the next number in the given number sequence is 1243.

Report Error

View Answer Report Error Discuss

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

1 19736
Q:

Join Our Whatsapp Group For Competitive Exams - Sawaal

Answer

In this Whatsapp group for competitive exams, you can get daily updates about Aptitude, Reasoning, General Knowledge, Current Affairs, Puzzles, Certfications, Interviews, Exams Schedules, etc... In addition you can ask your questions to get answers with tricks and tips.


 


Click Here To Join This Whatsapp Group


 


whatsapp_group_for_competitive_exams1541477851.jpg image


 


Join our Best General Knowledge (GK) Whatsapp Group here.

Report Error

View answer Workspace Report Error Discuss

157 19646
Q:

What is the Study of human beauty called?

A) Argology B) Kalology
C) Agrostology D) Oncology
 
Answer & Explanation Answer: B) Kalology

Explanation:

The Study of human beauty and the ways in which beauty influences the society is called as Kalology.

 

What_is_the_Study_of_human_beauty_called1556276841.jpg image

      • This study is focused primarily on human attractiveness, rather than the broader field of aesthetics.

 

      • Opposite of beauty is Ugly.
Report Error

View Answer Report Error Discuss

Filed Under: General Awareness
Exam Prep: TOEFL , GRE , GATE , CAT , Bank Exams , AIEEE
Job Role: Database Administration , Bank PO , Analyst

66 19430
Q:

Man : Biography :: Nation : ?

A) History B) Leader
C) Story D) Nationalism
 
Answer & Explanation Answer: A) History

Explanation:

Detailed description of a man's life is Biography.

Similarly, detailed description of a Nations is called History.

Report Error

View Answer Report Error Discuss

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

42 19280
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

39 19139