Viewing 15 posts - 556 through 570 (of 819 total)
Koen Verbeeck (6/25/2012)
Small error: the select statement selects 4 columns, the answers have only 3.
BIG ERROR: I answered thinking at the first 3 columns, so that Y would return without...
June 26, 2012 at 12:59 am
tommyh (6/19/2012)
If one wants be really picky "Depends on File System" is actually the right answer.You can install 2012 on FAT32
/T
Is FAT32 still alive?
FAT32 is deprecated because of...
June 20, 2012 at 1:08 am
Koen Verbeeck (4/17/2012)
Carlo Romagnano (4/17/2012)
I am curious to know how many developpers will use default value for "START WITH". In most cases will be a negative number.
They will all be...
April 17, 2012 at 2:06 am
I am curious to know how many developpers will use default value for "START WITH". In most cases will be a negative number.
April 17, 2012 at 1:17 am
Nakul Vachhrajani (4/15/2012)
1. Database is in full-recovery mode
2. User foresees bulk-operations (i.e. to be performed sometime in the future)
3. User therefore changes the database...
April 16, 2012 at 3:57 am
Another tricky and bad worded question.
In the earlier versions of any DBMS, the foreign key was implemented thru triggers.
So the answer should be "YES, implemented by trigger."
Or change the question:...
April 6, 2012 at 2:02 am
I tried on my production server:
I got interesting results
ordering by [Total IO] instead of [Average IO].
Thanks!
April 4, 2012 at 1:10 am
cengland0 (3/30/2012)
March 30, 2012 at 3:20 am
Easy question!
Good practice is never use "SELECT * FROM" in view, too.
😉
March 27, 2012 at 1:24 am
Viewing 15 posts - 556 through 570 (of 819 total)