Correct Answer: A primary key is a special relational database table column or combination of columns designated to uniquely identify all table records That is, A primary key is a column or set of columns in a table that uniquely identifies tuples (rows) in that table A primary key, also called a Primary Keyword Main Features Primary key are :: It must contain a unique value for each row of data It cannot contain null values

Correct Answer: SCOPE_IDENTITY and IDENT_CURRENT

Explanation:

Using automatically incrementing IDENTITY columns is very popular with database developers. You don?t need to explicitly calculate unique surrogate keys when inserting new data, the IDENTITY column functionality does that for you. The IDENTITY feature also allows you to specify useful Seed and Increment properties. When you use an INSERT statement to insert data into a table with an IDENTITY column defined, SQL Server will generate a new IDENTITY value.

 

You can use the @@IDENTITY variable and the SCOPE_IDENTITY and IDENT_CURRENT functions to return the last IDENTITY value that has been generated by SQL Server. This is very useful when you need to return the key for the row that has just been inserted, back to the caller.

Correct Answer: 12

Explanation:

Maximim number of triggers that can be applied to a single table is 12

Correct Answer: Candidate Key ? A Candidate Key can be any column or a combination of columns that can qualify as unique key in database There can be multiple Candidate Keys in one table Each Candidate Key can qualify as Primary Key Primary Key ? A Primary Key is a column or a combination of columns that uniquely identify a record Only one Candidate Key can be Primary Key One needs to be very careful in selecting the Primary Key as an incorrect selection can adversely impact the database architect and future normalization For a Candidate Key to qualify as a Primary Key, it should be Non-NULL and unique in any domain

Correct Answer: A database that contains multiple tables related through common fields A common field is a field of data that is shared among all forms in a database Without them, it would be difficult and/or time-consuming to create other forms

Correct Answer: Compilation and output of "Not equal! 10"

Explanation:

The output will be "Not equal! 10". Please note that && is logical AND operator. If first operand before (&&) is false then the other operand will not be evaluated. This illustrates that the Output +=10 calculation was never performed because processing stopped after the first operand was evaluated to be false. If you change the value of b1 to true, processing occurs as you would expect and the output would be "We are equal 20".

Correct Answer: TRUE

Explanation:

The code segments B and D will compile without any error. A is not a valid way to construct a StringBuffer, you need to create a StringBuffer object using "new". B is a valid construction of a Boolean (any string other than "true" or "false" to the Boolean constructor will result in a Boolean with a value of "false"). C will fail to compile because the valid range for a byte is -128 to +127 (i.e., 8 bits, signed). D is correct, 0x1234 is the hexadecimal representation in java. E fails to compile because the compiler interprets 1.2 as a double being assigned to a float (down-casting), which is not valid. You either need an explicit cast, as in "(float)1.2" or "1.2f", to indicate a float.

Correct Answer: Executive plan can be defined as: * SQL Server caches collected procedure or the plan of query execution and used thereafter by subsequent calls * An important feature in relation to performance enhancement * Data execution plan can be viewed textually or graphically

Correct Answer: DML

Correct Answer: Tabular structure

Explanation:

Data is organized in the form of row and columns, thus it is in tabular structure.