Question 1

Which statement would change the default date format to a specified format for the current session?

technology databases

ALTER SESSION SET NEW_DATE_FORMAT =
ALTER SESSION SET CUR_DATE_FORMAT =
ALTER SESSION SET NLS_DATE_FORMAT =
ALTER SESSION SET SESS_DATE_FORMAT =

Answer

Correct Option: C

Question 2

WHAT IS THE MAX LENGHT OF VARCHAR2 DATATYPE IN PL/SQL?

technology databases

32767
1024
255
32765

Answer

Correct Option: A

Question 3

Which one of the following is maximum limit for output generated by DBMS_OUTPUT?

technology databases

10000000
1000000
100000
1000

Answer

Correct Option: B

Question 4

Which one of the following contains only valid PL/SQL reserved words?

technology databases

TO_CHAR, INOUT
PROC, PACKAGE
PRAGMA, MULTI_ROW
SELECT, EXCEPTION

Answer

Correct Option: D

Question 5

Which one of the following SQL*Plus options lets you trace and print the execution plans as well as statistics?

technology databases

SET AUTOTRACE TRACEONLY
SET AUTOTRACE ON
SET AUTOTRACE ON STATISTICS
SET AUTOTRACE ON EXPLAIN

Answer

Correct Option: B

Question 6

What does the <<>> lexical unit or delimiter signify in PL/SQL?

technology databases

Comment marker
Not equal to operator
Label delimiter
Greater than or equal to operator

Answer

Correct Option: C

Question 7

Which one of the following is a valid RAISE_APPLICATION_ERROR call?

technology databases

RAISE_APPLICATION_ERROR(-21001);
RAISE_APPLICATION_ERROR(-20001,'An error has occurred');
RAISE_APPLICATION_ERROR(-21001,'An error has occurred');
RAISE_APPLICATION_ERROR(-20001);

Answer

Correct Option: B

Question 8

Which one of the following provides you with the number of records affected by the last DML statement?

technology databases

SQL%ROWCOUNT
SQL%COUNT
SQL%FOUND
SQL%NUM_ROWS

Answer

Correct Option: A

Question 9

Which of the following are two architectural attributes of a Teradata System?

technology databases

Disk space associated with an AMP is divided into three areas: system, permanent and spool
Parallelism is achieved through operating system time slicing
The AMP’s access data from their associated vdisks as required.
The PE’s communicate with the AMP’s across the BYNET

Answer

Correct Option: C,D

Question 10

Which is the component that limits queries based on set thresholds?

technology databases

Teradata SQL Assistant
BTEQ
Teradata Manager
TDQM

Answer

Correct Option: D

Question 11

Which of the following is a statement that is true regarding temporary space?

technology databases

Temporary space is spool space currently not used
Temporary space is permanent space currently not used.
Temporary space is subtracted from SysAdmin
Temporary space is assigned at the table level.

AI Explanation

AI 1

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) Temporary space is spool space currently not used - This option is incorrect because temporary space is not the same as spool space. Temporary space refers to disk space that is allocated for temporary storage during query execution, while spool space is a specific type of temporary space used for intermediate query processing.

Option B) Temporary space is permanent space currently not used - This option is correct because temporary space refers to disk space that is allocated for temporary storage during query execution. It is called temporary because it is not permanent storage and is only used temporarily while the query is being executed. This option accurately describes the nature of temporary space.

Option C) Temporary space is subtracted from SysAdmin - This option is incorrect because temporary space is not subtracted from SysAdmin. SysAdmin refers to the system administrator, who is responsible for managing the database system, including allocating resources such as disk space. Temporary space is allocated separately and is not subtracted from the resources allocated to SysAdmin.

Option D) Temporary space is assigned at the table level - This option is incorrect because temporary space is not assigned at the table level. Temporary space is allocated at the system level and is used for temporary storage during query execution. It is not specific to any particular table.

The correct answer is B) Temporary space is permanent space currently not used. This option is correct because it accurately describes temporary space as disk space that is allocated for temporary storage during query execution, but is not permanent and is only used temporarily.

Answer

Correct Option: B

Question 12

Of the following, which two are attributes of a Teradata warehouse? (Choose two)

technology databases

Customer applications drive the processes.
Relational databases are more flexible than other types.
Businesses are able to quickly respond to changing conditions
It is built to reflect business application models.

Answer

Correct Option: B,C

Question 13

Which two of the following statements are true regarding a Primary Index are accurate?

technology databases

A primary Index is a physical mechanism.
There is a limit to the number of columns in a Primary Index.
A Primary Index requires uniqueness
A Primary Index value can not be null.

Answer

Correct Option: A,B

Question 14

The method of creating rows, columns and tables is governed by which two relational database concepts? (Choose two)

technology databases

The order of rows in a table is arbitrary
A table can contain only one row formats
The order of rows in a table is keyed to Primary Index.
A table can contain multiple row formats

Answer

Correct Option: A,B

Question 15

What option can best describe Teradata’s architecture?

technology databases

Shared everything
Shared memory
Shared nothing
Shared data

Answer

Correct Option: C

Question 16

What is a feature of a row according to relational concepts?

technology databases

A row is one instance of all columns.
Row sequence is specified.
Duplicate rows are allowed in a table.
Rows can have different formats.

Answer

Correct Option: A

Question 17

Which of the following are two factual statements regarding an OLTP environment? (Choose two)

technology databases

Transactions are write intensive
The number rows per transaction is large
Transactions typically occur within seconds, not minutes
The number of rows per transaction is small

Answer

Correct Option: A,C

Question 18

Why would you choose a Non-Unique Primary Index (NUPI) instead of a Unique Primary Index (UPI)?

technology databases

A NUPI requires less disk space to store the data row.
A NUPI may be more effective for query access and joins.
A NUPI query amplifies the optimization process in the PE.
A NUPI provides better data distribution

Answer

Correct Option: B

Question 19

Which is the query tool that lets you access not only Teradata, but other databases as well?

technology databases

BTEQ
Teradata SQL Assistant
Teradata Manager
TDQM

Answer

Correct Option: B

Question 20

Block level operations are performed against populated tables by which utility?

technology databases

Tpump
BulKLoad
FastLoad
MultiLoad

Answer

Correct Option: D

Description: databases Online Quiz - 63
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 63

AI Explanation

AI Explanation

Find more quizzes from top tags