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

One of the early proponents of relational database who laid down many of the principles we use to this day was:

  

  

  

  

  

The "father" of MySQL is

  

  

  

  

A NULL value is treated as a blank or 0.

  

  

  

MySQL runs on which operating systems?

  

  

  

  

How do I find out all databases starting with ‘test to which I have access to?

  

  

  

  

Which SQL statement is used to extract data from a database?

  

  

  

  

  

Which SQL statement is used to insert a new data in a database?

  

  

  

  

What is DCL?

  

  

  

  

The “Mysql command line tool” formats are bounded by

  

  

  

  

Which of the following commands should be used to create a database named “student”?

  

  

  

  

What is Table?

  

  

  

  

What does SQL stand for?

  

  

  

  

The result of a SELECT statement can contain duplicate rows.

  

  

  

Which statement is used to access an existing Database?

  

  

  

  

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 not a valid aggregate function?

  

  

  

  

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

  

  

  

  

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

  

  

  

  

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

  

  

  

  

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

  

  

  

  

With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

  

  

  

Can I call a trigger directly called from an application?

  

  

The main MySQL program that does all the data handling is called?

  

  

  

  

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

  

  

  

Which of these is not a valid name for a column

  

  

  

  

If you're writing a client using the C language API, your source code should include the following line at the top:

  

  

  

  

How can we get the number of records or rows in a table?

  

  

  

  

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

  

  

  

  

How many TRIGGERS are allowed in MySql 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.

  

  

  

  

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.