Up To The Minute C2090-558 Free Samples 2021

NEW QUESTION 1
A progammer wants to unload a table to a file inside a stored procedure. What functionality listed below will help the programmer accomplish the task?

• A. dbload
• B. dbexport
• C. external table
• D. SQL unload statement

Answer: C

NEW QUESTION 2
Which of the following can be used in a SELECT statement to set one or more qualifying conditions to a group of records after they are formed?

• A. HAVING
• B. WHERE
• C. GROUP BY
• D. ORDER BY

Answer: A

NEW QUESTION 3
Which two operations are performed with the onspaces command? (Choose two.)

• A. Add space to the server.
• B. Compress server space.
• C. Encrypt the server space.
• D. Remove space from the server.
• E. Restrict access to the server space.

Answer: AD

NEW QUESTION 4
Which of the following is true about system catalog tables access?

• A. Only user informix can read system catalog tables
• B. Only system administrators can read system catalog tables
• C. Only database administrators can read system catalog tables
• D. Any user that can connect to the database can read system catalog tables

Answer: D

NEW QUESTION 5
When storing string "ABCD" in a column, which of the following data types will result in a string stored with 2 padded spaces?

• A. VARCHAR (6)
• B. VARCHAR (4,2)
• C. VARCHAR (8,6)
• D. VARCHAR (6,8)

Answer: C

NEW QUESTION 6
Which phase of Fast Recovery rolls forward (restores) all transactions since the last checkpoint and rolls back any uncommitted transactions?

• A. Logical Recovery
• B. Physical Recovery
• C. Dbspace Recovery
• D. Transactional Recovery

Answer: A

NEW QUESTION 7
Which statement is used to create a permanent nonlogged table in a logged database?

• A. CREATE TABLE tab1 (col1 INTEGER, col2 INTEGER)
• B. CREATE RAW TABLE tab1 (col1 INTEGER , col2 INTEGER)
• C. CREATE STATIC TABLE tab1 (col1 INTEGER , col2 INTEGER)
• D. CREATE NONLOGGING TABLE tab1 (col1 INTEGER , col2 INTEGER)

Answer: B

NEW QUESTION 8
Assuming the tables and columns mentioned below exist, which of the following SQL statements will return an error?

• A. INSERT INTO orders SELECT * FROM new_orders;
• B. SELECT company, fname, lname, state FROM customerWHERE state = (SELECT state, zipcode FROM customer WHERE fname = "John");
• C. DELETE FROM stockWHERE 0 = (SELECT count(*) FROM manufact WHERE manufact.manu_code = stock.manu_code)
• D. UPDATE customer SET (address, city, state, zip) = (SELECT address, city, state, zipFROM newaddrWHERE newaddr.customer_num = customer.customer_num)WHERE customer_num IN (SELECT customer_num FROM newaddr);

Answer: B

NEW QUESTION 9
Which two statements are true about the COMMIT WORK statement? (Choose two.)

• A. The keyword WORK is optional.
• B. A single COMMIT WORK can end several BEGIN WORK statements.
• C. The COMMIT WORK statement releases all row locks but not table locks.
• D. All of the successful modifications that the transaction makes are saved to disk when you issue a COMMIT WORK statement.
• E. A new transaction automatically starts after each COMMIT WORK or ROLLBACK WORK statement in a nonlogged database.

Answer: AD

NEW QUESTION 10
Which of the following statement is correct about Shared Disk (SD) secondary servers?

• A. SD secondary servers support automatic index repair
• B. SD secondary servers use paging files to track pages between checkpoints
• C. SD secondary servers require an HDR secondary server to be present in order to function
• D. SD secondary servers can become a High-Availability Data Replication (HDR) secondary server

Answer: B

NEW QUESTION 11
Click the Exhibit button.

In the exhibit, which two statements are correct? (Choose two.)

• A. the rootdbs dbspace is online
• B. the dataspace dbspace is online
• C. the rootdbs dbspace contains 2 chunks
• D. the dataspace dbspace contains 2 chunks
• E. the dataspace and rootdbs are both online

Answer: AC

NEW QUESTION 12
You received an error, "Chunk is not empty", while trying to remove a chunk. How do you verify which objects still occupy space in the chunk?

• A. onspaces
• B. onmonitor
• C. oncheck -pe
• D. SELECT * from SYSTABLES

Answer: C

NEW QUESTION 13
What is the only isolation level available on an unlogged database?

• A. Dirty Read
• B. Cursor Stability
• C. Committed Read
• D. Repeatable Read

Answer: A

NEW QUESTION 14
Click the Exhibit button.

In the exhibit, which statement is true regarding the update statement of Client 2 if both of the clients are connected to the same logged database?

• A. Client 2 will update col2 of the rows having col1=20.
• B. Client 2 will return successfully without updating any rows.
• C. Client 2 will keep waiting for client 1 to finish its transaction.
• D. Client 2 will get an error that the "record is locked" or the "table is locked".

Answer: D

NEW QUESTION 15
Which two tasks can be accomplished using the OpenAdmin Tool (OAT)? (Choose two.)

• A. Manage Virtual Processors (VP).
• B. Automate the update statistics process.
• C. Perform installation of an Informix server.
• D. Run the High Performance Loader (HPL) GUI tool.
• E. Remove an instance's orphaned shared memory segment.

Answer: AB

NEW QUESTION 16
Which two storage objects exist in Informix? (Choose two.)

• A. dbspace
• B. flash space
• C. smart rowspace
• D. smart blobspace
• E. encrypted space

Answer: AD

NEW QUESTION 17
Which of the following is required for a cold restore?

• A. A restore that includes the rootdbs
• B. A restore that includes temp dbspaces
• C. A restore that includes only non-critical dbspaces.
• D. A restore that includes multiple level to be restored.

Answer: A

NEW QUESTION 18
Which of the following methods can be used to tranfer data in EXPRESS mode?

• A. dbload
• B. external tables
• C. onload/onunload
• D. dbexport/dbimport

Answer: B

NEW QUESTION 19
Which keyword is used to determine whether a comparison is true for every value returned from a subquery?

• A. ALL
• B. ANY
• C. EACH
• D. EVERY

Answer: A

NEW QUESTION 20
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

NEW QUESTION 21
Why would you want to create a table with a lock mode row as opposed to a lock mode page?

• A. to reduce disk I/O
• B. to keep more information in memory for each locked row
• C. to increase concurrency among multiple users on the same table
• D. to reduce the number of locks when accessing rows out of the table

Answer: C

NEW QUESTION 22
......