Consider the following two tables:

1.  customers( customer_id, customer_name)
2.  branch ( branch_id, branch_name )

What will be the output if the following query is executed:

    Select *, branch_name from customers,branch

Select the correct option:

Which of the following is false with regards to sp_help?

Which of the following is the syntax for creating an Index?

Study the situation described below and identify the nature of relationship? Each student can enroll into more than one class. Each class can accommodate more than one student.

A company has the following departments: marketing, Designing, production, Packing What will be the result of the following query? select * from table where department < 'marketing';

User defined data type columns can be designated with ROWGUIDCOL.

What is returned by NULLIF if the two expressions that it compares are NOT equal?

An identifier denoting a global temporary object in SQL Server 2008 starts with a ______ sign.

What is the maximum value for the sum of the values of MIN_CPU_PERCENT and MIN_MEMORY_PERCENT for all the resource pools of SQL Server?

The Server Audit object and the Server Audit Specification object of SQL Server 2008 share a __________ relationship.