• databases Online Quiz - 117
Back
0

databases Online Quiz - 117

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

Explicit Cursor attributes

technology databases

  1. %Found

  2. %NOTFOUND

  3. %ROWCOUNT

  4. %ISOPEN

Show answer
Correct Option: A,B,C,D

How to view installed Oracle version information

technology databases

  1. select banner from v$version;

  2. select # from v$version;

  3. select ver from v$version

  4. select version from v$version;

Show answer
Correct Option: A

Which of the below arePL/SQL Exceptions

technology databases

  1. No_Data_Found

  2. Too_many_rows

  3. Value_Error

  4. Zero_Error

Show answer
Correct Option: A,B,C,D

The maximum number of triggers we can apply to a single table is 12

technology databases

  1. True

  2. False

Show answer
Correct Option: A

SYSDATE is a pseudo column

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Cursor_Already_Open is a valid Cursor exception?

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Is it possible to have multiple datasources to display a single report?

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Data integrity exists on ACCESS LOCK?

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Data integrity exists on READ LOCK?

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Teradata maintain rows in the received order

technology databases

  1. True

  2. False

Show answer
Correct Option: B

What determines the number of concurrent users to the database ?

technology databases

  1. PMON

  2. CMON

  3. Both

  4. None of the above

Show answer
Correct Option: A

FLOAD can be used to load data in

technology databases

  1. Tables with already existing data

  2. Empty tables

  3. Both 1 & 2

  4. None of the above

Show answer
Correct Option: B

The TOP option can appear in the

technology databases

  1. FROM clause

  2. WHERE clause

  3. Correlated sub query

  4. None of the above

Show answer
Correct Option: C

If the TOP option specifies a number greater than the number of rows in the query result set, then

technology databases

  1. The query returns the rows in the query result set without producing an error.

  2. Return no rows

  3. Produces an error

  4. The query returns rows

Show answer
Correct Option: A

MULTILOAD faster than FLOAD

technology databases

  1. True

  2. False

Show answer
Correct Option: B

In Teradata's parallel environment, response time is as fast as

technology databases

  1. the fastest AMP invloved

  2. slowest AMP involved

  3. sum of all amps involved

  4. average performance of all AMPs

Show answer
Correct Option: B
Explanation:

To answer this question, the user needs to know about Teradata's Parallel Environment.

In Teradata's Parallel Environment, the response time is determined by the slowest AMP involved in the process. This is because the Teradata system is designed to ensure that all AMPs are involved in processing a query or transaction, and the system waits for the slowest AMP to complete its task before returning the results to the user.

Therefore, the correct answer is:

The Answer is: B. slowest AMP involved

How many columns are presented after executing this query: SELECT address1||','||address2||','||address2 "Adress" FROM employee;

technology databases

  1. 2

  2. 1

  3. 3

  4. 0

Show answer
Correct Option: B
Explanation:

To solve this question, the user needs to know how the SQL SELECT statement and concatenation operator (||) work. The SELECT statement retrieves data from a database table and returns a result set. The concatenation operator is used to combine two or more strings into a single string.

The given SQL query concatenates three columns (address1, address2, and address2) using the concatenation operator and then renames the concatenated column as "Address".

The resulting query output will contain only one column named 'Address' that is the result of concatenating the three columns. Therefore, the correct answer is:

The Answer is: B. 1

What output will the follwing statement produce? Select NVL2(NULL,'NOT NULL', NULL) from dual;
technology databases

  1. Null

  2. Not Null

  3. Function NVL2 is not defined

  4. None of The above

Show answer
Correct Option: A

Which three definitions are associated with implicit cursors?

technology databases

  1. %rowtype, %toomanyrows, %found

  2. %found, %notfound, %rowcount

  3. %rowtype, %rowcount, %notfound

  4. None of the above

Show answer
Correct Option: B

Which command will delete all data from a table and will not write to the rollback segment?

technology databases

  1. DROP

  2. DELETE

  3. TRUNCATE

  4. CASCADE

Show answer
Correct Option: C
- 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