You have to design a table and application layout, in which automatic number generation is used. The application also wants to assign database generated numbers in an SQL UPDATE statement. Which statement is true?
A. Neither Identity nor Sequence can deliver this functionality.
B. Identity can deliver this functionality, but Sequence cannot.
C. Identity cannot deliver this functionality, but Sequence can.
D. Identity and Sequence can both deliver this functionality.
Which stored procedures need to be set up properly in order to register an XML schema?
A. XSR_ADD_SCHEMA
B. XSR_REGISTER and XSR_COMPLETE
C. XSR_REGISTER, XSR_VALIDATE and XSR_COMPLETE
D. The commands to register a XML schema do not invoke stored procedures.
A unique index (IX1) currently exists on COL1, COL2 and COL3 of the table. There is a request to be able to have an index on these three columns and COL4 to achieve the optimal access path. The addition of COL4 will not support the uniqueness requirement of the index. In order to add this column to the index while still preserving the unique constraint of the first three columns, which option should be taken?
A. Add a new index on COL4.
B. Perform a ALTER INDEX IX1 ADD COLUMN (COL4).
C. Add a new UNIQUE index on COL1, COL2, COL3, COL4.
D. Perform an ALTER INDEX IX1 ADD INCLUDE COLUMN (COL4).
The following DDL statements are executed to create the following objects: CREATE TABLESPACE TS1 BUFFERPOOL BP0 IN DB1; CREATE TABLE USER1.TB1 ( COL1 INTEGER, COL2 VARCHAR(10) ) IN DB1.TS1; CREATE INDEX USER1.IX1 ON USER1.TB1 ( COL2 ) BUFFERPOOL BP0 COPY YES; Next, the following ALTER statements are done (in order): 1) ALTER TABLESPACE DB1.TS1 BUFFERPOOL BP8K0 MAXPARTITIONS 20; 2) ALTER TABLESPACE DB1.TS1 SEGSIZE 64; 3) ALTER INDEX USER1.IX1 BUFFERPOOL BP16K0; Which of the following will materialize all of the changes with the least amount of work?
A. Nothing needs to be done.
B. REORG INDEX USER1.IX1 SHRLEVEL CHANGE
C. REORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE
D. REORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE REORG INDEX USER1.IX1 SHRLEVEL CHANGE
The following SQL statement is issued: SELECT col1 FROM tb1 ORDER BY col1 ASC The following results are received: 1111 AAAA Which statement is true?
A. The encoding scheme of the table is EBCDIC.
B. The encoding scheme of the table is UNICODE.
C. This could never happen, this is an error and must be reported.
D. This is expected behavior and independent of the encoding scheme.
On what type of index would an ALTER INDEX ADD COLUMN be allowed?
A. An XML index.
B. An auxiliary index.
C. A user defined catalog index.
D. An index defined with BUSINESS_TIME WITHOUT OVERLAPS.
In a normalized design, in third normal form, the entity defined in the logical design is often transformed in the physical design to which of the following?
A. Index
B. Table
C. Schema
D. Database
If SEGSIZE 64 and MAXPARTITIONS 10 are specified in a CREATE TABLESPACE statement, what type of table space is created?
A. LOB table space.
B. Segmented table space.
C. Range-partitioned table space.
D. Partition-by-growth table space.
A single table should allow for up to 100 Terabytes of application data. How do you design your table space?
A. A segmented compressed table space, BUFFERPOOL BP0.
B. A LOB table space with DSSIZE 64GB, BUFFERPOOL BP8K0.
C. A table space with NUMPARTS 1024, DSSIZE 64G, BUFFERPOOL BP16K0.
D. A table space with MAXPARTITIONS 2048, DSSIZE 64G, BUFFERPOOL BP32K.
For which table type could you specify ALTER TABLE tb1 DATA CAPTURE CHANGES?
A. Catalog tables
B. Directory tables
C. Auxiliary tables
D. Declared global temporary tables
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C2090-612 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.