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

Which of the following is not a character manipulation function?





A view is nothing but a ________ table or a stored query





An outer join requires each record in the two joined tables to have a matching record.





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





Which of the following ways below are the correct way to get the current date?





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





Which is the default order of sort in ORDER BY clause?



In a LIKE clause, you can ask for any 6 letter value by writing?





Which function used to get the current time in mysql?




Transactions are used to treat sets of SQL statements atomically.



SQL is not case sensitive. SELECT is the same as select.



With SQL, how do you select all the columns from a table named "Persons"?





What kind of replication is supported by the MySQL server?





Which authentications are required for login into Mysql command line tool?





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






What is Row?





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





How to view all Triggers in MySQL?





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




Which of the following is not an SQL aggregate function?






  • 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.