Logo

Mysql Questions Set 17:

Quiz Mode

 Numbers prefixed with ‘0x’ are in base __________ 

1
2
3
4

Solution:

Which keyword used with UNION retains duplicate rows? 

1
2
3
4

Solution:

For which of the following are triggers not supported? 

1
2
3
4

Solution:

Which disk data does the FILES table in the INFORMATION_SCHEMA store? 

1
2
3
4

Solution:

 The option that is necessary to compile a C program having math functions is _____________ 

1
2
3
4

Solution:

Which type of function is ROW_NUMBER?

1
2
3
4

Solution:

The general term for information about databases and the objects in MySQL is _________ 

1
2
3
4

Solution:

 

What is abc in the following statement?

  

SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');

1
2
3
4

Solution:

  What is the isolation property of transactions? 

1
2
3
4

Solution:

  

What happens if the file is not found in the following Python code?

a=False
while not a:
   try:
       f_n = input("Enter file name")
       i_f = open(f_n, 'r')
   except:
       print("Input file not found")


 

1
2
3
4

Solution: