DBMS and SQL Quiz 5

DBMS and SQL Quiz 5

Which of the following is not the part of Select statement

Which of the following language, protocol or standard was designed to become a standard protocol for sending all type of messages using any protocol?

Which of the following is true for mapping a super or sub type relationship?

Which of the following is true about TCP or UDP for a database connectivity over the Internet?

Which of the following statement(s) best describe the rightful purpose of SQL?

Which of the following statement is correct about SQL Server transaction isolation level? This level places and holds locks on all rows that are read.

In a database, data is stored in worksheets having columns and rows.

JDBC is the acronym of:

Clustering and denormalization can work effectively to minimize the data access time for small records.

“FOR XML EXPLICIT” instructs SQL Server to place the values of the table columns as attributes in the resulting XML document.