• databases Online Quiz - 63
Back
0

databases Online Quiz - 63

Description: databases Online Quiz - 63
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

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

  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 =

Show answer
Correct Option: C

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

technology databases

  1. 32767

  2. 1024

  3. 255

  4. 32765

Show answer
Correct Option: A

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

  1. 10000000

  2. 1000000

  3. 100000

  4. 1000

Show answer
Correct Option: B

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

  1. TO_CHAR, INOUT

  2. PROC, PACKAGE

  3. PRAGMA, MULTI_ROW

  4. SELECT, EXCEPTION

Show answer
Correct Option: D

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

technology databases

  1. SET AUTOTRACE TRACEONLY

  2. SET AUTOTRACE ON

  3. SET AUTOTRACE ON STATISTICS

  4. SET AUTOTRACE ON EXPLAIN

Show answer
Correct Option: B

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

  1. Comment marker

  2. Not equal to operator

  3. Label delimiter

  4. Greater than or equal to operator

Show answer
Correct Option: C

Which one of the following is a valid RAISE_APPLICATION_ERROR call?
technology databases

  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);

Show answer
Correct Option: B

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

  1. SQL%ROWCOUNT

  2. SQL%COUNT

  3. SQL%FOUND

  4. SQL%NUM_ROWS

Show answer
Correct Option: A
  1. Which of the following are two architectural attributes of a Teradata System?
technology databases

  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

Show answer
Correct Option: C,D

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

technology databases

  1. Teradata SQL Assistant

  2. BTEQ

  3. Teradata Manager

  4. TDQM

Show answer
Correct Option: D

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

technology databases

  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.

Show answer
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)

technology databases

  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.

Show answer
Correct Option: B,C

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

  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.

Show answer
Correct Option: A,B

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

technology databases

  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

Show answer
Correct Option: A,B

What option can best describe Teradata’s architecture?

technology databases

  1. Shared everything

  2. Shared memory

  3. Shared nothing

  4. Shared data

Show answer
Correct Option: C

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

technology databases

  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.

Show answer
Correct Option: A

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

technology databases

  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

Show answer
Correct Option: A,C

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

technology databases

  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

Show answer
Correct Option: B

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

  1. BTEQ

  2. Teradata SQL Assistant

  3. Teradata Manager

  4. TDQM

Show answer
Correct Option: B

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

  1. Tpump

  2. BulKLoad

  3. FastLoad

  4. MultiLoad

Show answer
Correct Option: D
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions