Interview Questions - Study24x7
Social learning Network

Warning: include(./views/auth.php): failed to open stream: Permission denied in /var/www/html/live/loginRightSlider.php on line 18

Warning: include(): Failed opening './views/auth.php' for inclusion (include_path='.:/usr/share/php') in /var/www/html/live/loginRightSlider.php on line 18
interviewquestions Cover image
interviewquestions
Interview Questions

  • Warning: Use of undefined constant Followers - assumed 'Followers' (this will throw an Error in a future version of PHP) in /var/www/html/live/makepage.php on line 1760
    Followers
  • Latest Feeds
  • Articles
  • Question
  • Course
  • About
  • Review
Interests
Java Technologies Digital Marketing Databases Mobile Technologies
See more
Articles
Question
Course
About
Review
Gallery
Interview Questions
45 followers study24x7 01 Jan 1970 05:30 AM 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

Computer Programming
Like Comment Share
study24x7
Write a comment
Interview Questions
45 followers study24x7 01 Jan 1970 05:30 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

Databases Web Development
Like | 1 Comment Share
study24x7
Write a comment
Interview Questions
45 followers study24x7 01 Jan 1970 05:30 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.

Java Technologies Web Development
Like | 1 Comment Share | 2
study24x7
Write a comment
Interview Questions
45 followers study24x7 01 Jan 1970 05:30 AM 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

Databases
Like | 2 Comment Share | 2
study24x7
Write a comment
Interview Questions
45 followers study24x7 01 Jan 1970 05:30 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.

Databases Web Development
Like | 1 Comment Share
study24x7
Write a comment
Interview Questions
45 followers study24x7 01 Jan 1970 05:30 AM 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.

Databases Web Development
Like | 3 Comment Share | 1
study24x7
Write a comment
Interview Questions
45 followers study24x7 01 Jan 1970 05:30 AM 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.

Databases Web Development
Like | 1 Comment Share | 1
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
❮ ❯