Given the following insert statement:
INSERT INTO product ( pid, description ) VALUES ( '100-100-01', XMLPARSE ( DOCUMENT '<product xmlns="http://posample.org" pid=''100-100-01'' > <description> <name>Snow Shovel, Basic 22in</name> <details>Basic Snow Shovel, 22in wide, straight handle with D-Grip</details> <price>9.99</price> <weight>1 kg</weight> </description> </product>' PRESERVE WHITESPACE ) );
Which of the following table definitions will support the insert statement above?
A. CREATE TABLE product
( pid VARCHAR(10) NOT NULL PRIMARY KEY,
name VARCHAR(128),
price DECIMAL(30,2),
promoprice DECIMAL(30,2),
promostart DATE, promoend DATE, description XML);
B. CREATE TABLE product
( pid XML NOT NULL PRIMARY KEY,
name VARCHAR(128),
price DECIMAL(30,2),
promoprice DECIMAL(30,2),
promostart DATE,
promoend DATE,
description XML);
C. CREATE TABLE product
( pid VARCHAR(10) NOT NULL PRIMARY KEY,
name VARCHAR(128),
price DECIMAL(30,2),
promoprice DECIMAL(30,2),
promostart DATE,
promoend DATE,
description VARCHAR(1000));
D. CREATE TABLE product
( pid XML NOT NULL PRIMARY KEY,
name VARCHAR(128),
price DECIMAL(30,2),
promoprice DECIMAL(30,2),
promostart DATE,
promoend DATE,
description VARCHAR(1000));
正解:A
質問 2:
A user wishing to invoke an SQL stored procedure that queries a table must have which of the following privileges?
A. CALL privilege on the procedure; REFERENCES privilege on the table
B. EXECUTE privilege on the procedure; SELECT privilege on the table
C. CALL privilege on the procedure; SELECT privilege on the table
D. EXECUTE privilege on the procedure; REFERENCES privilege on the table
正解:B
質問 3:
Consider the following table called EMPLOYEES:
ID FIRSTNAME LASTNAME JOB LEVEL
1 Paul Jones DBA 2 2 George Baker MGR 1 3 Roger Melvin CLERK 3 4 Jim Smith MGR 1 5 Kevin Street CLERK 3 6 Chris Eaton MGR 1
If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1
A. 0
B. 1
C. 3
D. 6
正解:D
質問 4:
While attempting to connect to a database stored on an iSeries server from a Windows client, the
following message was displayed:
SQL1013N The database alias name or database name "TEST_DB" could not be found.
Which of the following actions can be used to help determine why this message was displayed?
A. Execute the LIST REMOTE DATABASES command on the server; look for an entry for the TEST_DB database
B. Execute the LIST REMOTE DATABASES command on the client; look for an entry for the TEST_DB database
C. Execute the LIST DCS DIRECTORY command on the server; look for an entry for the TEST_DB database
D. Execute the LIST DCS DIRECTORY command on the client; look for an entry for the TEST_DB database
正解:D
質問 5:
Which of the following will provide user USER1 and all members of the group GROUP1 with the ability to perform DML, but no other operations on table TABLE1?
A. GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO user1 AND group1
B. GRANT ALL PRIVILEGES EXCEPT ALTER, INDEX, REFERENCES ON TABLE table1 TO USER user1, GROUP group1
C. GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO USER user1, GROUP group1
D. GRANT CONTROL ON TABLE table1 TO user1 AND group1
正解:C
質問 6:
Which of the following is NOT a characteristic of a declared temporary table?
A. Declared temporary tables are not persistent and can only be used by the application that creates them
B. It is possible for many applications to create declared temporary tables that have the same name
C. Once the application that created a global temporary table is terminated, any records in the table are deleted and the table is automatically destroyed Data Concurrency
D. Declared temporary tables are created by executing a CREATE TABLE statement with the DECLARED GLOBAL TEMPORARY clause specified
正解:D
Hoshizaki -
御社の問題集C2090-730の解説が充実していて分かりやすく、試験への取り組み方が身についた気がします。自信を持って試験に臨めます。