IBM C2090-558 Bootcamp 2021
Realistic of C2090-558 exam engine materials and testing material for IBM certification for candidates, Real Success Guaranteed with Updated C2090-558 pdf dumps vce Materials. 100% PASS Informix 11.70 Fundamentals (C2090-558) exam Today!
Also have C2090-558 free dumps questions for you:
NEW QUESTION 1
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 2
Which utility would you use to print out the physical layout of the instance?
- A. onstat
- B. onmode
- C. onspaces
- D. dbschema
Answer: D
NEW QUESTION 3
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 4
Which two statements cause Stored Procedure Language (SPL) routine optimization? (Choose two.)
- A. CALL PROCEDURE
- B. CREATE PROCEDURE
- C. OPTIMIZE PROCEDURE
- D. EXECUTE PROCEDURE
- E. UPDATE STATISTICS FOR PROCEDURE
Answer: BE
NEW QUESTION 5
Which command could be used to display the definition of user-defined and complex data types?
- A. onstat -g smb
- B. oncheck -cc database_name
- C. oncheck -pB database_name
- D. dbschema -u all -d database_name
Answer: D
NEW QUESTION 6
In which database does Informix store the information when a new task is created in OpenAdmin Tool's Task Scheduler?
- A. sysutils
- B. sysusers
- C. sysadmin
- D. sysmaster
Answer: C
NEW QUESTION 7
Given the following table definition: CREATE TABLE t1(col1 BOOLEAN); Which of the following statements will fail to insert a row?
- A. INSERT INTO t1 values ('t');
- B. INSERT INTO t1 values ('f');
- C. INSERT INTO t1 values (1);
- D. INSERT INTO t1 values (NULL);
Answer: C
NEW QUESTION 8
Which of the following can be used to move the physical log?
- A. onlog
- B. ondblog
- C. onspaces
- D. onparams
Answer: D
NEW QUESTION 9
Which two commands would create a table t1 with page level locking assuming default configuration parameter settings? (Choose two.)
- A. create table t1 (c1 int)
- B. create table t1 (c1 int) locking page
- C. create table t1 (c1 int) lock level page
- D. create table t1 (c1 int) lock mode page
- E. create table t1 (c1 int) locking mode page
Answer: AD
NEW QUESTION 10
Which command listed below can be used to change the state of an operating Informix server?
- A. oninit
- B. onstat
- C. onmode
- D. onparam
Answer: C
NEW QUESTION 11
Click the Exhibit button.
The query.sql file contains the information shown in the exhibit. The following command is run: dbaccess ?query.sql How many rows will be returned by the select query?
- A. 1
- B. 2
- C. 3
- D. 4
Answer: B
NEW QUESTION 12
In what way is Enterprise Replication (ER) replication different from High-Availability Cluster (HAC) replication?
- A. All data types are replicated.
- B. The data to be replicated is defined at an instance level of granularity.
- C. The data to be replicated can be defined at a column level of granularity.
- D. The data to be replicated can not include simple blobs stored in simple blobspaces.
Answer: C
NEW QUESTION 13
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 14
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 15
You create a table with the statement shown below: CREATE TABLE foo(col INTEGER) In which dbspace will the table reside?
- A. in a temporary dbspace
- B. in the default dbspace that is defined in onconfig
- C. in the dbspace where the current database was created
- D. in the dbspace specified by the IFX_DBSPACE environment variable
Answer: C
NEW QUESTION 16
User A creates a User Defined Routine (UDR). Which privilege must be granted to other users before they can run user A's UDR?
- A. DBA on the database
- B. EXECUTE on the procedure
- C. RESOURCE on the database
- D. SELECT on the tables used in the procedure
Answer: B
NEW QUESTION 17
Informix is currently in online mode. As a DataBase System Administrator (DBSA), you switch to administration mode with ADMIN_USER_MODE_WITH_DBSA = 0. Who can
access Informix databases?
- A. only Informix
- B. only a DBSA
- C. only Informix or a DBSA
- D. only root, Informix or a DBSA
Answer: C
NEW QUESTION 18
Which configuration parameter allows you to reduce the dependency on local OS user accounts and to enable a DBSA to grant database server access to specific users without the OS user accounts?
- A. USERMAPPING
- B. IFX_EXTEND_ROLE
- C. SECURITY_LOCALCONNECTION
- D. ADMIN_USER_MODE_WITH_DBSA
Answer: A
NEW QUESTION 19
Which two products can be used by client applications to connect to Informix instances? (Choose two.)
- A. IBM Global Connect
- B. IBM Informix Connect
- C. IBM Informix JDBC Driver
- D. IBM Informix Office Manager
- E. IBM Informix Universal Driver Kit
Answer: BC
NEW QUESTION 20
Which two SQL commands can be used to invoke a stored procedure? (Choose two.)
- A. RUN function
- B. CALL function
- C. CALL procedure
- D. EXECUTE function
- E. EXECUTE procedure
Answer: DE
NEW QUESTION 21
What is the default isolation level on a database with unbuffered logging?
- A. Dirty Read
- B. Cursor Stability
- C. Committed Read
- D. Repeatable Read
Answer: C
NEW QUESTION 22
When encountering an assertion failure or performance issue, which Informix utility, when run by the DBA, collects and bundles the basic diagnostic data?
- A. ontape
- B. onmode
- C. ifxcollect
- D. onparams
Answer: C
NEW QUESTION 23
......
P.S. Easily pass C2090-558 Exam with 120 Q&As prep-labs.com Dumps & pdf Version, Welcome to Download the Newest prep-labs.com C2090-558 Dumps: https://www.prep-labs.com/dumps/C2090-558/ (120 New Questions)