0

databases Online Quiz - 63

Description: databases Online Quiz - 63
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. ALTER SESSION SET NEW_DATE_FORMAT =

  2. ALTER SESSION SET CUR_DATE_FORMAT =

  3. ALTER SESSION SET NLS_DATE_FORMAT =

  4. ALTER SESSION SET SESS_DATE_FORMAT =


Correct Option: C

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

  1. 32767

  2. 1024

  3. 255

  4. 32765


Correct Option: A

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

  1. 10000000

  2. 1000000

  3. 100000

  4. 1000


Correct Option: B

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

  1. TO_CHAR, INOUT

  2. PROC, PACKAGE

  3. PRAGMA, MULTI_ROW

  4. SELECT, EXCEPTION


Correct Option: D

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

  1. SET AUTOTRACE TRACEONLY

  2. SET AUTOTRACE ON

  3. SET AUTOTRACE ON STATISTICS

  4. SET AUTOTRACE ON EXPLAIN


Correct Option: B
  1. Comment marker

  2. Not equal to operator

  3. Label delimiter

  4. Greater than or equal to operator


Correct Option: C
  1. RAISE_APPLICATION_ERROR(-21001);

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

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

  4. RAISE_APPLICATION_ERROR(-20001);


Correct Option: B
  1. Disk space associated with an AMP is divided into three areas: system, permanent and spool

  2. Parallelism is achieved through operating system time slicing

  3. The AMP’s access data from their associated vdisks as required.

  4. The PE’s communicate with the AMP’s across the BYNET


Correct Option: C,D

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

  1. Teradata SQL Assistant

  2. BTEQ

  3. Teradata Manager

  4. TDQM


Correct Option: D

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

  1. Temporary space is spool space currently not used

  2. Temporary space is permanent space currently not used.

  3. Temporary space is subtracted from SysAdmin

  4. Temporary space is assigned at the table level.


Correct Option: B

AI Explanation

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.

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

  1. Customer applications drive the processes.

  2. Relational databases are more flexible than other types.

  3. Businesses are able to quickly respond to changing conditions

  4. It is built to reflect business application models.


Correct Option: B,C

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

  1. A primary Index is a physical mechanism.

  2. There is a limit to the number of columns in a Primary Index.

  3. A Primary Index requires uniqueness

  4. A Primary Index value can not be null.


Correct Option: A,B

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

  1. The order of rows in a table is arbitrary

  2. A table can contain only one row formats

  3. The order of rows in a table is keyed to Primary Index.

  4. A table can contain multiple row formats


Correct Option: A,B
  1. Shared everything

  2. Shared memory

  3. Shared nothing

  4. Shared data


Correct Option: C

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

  1. A row is one instance of all columns.

  2. Row sequence is specified.

  3. Duplicate rows are allowed in a table.

  4. Rows can have different formats.


Correct Option: A

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

  1. Transactions are write intensive

  2. The number rows per transaction is large

  3. Transactions typically occur within seconds, not minutes

  4. The number of rows per transaction is small


Correct Option: A,C
  1. A NUPI requires less disk space to store the data row.

  2. A NUPI may be more effective for query access and joins.

  3. A NUPI query amplifies the optimization process in the PE.

  4. A NUPI provides better data distribution


Correct Option: B

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

  1. BTEQ

  2. Teradata SQL Assistant

  3. Teradata Manager

  4. TDQM


Correct Option: B

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

  1. Tpump

  2. BulKLoad

  3. FastLoad

  4. MultiLoad


Correct Option: D

AI Explanation

To answer this question, you need to understand the utility used for block level operations against populated tables.

Option A) Tpump - This option is incorrect because Tpump is a Teradata utility used for continuous data loading and updating.

Option B) BulKLoad - This option is incorrect because there is no Teradata utility named BulKLoad.

Option C) FastLoad - This option is incorrect because FastLoad is a Teradata utility used for fast loading of data into empty tables.

Option D) MultiLoad - This option is correct because MultiLoad is a Teradata utility used for block level operations against populated tables. It allows for efficient loading, updating, and deleting of data from tables.

The correct answer is D) MultiLoad. This option is correct because MultiLoad is the utility used for block level operations against populated tables.

- Hide questions