COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
False
|
|
|
True
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -SQL statements can be entered on one or many lines. Keywords cannot be split across lines or abbreviated. Clauses are usually placed on separate lines for readability and ease of editing. Tabs and indents can be used to make code more readable.
Detailed explanation-2: -Push and hold the shift key. While doing that, push and hold the alt key, so you have the shift and alt held down right now. Then push the up arrow to move up in the list.
Detailed explanation-3: -If you don’t need to omit any rows, you can use SQL Server’s TOP clause to limit the rows returned. It is placed immediately after SELECT. The TOP keyword is followed by integer indicating the number of rows to return. In our example, we ordered by price and then limited the returned rows to 3.
Detailed explanation-4: -SQL Server Boolean So, a BIT field can be used for booleans, providing 1 for TRUE and 0 for FALSE. CREATE TABLE testbool ( sometext VARCHAR(10), is checked BIT ); This means you can insert either a 1 (for TRUE) or 0 (for FALSE) into this column.