Is this order still true after a reorg or export / import? (I understood it wasn't, but am a bit of a novice still) - both of which are valid operations to the table given the question.
If so then isn't the correct answer to the question "none of them really" (ie the closest answer is A).
-----Original Message-----
From: Herschede, Heidi [mailto:[Email Address Removed] 09 June 2003 14:06
To: 'sami dba'; [Email Address Removed] RE: Two more Qs Please...
Q1)
Order of SQL:
create table hh (hh int not null, h int);
ALTER TABLE hh
ADD PRIMARY KEY (hh);
insert into hh values (5,5);
insert into hh values (1,1);
select * from hh;
HH H
----------- -----------
5 5
1 1
2 record(s) selected.
Q2) Unless this is a trick question, the answer is:
A. GRANT SELECT ON TABLE table1 TO user1
-----Original Message-----
From: sami dba [mailto:[Email Address Removed] Saturday, June 07, 2003 6:42 AM
To: [Email Address Removed] Two more Qs Please...
Q1)
Given a large table with the following sample data:
STAFF
ID LASTNAME
1 Jones
2 Smith
... ...
When issuing the query "SELECT * FROM staff", which of the following will
always describe the order of the rows in the result set?
A. An undetermined order
B. Sorted by primary key
C. The order in which rows were inserted into the table
D. Sorted by the ID column, then by the LASTNAME column
Q2)
A user creates the table TABLE1 with a referential constraint defined over
column COL1. Which of the following statements would explicitly give USER1
the ability to read rows from the table?
A. GRANT SELECT ON TABLE table1 TO user1
B. GRANT ACCESS ON TABLE table1 TO user1
C. GRANT REFERENCES TO user1 ON TABLE table1
D. GRANT UPDATE (col1) TO user1 ON TABLE table1
---------------------------------
Do you Yahoo!?
Free online calendar with sync to Outlook(TM).
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed] e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
“This email and any attachments are confidential and may contain privileged information intended for the named addressee(s) only
If you are not the intended recipient, please notify us immediately and take note that you do not have the legal authority to open, use, retain, disclose or distribute this email or any part of it
The content of this email or any of its attachments may contain data that falls within the scope of the Data Protection Act 1998, the unauthorised opening, use, recording, disclosure, copying or alteration of this message is strictly forbidden under the Data Protection Act 1998
You must take full responsibility for virus checking this email and any attachments. This email and any attachments have been scanned for viruses prior to leaving our Group network. LTF Holdings (UK) Ltd or any of its subsidiaries will not be liable for direct, special, indirect or consequential damages arising from alteration of the contents of this message by a third party or as a result of any virus being passed on.
Unless expressly stated, opinions in this email are those of the individual sender and not LTF Holdings (UK) Ltd or any of its subsidiaries
LTF Holdings (UK) Ltd and any of its subsidiaries reserves the right to monitor and record email messages sent to and from this address for the purposes of investigating or detecting any unauthorised use of its system and ensuring its effective operation”
DB2 & UDB email list listserv db2-l LazyDBA home page