Interview Questions - Study24x7
study24x7
Interview Questions
  • followers
  • Latest Feeds
  • Question
  • Course
  • About
  • Review
Interests
Java Technologies Digital Marketing Databases Mobile Technologies ...

In Which order below keywords will come in Single Query?
1. LIMIT
2. WHERE
3. GROUP BY
4. ORDER BY
5. HAVING

A

2 -> 3 -> 1 > 4 -> 5

B

2 -> 3 -> 5 -> 4 -> 1

C

3 -> 5 -> 2 -> 4 -> 1

D

2 -> 3 -> 4 -> 1 -> 4

study24x7
Write a comment

Which option is correct for "SQL_BIG_SELECTS" in Mysql?

A

Used when we are expecting the huge numbers rows in resultset.

B

Prevent executing query which scans more than defined number of rows.

C

It is not a predefined keyword of Mysql.

D

It does not work on join queries.

study24x7
Write a comment

Mysql:
What does "i_am_a_dummy" flag do?

A

It returns the successful response but does not insert record in Table.

B

It creates dummy data in DB.

C

It prevent the Update & Delete query from execution without where clause.

D

It helps in maintaining the versions of records in table.

study24x7
Write a comment

Mysql:
What is the difference between NOW() and CURRENT_DATE()?

A

NOW() shows date with time and CURRENT_DATE() shows date only.

B

NOW() shows date and CURRENT_DATE() shows date with time.

C

NOW() shows time only and CURRENT_DATE() shows date.

D

Both are same.

study24x7
Write a comment
Ratings
5.0
out of 5
1 Ratings
5 study24x7
 
1.0
4 study24x7
 
0.0
3 study24x7
 
0.0
2 study24x7
 
0.0
1 study24x7
 
0.0
Related Pages

ENGINEERING DESIGN

17 followers

Dr Jayant K Singh

22 followers

Learn Tech

68 followers

Learn Advance REASON..

127 followers

Prof S D Agashe

20 followers

aman pandey

103 followers

Learn N Share - Get ..

274 followers

Prof K L Sebastian

12 followers

Prof T V Prabhakar

10 followers

V5 Institute

154 followers

Prof Samik Nanda

9 followers

Prof V Balakrishnan ..

51 followers

Reasoning with Rizwa..

132 followers

Prof Parasuraman S

10 followers

Prof Debasish Ghose

8 followers

Prof. C. Balaj

10 followers

Prof. T.V. Ramachand..

20 followers

PROF. C. BALAJI

8 followers

Prof. S. Dasgupta

22 followers

Prof. Amitabha Ghosh..

3 followers

GSGURUMANTRA

153 followers

Maths By Uttam Sir

146 followers