SEQUELVERSE

BLOB in SQL stands for?

•  Binary Large Object

  
  

• Big Logic Object

• Binary Logic Object

  
  

• None of these.

Which data type of SQL is used to store a JSON object?

• NVarchar

• BLOB

• Char

• Int

SQL database follows which of the following principles?

• AGILE

• ACID

• SQL

• DBMS

What is the difference if we truncate a table and if we drop a table?

• In both cases, the table is deleted.

• In both cases, the data is deleted.

• In truncate, the data is deleted and in drop the whole table is deleted.

• In truncate, the table is deleted while when the table is dropped the data is  deleted.

Below are some constraint classes of SQL given. Find the one which is not a constraint class in SQL.

• UNIQUE

• NOT NULL

• IFNULL

• NULL

Which of the following is not a built-in function in SQL?

• DATE_ADD( )

• DATE_SUB( )

• DATE_DIFF( )

• DATE_FORMAT( )

Which SQL constraint do we use to set some value to a field whose value has not been added explicitly?

• UNIQUE

• NOT NULL

• DEFAULT

• CHECK

Which of the following allows you to uniquely identify a tuple?

• Schema

• Attribute

• Super Key

• Domain

When the SQL query is executed the result is?

• A blank screen

• A table

• A row

• All of these

Which of the following is true about a cursor in SQL?

• The cursor can perform all the CRUD operations.

• It is read-only.

• Cursors are objects of the query.

• Cursors are created automatically.