Q1. A company is planning to carry out redevelopment and tuning on a large important application. Prior to this rework, the developer needs to capture all objects that the application to using they can be replicated in test and development environments Which DBOL logging option should be enabled by the DBA to research and determine the database entities that are being used?
A.STEPINFO
B. USECOUNT
C. OBJECTS
D. EXPLAIN
C
Q2. What is a characteristic of a physical data model?
A.Includes index definitions based on how data rows will be accessed or distributed
B. Presents itself in third normal form
C. Presents the data in a standard framework that supports direct data access for the business provides user
D. Provides user names that are in agreement with organizational policies
A
Q3. How does the TPT UPDATE Operator apply changes?
A.It batches all updates for a data block and applies them all at once.
B. It applies different update operations in a separate pass against the table.
C. It batches all updates for a table one partition at a time.
D. It applies all updates to a table and processes them a single row at a time.
A
Q4. In which SQL clauses can a subquery be
A.SELECT and GROUP BY
B. FROM and ORDER BY
C. CASE and WHERE
D. INTO and FROM
C
Q5. Which attribute is the default for tables created in Teradata mode?
A.SET
B. WITH ISOLATED LOADING
C. DERIVED
D. CASESPECIFIC
A
$ 39
Reviews
There are no reviews yet.