Given the following SQL statements: CREATE TABLE birthday1 (day INT CHECK(day BETWEEN 1 AND 31), mon - B.2 - IBM Certification Exams Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

CERTIFICATION EXAMS

IBM CERTIFICATION EXAMS

DETAILS

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.2) By 9120 users
Added on	7/16/2015
Views	70880
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.

	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 subscriptionset 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