Interview Questions - Study24x7
Social learning Network
study24x7

Default error msg

Login

New to Study24x7 ? Join Now
Already have an account? Login
interviewquestions Cover image
interviewquestions
Interview Questions
  • Followers
  • Latest Feeds
  • Articles
  • Question
  • Course
  • About
  • Review
Interests
Java Technologies Digital Marketing Databases Mobile Technologies
See more
44 followers study24x7 18 Apr 2021 11:38 PM study24x7 study24x7

There are total 6 eggs:Two i broke, Two i fried & Two i ate.


How many eggs were left?

A

0

B

2

C

4

D

6

study24x7
Write a comment
44 followers study24x7 22 Dec 2020 10:36 AM study24x7 study24x7

Query 1 : Select DISTINCT(id) form table; Query 2: Select id from table group by id;

A

Both Queries are wrong

B

Both will generate same result

C

Query 1 is wrong & Query 2 is correct

D

Query 2 is wrong & Query 1 is correct

study24x7
Write a comment
44 followers study24x7 12 Mar 2020 11:46 AM study24x7 study24x7

Dare to Answer....
How cookie and session are related to each other?

Give your answer in comment..... Waiting for the best answer.

study24x7
Write a comment
44 followers study24x7 30 Jan 2020 12:52 PM study24x7 study24x7

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
44 followers study24x7 18 Sep 2019 10:04 AM study24x7 study24x7

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
44 followers study24x7 22 Aug 2019 03:13 PM study24x7 study24x7

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
44 followers study24x7 22 Aug 2019 02:58 PM study24x7 study24x7

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
2 Ratings
5 study24x7
 
2.0
4 study24x7
 
0.0
3 study24x7
 
0.0
2 study24x7
 
0.0
1 study24x7
 
0.0
Related Pages

TET

66 followers