C2090-556 Practice Questions & Answers
C2090-556 Exam Questions
Want to be a certified professional? Then go ahead there is nothing stopping you. Unless you are afraid you’ll fail the exam. If that’s so, try these amazing Test4Practice C2090-556 Dumps Questions Answers.This test material is prepared by IBM Professionals themselves.Providing a real-time exam environment and Latest test materials.Get regular reports on your progress and tackle every hurdle in your way.Start practicing today and passing IBM Storage Technical V2 Exam will be easy-peasy.
Question No : 1
Which two statements will search text data stored in the column brands of the table products for the string century? (Choose two.)
A. SELECT id FROM products WHERE brands = 'century';
B. SELECT id FROM products WHERE brands LIKE '*century*';
C. SELECT id FROM products WHERE brands MATCHES '*century*';
D. SELECT id FROM products WHERE bts_exists(brands, 'century');
E. SELECT id FROM products WHERE bts_contains(brands, 'century');
Question No : 2
What is a view?
A. a synonym
B. a base table
C. a virtual or synthetic table
D. a copy of an ordinary table
Question No : 3
William needs to create a table with a BYTE column which must be populated. Which of the following CREATE TABLE clauses can be used to ensure that the BYTE column contains a value?
A. OF TYPE
B. NOT NULL
C. CHECK (IS NOT NULL)
D. It is not possible to ensure that a BYTE column is populated.
Question No : 4
When is a cursor necessary in an SQL program?
A. A cursor is necessary before an after trigger can be created.
B. A cursor is necessary when a query returns one row and you wish to examine its content and maybe update it or delete it.
C. A cursor is necessary when a query returns more than one row and you wish to examine their content before an update or delete statement isexecuted.
D. A cursor is only necessary when using DISTINCT, UNIQUE, ORDER BY, GROUP BY or aggregates in SQL statements.
Question No : 5
What are user created temporary tables used for?
A. To persistently write temporary data to disk.
B. To share result sets across multiple sessions.
C. To access a temporary result set within one session.
D. To automatically delete data based on a time policy.
Category: C2090-556 Study Material
you are at C2090-556 Practice Questions & Answers
For more questions you can browse C2090-556 Study Material .