Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
P.S. Pinpoint C2090-320 bundle are available on Google Drive, GET MORE: https://drive.google.com/open?id=1ONX12YMjzKx_pFwlad2x5sVsVebtwWy8
Q1. In a unique referential constraint, which type of key does a foreign key reference?
A. Child key
B. Collation key
C. Parent key
D. Secondary key
Answer: C
Q2. Given a non-partitioned table space TS1 is built with LOCKSIZE ROW, LOCKMAX 1000 and SEGSIZE 64. If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?
A. PAGE
B. TABLE
C. PARTITION
D. TABLESPACE
Answer: C
Q3. Which types of user-defined data types are supported? (Choose two.)
A. CHAR
B. ARRAY
C. NUMERIC
D. DISTINCT
E. TIMESTAMP
Answer: BD
Q4. Which of the following is TRUE for using LOAD on a partition-by-growth table space?
A. Data can only be loaded at the partition level
B. Data can only be loaded at the table space level
C. Data can only be loaded using a clustering index
D. Data can be loaded at either the table space level or the partition level
Answer: A
Q5. Which component of the program preparation produces a DBRM (Database request Module)?
A. Compiler
B. Linkage Editor
C. Bind command
D. Precompiler/Coprocessor
Answer: D
Q6. We want to increase the salary for each employee (EMP) in the department (WORKDEPT) D11 and we want to see the new salaries(SALARY) for each of them. Which single SQL statement will do this?
A.
B.
C.
D.
Answer: D
Q7. Which of the following describes OLTP workload rather than an analytics workload?
A. Extreme data volume
B. Temporary or intermediate staging of data
C. Set-oriented processing and bulk operations
D. A large number of short, discrete, atomic transactions
Answer: D
Q8. What is the result XQuery FLWOR expression when running the following scenario?
A. Joe Smith
B. <name> Joe Smith </name>
C. <employeeinfo><name> Joe Smith </name></employeeinfo>
D. <name> Joe Smith </name><department name>DB2</department name>
Answer: A
Q9. Which of the following statements concerning a bi-temporal table is TRUE?
A. It provides business history, but is not useful for audit purposes
B. It is defined with both an application period and a system period
C. It is useful for audit purposes, but is not useful for business history
D. It contains data reflecting two different times u2013 current time and one previous time
Answer: B
Q10. Which package level privileges does the user smith have when the following statement is executed? GRANT ALL ON PACKAGE clct1.pkg1 TO smith;
A. GRANT, COPY, BIND, RUN
B. BIND, EXECUTE, COPY, RUN
C. CREATE, COPY, RUN, EXECUTE
D. COPY, BINDADD, SQL, EXECUTE
Answer: B
P.S. Easily pass C2090-320 Exam with Examcollectionplus Pinpoint Dumps & pdf vce, Try Free: https://www.examcollectionplus.net/vce-C2090-320/ ( New Questions)