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

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

  

  

  

  

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

  

  

  

  

If an ENUM column is declared NOT NULL, its default value is the first element of the list of allowed values.

  

  

  

  

The “Mysql command line tool” formats are bounded by

  

  

  

  

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

  

  

  

  

How many distinct, different values can you hold in an enum field?

  

  

  

  

What is DCL?

  

  

  

  

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

  

  

  

  

What is DDL?

  

  

  

  

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

  

  

  

  

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

  

  

  

  

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

  

  

  

  

Mysql command line tool is used to show “how many rows are returned and how long SQL command took to execute”

  

  

  

  

What is Row?

  

  

  

  

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

  

  

  

  

  

MySQL supports the complete SQL99 standard

  

  

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

  

  

  

  

  

Transactions are used to treat sets of SQL statements atomically.

  

  

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

  

  

  

Can DISTINCT command be used for more than one column?

  

  

Which of the following is NOT supported by MySQL

  

  

  

  

A user with RELOAD priveliges can

  

  

  

  

Where is metadata stored in MySQL?

  

  

  

  

The program called mysql is

  

  

  

  

  

The USE command?

  

  

  

  

Which of the following is the correct SQL statement to use to remove rows from a table?

  

  

  

  

The result of a SELECT statement can contain duplicate rows.

  

  

  

Which SQL statement is used to update data in a database?

  

  

  

  

Which of the following is NOT available in MySQL?

  

  

  

  

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.