IBM C2090-558 - Informix 11.70 Fundamentals Exam
Page: 2 / 24
Total 120 questions
Question #6 (Topic: Topic 1)
When restoring data, which granularity of object may NOT be restored?
A. a single table
B. a single chunk
C. a single dbspace
D. an entire instance
Answer: B
Question #7 (Topic: Topic 1)
Which command option should be used to resume an interrupted onbar restore?
A. -RETRY
B. -RESTART
C. -REINTIIALZE
D. -BEGIN_AGAIN
Answer: B
Question #8 (Topic: Topic 1)
Assuming the tables and columns mentioned below exist, which of the following SQL
statements will return an error?
statements will return an error?
A. INSERT INTO orders SELECT * FROM new_orders;
B. SELECT company, fname, lname, state FROM customer WHERE state = (SELECT state, zipcode FROM customer WHERE fname = "John");
C. DELETE FROM stock WHERE 0 = (SELECT count(*) FROM manufact WHERE manufact.manu_code = stock.manu_code)
D. UPDATE customer SET (address, city, state, zip) = (SELECT address, city, state, zip FROM newaddr WHERE newaddr.customer_num = customer.customer_num) WHERE customer_num IN (SELECT customer_num FROM newaddr);
Answer: B
Question #9 (Topic: Topic 1)
Which Informix utility listed below will allow an administrator to run ad hoc SQL against the
instance?
instance?
A. onsql
B. onadmin
C. dbaccess
D. dbschema
Answer: C
Question #10 (Topic: Topic 1)
Which of the following can be used to create and drop logical logs?
A. onlog
B. ondblog
C. onspaces
D. onparams
Answer: D
