Which two of the following SQL data types should be used to store a small binary image? A.CLOB B. - E:BLOB /VARCHAR FOR BIT DATA - 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: 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

Answer: E:BLOB /VARCHAR FOR BIT DATA

Category	IBM Certification Exams Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 8006 users
Added on	7/16/2015
Views	69504
Rate it!

Question: 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

Answer:

E:BLOB /VARCHAR FOR BIT DATA 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 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
	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
	With database logging, where are transaction records first placed? A. in a temporary database table B. in the logical log buffer C. in the primary chunk D. in the physical buffer	View Answer
	What is the system catalog? A. A catalogued set of index criteria B. A set of tables created by the administrator. C. A set of tables that managed the operating system D. A set of tables that describe the structure of the database	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