CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.




Get it now !!
Send your Resume to 6000 Companies

Search Interview Questions

Question: Given the following two tables: TAB1 TAB2 C1 C2 CX CY ?????? ????? ????? ?????? A 11 A 21 B 12 C 22 C
13 D 23 The following results are desired: C1 C2 CX CY ?????? ????? ????? ?????? A 11 A 21 B 12 ? ? C 13 C
22 Which of the following joins will yield the desired results?
A.SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx B.SELECT * FROM tab2 LEFT OUTER JOIN tab1 ON c1=cx
C.SELECT * FROM tab2 FULL OUTER JOIN tab1 ON c1=cx
D.SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx

Answer: D.SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx



Category IBM Certification Exams Interview Questions & Answers - Exam Mode / Learning Mode
Rating (0.6) By 335 users
Added on 7/16/2015
Views 3208
Rate it!
Question: Given the following two tables: TAB1 TAB2 C1 C2 CX CY ?????? ????? ????? ?????? A 11 A 21 B 12 C 22 C
13 D 23 The following results are desired: C1 C2 CX CY ?????? ????? ????? ?????? A 11 A 21 B 12 ? ? C 13 C
22 Which of the following joins will yield the desired results?
A.SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx B.SELECT * FROM tab2 LEFT OUTER JOIN tab1 ON c1=cx
C.SELECT * FROM tab2 FULL OUTER JOIN tab1 ON c1=cx
D.SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx

Answer:

D.SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx Source: CoolInterview.com



If you have the better answer, then send it to us. We will display your answer after the approval

Rules to Post Answers in CoolInterview.com:-

  • There should not be any Spelling Mistakes.
  • There should not be any Gramatical Errors.
  • Answers must not contain any bad words.
  • Answers should not be the repeat of same answer, already approved.
  • Answer should be complete in itself.

Post your answer here

Inform me about updated answers to this question.
Related Questions
View Answer
A unit of work is using an isolation level of Read Stability. An entire table is scanned twice within

the unit of work. Which of the following can be seen on the second scan of the table?
A.Rows removed by other processes
B.Rows added to a result set by other processes
C.Rows changed in a result set by other processes
D.Rows with uncommitted changes made by other processes
View Answer
Which two of the following SQL data types should be used to store a small binary image?
A.CLOB
B.BLOB
C.VARCHAR
D.GRAPHIC
E.VARCHAR FOR BIT DATA
View Answer
Given the following table definition: STAFF id INTEGER name CHAR(20) dept INTEGER job CHAR(20) years INTEGER salary DECIMAL(10,2) comm DECIMAL(10,2) Which of the following SQL statements will return a result set that satisfies these conditions: ?Displays the department ID and total number of employees in each department. ?Includes only departments with at least one employee receiving a commission (comm) greater than 5000. ?Sorted by the department employee count from greatest to least.
A.SELECT dept, COUNT(*) FROM staff GROUP BY dept HAVING comm > 5000 ORDER BY 2 DESC B.SELECT dept, COUNT(*) FROM staff WHERE comm > 5000 GROUP BY dept, comm ORDER BY 2
DESC
C.SELECT dept, COUNT(*) FROM staff GROUP BY dept HAVING MAX(comm) > 5000 ORDER BY 2
DESC
D.SELECT dept, comm, COUNT(id) FROM staff WHERE comm > 5000 GROUP BY dept, comm ORDER BY 3 DESC
View Answer
Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?
A.CLOB
B.TIME
C.VARCHAR
D.TIMESTAMP
View Answer
Which of the following tools is used to create subscription sets and add subscription?set members to subscription sets?
A.Journal
B.License Center
C.Replication Center
D.Development Center
View Answer
.A table called EMPLOYEE has the following columns: NAME DEPARTMENT PHONE_NUMBER
Which of the following will allow USER1 to modify the PHONE_NUMBER column?
A.GRANT INDEX (phone_number) ON TABLE employee TO user1
B.GRANT ALTER (phone_number) ON TABLE employee TO user1
C.GRANT UPDATE (phone_number) ON TABLE employee TO user1
D.GRANT REFERENCES (phone_number) ON TABLE employee TO user1
View Answer
If there is a lock on an adjacent key, an insert will fail if the isolation level is set to what?

A. committed read
B. repeatable read
C. share read
D. indexed read

View Answer
Which three can be locked?

A. a row
B. a page
C. a column
D. a key
E. shared memory
View Answer
Which isolation level does a database without logging default to?

A. committed read
B. dirty read
C. mode ANSI
D. repeatable read
View Answer
Given that the SQL statement SET LOCK MODE TO WAIT has not been executed, if a statement attempts to alter a row that another process has locked, what happens?

A. The lock is released
B. An error is returned
C. The row is immediately updated.
D. The row is updated after the lock is removed.
View Answer
Which statement fragments a table as round robin?

A. FRAGMENT AS ROUND ROBIN IN dbspace 1, dbspace 2
B. FRAGMENT TABLE BY ROUND ROBIN IN dbspace1, dbspace 2
C. FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace 2
D. FRAGMENT BY ROUND ROBIN
View Answer
What does the ATTACH clause in the ALTER FRAGMENT statement do?

A. It adds extents to a table.
B. It attaches a raw data file to a table
C. It combines two unregimented tables
D. It combines two fragmented tables

View Answer
What are three advantages of fragmentation?

A. higher availability
B. reduced disk space requirements
C. parallel scans are possible with PDQ
D. finer granularity of archives and resources
View Answer
In which two situations would you use a round robin fragmentation strategy?

A. When all fragments must be second
B. To create uneven data distributions
C. When queries perform sequential scans and you have little information about the data being stored.
D. When tables are accessed with a high degree of selectivity
View Answer
Which fragments an index by expression?

A. FRAGMENT BY EXPRESSION col_1
B. FRAGMENT BY EXPRESSION col_2>=10000IN dbspace 1 AND col_2>10000IN dbspace2
C. FRAGMMENT BY EXPRESSION col_1<10000 AND col_2 IN dbspace 2
D. FRAGMENT BY EXPRESSION col <20000 IN dbspace 1, col> = 20000 IN dbspace 2
View Answer
Which two happen when the ALTER FRAGMENT statement is run?

A. Transaction logging, if present is suspended.
B. The table is locked until the statement is completed.
C. The database is locked until the statement is complete.

D. For databases with logging the statement executes as a single transaction
View Answer
Why is a hash function advantageous in an expression-based distribution?

A. Because it creates an even distribution of data.
B. Because it creates an unevn distribution of data.
C. Because it does not do expression testing
D. Because it places all data in one dbspace.
View Answer
Why is a hash function advantageous in an expression-based distribution?

A. Because it creates an even distribution of data.
B. Because it creates an unevn distribution of data.
C. Because it does not do expression testing
D. Because it places all data in one dbspace.
View Answer
Which two types of fragmentation are allowed in a CREATE TABLE statement?

A. disk striping
B. dbspace
C. indexing
D. round robin
E. mirroring F. tblspace G. sorting
H. expression
View Answer
Where is fragment information stored?

A. in the system catalog tables
B. in the physical logs
C. in the reserved pages
D. in the first page of the database tblspace
View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All IBM Certification Exams Interview Questions & Answers - Exam Mode / Learning Mode




India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.609375 Seconds