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

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

  

  

  

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

  

  

  

  

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Aru" and the "LastName" is "Sum"?

  

  

  

  

To remove duplicate rows from the result set of a SELECT use the following keyword:

  

  

  

  

Can joins be nested?

  

  

The “Mysql command line tool” format the results in which of the following format:

  

  

  

  

Transactions are used to treat sets of SQL statements atomically.

  

  

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

  

  

  

  

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

  

  

  

  

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

  

  

  

  

Can DISTINCT command be used for more than one column?

  

  

What is DCL?

  

  

  

  

How much storage space does DATETIME require?

  

  

  

  

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

  

  

  

  

MySQL supports the complete SQL99 standard

  

  

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

  

  

  

  

  

How many TRIGGERS are allowed in MySql table?

  

  

  

  

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

  

  

  

  

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

  

  

  

  

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

  

  

What is a candidate key?

  

  

  

  

Which of these is a valid call to a function (watch the spaces carefully!)

  

  

  

  

Primary Key does allow the Null Values. where as in Unique key doesn't accept the Null values.

  

  

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

  

  

  

  

A table may be joined to itself.

  

  

  

The USE command?

  

  

  

  

Commands passed to the MySQL daemon are written in.

  

  

  

  

What is Row?

  

  

  

  

Which of the following is not a MySQL Operator?

  

  

  

  

Which of these is not a valid name for a column

  

  

  

  

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.