Similar Collections

    No collections found

questions

Title
To connect strings, which function is used –

To connect strings, which function is used –

  1. CONNECT
  2. ADD
  3. COMBINE
  4. CONCAT
discuss
Which of the following is TRUE about SQL Concatenate?

Which of the following is TRUE about SQL Concatenate?

  1. It is also possible to combine more than two strings into one string.
  2. Two columns of the table may be used to store the strings that are to be combined, or they may just be stored individually without being stored into the table.
  3. When the concatenated strings are stored in separate columns of a table, they are stored in the column in which they were initially stored.
  4. All of the above
discuss
Which function is used to obtain the month from the entire data stored in a table's column?

Which function is used to obtain the month from the entire data stored in a table's column?

  1. DATE
  2. TIME
  3. MONTH
  4. DATE & TIME
discuss
In more readable form, you can retrieve the date values, using ______ function?

In more readable form, you can retrieve the date values, using ______ function?

  1. DATE
  2. DATE_FORM
  3. DATE_FORMAT
  4. DATE_VALUE
discuss
Savepoint command is used with _____ command

Savepoint command is used with _____ command.

  1. Commit
  2. Transaction
  3. Rollback
  4. None of the above
discuss
Which of the following is TRUE about Savepoint command?

Which of the following is TRUE about Savepoint command?

  1. A transaction is marked in a table by this TCL command.
  2. Imagine that you are making a long table, and you want to roll back only to a specific point in the table. You can do this with the savepoint.
  3. In order to rollback part of a table rather than the entire table, a savepoint is useful.
  4. All of the above
discuss
Select the correct syntax for Savepoint

Select the correct syntax for Savepoint.

  1. Mysql > Transaction ini;
  2. Mysql > &Savepoint;
  3. Mysql > START Transaction;
  4. Mysql > Savepoint ini;
discuss
By default, TIME data type stores time in which format?

By default, TIME data type stores time in which format?

  1. MM:HH:SS;
  2. SS:HH:MM;
  3. HH:SS:MM;
  4. HH:MM:SS;
discuss
It is possible to retrieve time in a more readable format, using which function?

It is possible to retrieve time in a more readable format, using which function?

  1. TIME
  2. TIME_FORM
  3. TIME_FORMAT
  4. TIME & DATE
discuss
Using TIME_FORMAT() function, time can be retrieved in –

Using TIME_FORMAT() function, time can be retrieved in –

  1. 12-hour format
  2. 24-hour format
  3. Both A. and B.
  4. None of the above
discuss
total MCQs: 10

MCQs

10

Views

94

Best Answers

299

Points

5