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 SQL statements: CREATE TABLE birthday1 (day INT CHECK(day BETWEEN 1 AND 31), month INT CHECK(month BETWEEN 1 AND 6), year INT) CREATE TABLE birthday2 (day INT CHECK(day BETWEEN 1 AND 31), month INT CHECK(month BETWEEN 7 AND
12), year INT) CREATE VIEW birthdays AS SELECT * FROM birthday1 UNION ALL SELECT * FROM
birthday2 INSERT INTO birthday1 VALUES( 22,10, 1973) INSERT INTO birthday1 VALUES( 40, 8,
1980) INSERT INTO birthday1 VALUES( 8, 3, 1990) INSERT INTO birthday1 VALUES( 22, 10, 1973) INSERT INTO birthday1 VALUES( 3, 3, 1960) What will be the result of the following SELECT statement? SELECT COUNT(*) FROM birthdays
A.0
B.2
C.3
D.5D.5

Answer: B.2



Category IBM Certification Exams Interview Questions & Answers - Exam Mode / Learning Mode
Rating (0.4) By 579 users
Added on 7/16/2015
Views 4452
Rate it!
Question: Given the following SQL statements: CREATE TABLE birthday1 (day INT CHECK(day BETWEEN 1 AND 31), month INT CHECK(month BETWEEN 1 AND 6), year INT) CREATE TABLE birthday2 (day INT CHECK(day BETWEEN 1 AND 31), month INT CHECK(month BETWEEN 7 AND
12), year INT) CREATE VIEW birthdays AS SELECT * FROM birthday1 UNION ALL SELECT * FROM
birthday2 INSERT INTO birthday1 VALUES( 22,10, 1973) INSERT INTO birthday1 VALUES( 40, 8,
1980) INSERT INTO birthday1 VALUES( 8, 3, 1990) INSERT INTO birthday1 VALUES( 22, 10, 1973) INSERT INTO birthday1 VALUES( 3, 3, 1960) What will be the result of the following SELECT statement? SELECT COUNT(*) FROM birthdays
A.0
B.2
C.3
D.5D.5


Answer:

B.2 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
Given the SQL statement: ALTER TABLE table1 ADD col2 INT WITH DEFAULT Which of the following is the result of the statement?
A.The statement fails because no default value is specified.
B.A new column called COL2 is added to TABLE1 which would have a null value if selected.
C.A new column called COL2 is added to TABLE1 which would have a value of zero if selected.
D.A new column called COL2 is added to TABLE1 which would require the default value to be set before working with the table.
View Answer
Given these columns from the DEPARTMENT table: deptno CHAR(3) NOT NULL deptname CHAR(20) NOT NULL mgrno CHAR(6) admrdept CHAR(3) location CHAR(20) NOT NULL Which of the following will select the rows that do not have a value in the MGRNO column?
A.SELECT * FROM department WHERE mgrno = � B.SELECT * FROM department WHERE mgrno = NULL C.SELECT * FROM department WHERE mgrno IS NULL
D.SELECT * FROM department WHERE mgrno IS UNKNOWN
View Answer
An application bound with isolation level Uncommitted Read updates a row. Which of the following is true regarding the locking of this row?
A.No row lock is acquired when the row is updated.
B.The row lock is released when the cursor accessing the row is closed.
C.The row lock is released when the application issues a COMMIT statement.
D.The row lock is released when the cursor accessing the row is moved to the next row.
View Answer
Given that the following statements were executed in order: CREATE TABLE tab1 (c1 CHAR(1))

INSERT INTO tab1 VALUES (�b�) CREATE VIEW view1 AS SELECT c1 FROM tab1 WHERE c1 =�a�
INSERT INTO view1 VALUES (�a�) INSERT INTO view1 VALUES (�b�) How many rows would be returned from the following statement? SELECT c1 FROM tab1
A.0
B.1
C.2
D.3
View Answer
Given the following table definition: COUNTRY c1 INTEGER name CHAR(20) Which of the following SQL statements will remove all rows from the table named COUNTRY?
A.DELETE FROM country
B.DELETE * FROM country C.DELETE FROM TABLE country
D.DELETE FROM country WHERE c1 IS NOT NULL
View Answer
A client application on OS/390 or OS/400 must access a DB2 server on AIX. At a minimum, which
of the following products is required to provide DRDA Application Server functionality on the DB2
server for AIX?
A.DB2 Connect Enterprise Edition
B.DB2 UDB Workgroup Server Edition
C.DB2 Connect Enterprise Edition and DB2 UDB Workgroup Server Edition
D.DB2 Connect Enterprise Edition and DB2 UDB Enterprise Server Edition
View Answer
Given the following statements from two embedded SQL programs: Program 1: CREATE TABLE mytab (col1 INT, col2 CHAR(24)) COMMIT Program 2: INSERT INTO mytab VALUES( 20989,�Joe Smith�) COMMIT INSERT INTO mytab VALUES( 21334,�Amy Johnson�) DELETE FROM mytab COMMIT INSERT INTO mytab VALUES( 23430,�Jason French�) ROLLBACK INSERT INTO mytab VALUES( 20993,�Samantha Jones�) COMMIT DELETE FROM mytab WHERE col1=20993
ROLLBACK Assuming Program 1 ran to completion and then Program 2 ran to completion, which
of the following records would be returned by the statement: SELECT * FROM mytab?
A.20989, Joe Smith
B.21334, Amy Johnson
C.23430, Jason French
D.20993, Samantha Jones
E.No records are returned.
View Answer
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
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

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.96875 Seconds