DBMS and SQL Quiz 5 DBMS and SQL Quiz 5 Which of the following is not the part of Select statementINTOFROMORDER BYINNER JOINWhich of the following language, protocol or standard was designed to become a standard protocol for sending all type of messages using any protocol?SQLSOAPSGMLADOWhich of the following is true for mapping a super or sub type relationship?The sub type primary key is assigned to each super type.The super type primary key is assigned to each sub type.There is no primary key/foreign key relationship between a super type or sub type.There is no link between the super type and sub type entities.Which of the following is true about TCP or UDP for a database connectivity over the Internet?Neither TCP and IP are needed.TCP is not needed but IP is needed.Both TCP and IP are needed.TCP is needed but IP is not needed.Which of the following statement(s) best describe the rightful purpose of SQL?To specify the syntax and semantics of SQL data definition language To specify the syntax and semantics of SQL manipulation languageTo define the data structures All of the above.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.SERIALIZABLE REPEATABLE READREAD UNCOMMITTED READ COMMITTED In a database, data is stored in worksheets having columns and rows.TRUEFALSEJDBC is the acronym of:Java Database ComponentsJava Database ConnectivityJava Database ControlNone of the above is correct.Clustering and denormalization can work effectively to minimize the data access time for small records.TRUEFALSE“FOR XML EXPLICIT” instructs SQL Server to place the values of the table columns as attributes in the resulting XML document.TRUEFALSE
