Database - Sql - Sql Test

Test Instructions :

1. The Test is 1hr duration.
2. The Test Paper consists of 30 questions. The maximum marks are 30.
3. All the questions are multiple choice question type with three options for each question.
4. Out of the three options given for each question, only one option is the correct answer.
5. Each question is allotted 1 mark for each correct response.
6. 0.25 will be deducted for incorrect response of each question.
Start Test

   Time Left : 00 : 30    : 00

Sometimes the expression "select count(*)" will return fewer rows than the expression "select count(value)".

  

  

Which of the following file extension is a valid MyISAM file extension?

  

  

  

  

How much character are allowed to create database name?

  

  

  

  

MySql | Which of the following is available in MySQL:

  

  

  

  

  

Which of these commands will delete a table called XXX if you have appropriate authority:

  

  

  

  

What MySQL property is used to create a surrogate key in MySQL?

  

  

  

  

What does SQL stand for?

  

  

  

  

Which command is used for showing current date and time in Mysql command line tool?

  

  

  

  

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

  

  

  

  

In a SELECT with a GROUP BY clause, a WHERE clause, and a HAVING clause, the WHERE conditions are applied before the HAVING conditions.

  

  

  

  

Which of the following can add a row to a table?

  

  

  

  

Which command is used on Mysql command line tool to return to window command shell?

  

  

  

  

MySQL comes with as standard with client libraries for:

  

  

  

  

With SQL, how can you insert a new record into the "Persons" table?

  

  

  

USE keyword is used to select a ___________

  

  

  

  

The program called mysql is

  

  

  

  

  

MySQL runs on which operating systems?

  

  

  

  

Can joins be nested?

  

  

Internally information is held in tables. Which of these is NOT a valid format:

  

  

  

  

  

The ............. statement is used to delete a table.

  

  

  

  

Which SQL keyword is used to sort the result-set?

  

  

  

  

Which of these is not a valid name for a column

  

  

  

  

Which of these field types would be best to hold a .jpg image?

  

  

  

  

If you want to undo a GRANT, you should use

  

  

  

  

  

What's the difference between the DESCRIBE and SHOW FIELDS FROM commands?

  

  

  

On executing DELETE command, if you get an error "foreign key constraint" what does it imply?

  

  

  

  

With SQL, how can you return the number of records in the "Persons" table?

  

  

  

  

What will happen at the end of the following sequence of SQL commands? BEGIN TRANSACTION DELETE FROM MYTABLE WHERE ID=1 DELETE FROM OTHERTABLE ROLLBACK TRANSACTION

  

  

  

  

  

Which of the following is used to delete an entire MYSQL database?

  

  

  

  

Given an employees table as follows:   emp_id emp_name 1 Brush 2 Jerrin  what value will be return by below query ? Select count(*) from employees  

  

  

  

  

Note:
  • Click the 'Submit Test' button given in the bottom of this page to Submit your answers.
  • Test will be submitted automatically if the time expired.
  • Don't refresh the page.