Which two commands can be used to shut the database system down? (Choose two.)
A. nzstop
B. nzdown
C. nzhw stop
D. nzsystem stop
E. service halt nps
With LDAP enabled, which of the following is verified against an LDAP server?
A. Database user ADMIN privileges.
B. Database user SELECT privileges.
C. Database user GROUP authentication.
D. Database user password authentication.
What must the Linux administrator ensure when creating a Linux user on the host?
A. The user account is provided super-user privileges.
B. The user account exists in the LDAP authentication server.
C. The user account password is at least 8 characters in length.
D. The user account is created on the active and standby server.
A stored procedure returning one value is created, which two methods can be used to execute the procedure? (Choose two.)
A. Using the EXECUTE command.
B. Using the SELECT statement within a FROM clause.
C. Using the SELECT statement within a HAVING clause.
D. Using the SELECT statement without a FROM clause.
E. Using the SELECT statement with tables in the FROM clause.
Which User Defined Function (UDF) statement is true?
A. It accepts zero or more input values but produces one output value.
B. It accepts exactly one input value and produces exactly one output value.
C. it accepts exactly one input value and produces one or more output values.
D. It accepts zero or more input values and produces one or more output values.
What function can nzrestore perform?
A. Restore TEMP tables.
B. Restore database triggers.
C. Rename tables during the restoration.
D. Return materialized views to their original state.
An ETL/ODBC application is inserting 1 million records in a single transaction against the PureData
System for Analytics. 1 million individual INSERT SQL statements are generated.
What can make this faster?
A. Use a COPY command.
B. Use an EXTERNAL TABLE.
C. Increase the Socket Buffer Size.
D. Set the COMMIT interval to 10,000.
When enabled, query history always collects information about login failures, session creation, session termination, and query history process startup. Which area does query history NOT collect data?
A. Plans
B. Disks
C. Tables
D. Queries
Which statement is NOT true?
A. nzbackup backs up selected tables.
B. nzbackup backs up to a file system destination.
C. nzbackup backs up to a Veritas NetBackup destination.
D. nzbackup backs up to a IBM Tivoli Storage Manager destination.
You have access to two databases, DEV and PROD. Currently you are connected to the DEV database. Which operation is permitted?
A. Delete from PROD..TableA
B. Select * from PROD..TableA
C. Truncate table PROD..TableA
D. Insert into PROD..TableA select * from DEV..TableB
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 P2090-047 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.