• databases Online Quiz - 227
Back
0

databases Online Quiz - 227

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

Which Oracle access method is the fastest way for Oracle to retrieve a single row?

technology databases

  1. Primary key access

  2. Access via unique index

  3. Table access by ROWID

  4. Full table scan

Show answer
Correct Option: C

AI Explanation

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

Option A) Primary key access - This option is a fast way for Oracle to retrieve a single row. When a table has a primary key defined, Oracle can use the primary key index to directly access the specific row based on its primary key value.

Option B) Access via unique index - This option is also a fast way for Oracle to retrieve a single row. When a table has a unique index defined on a column, Oracle can use the unique index to directly access the specific row based on its unique index value.

Option C) Table access by ROWID - This option is the fastest way for Oracle to retrieve a single row. The ROWID is a unique identifier for each row in a table, and Oracle can use the ROWID to directly access the specific row without needing to use an index.

Option D) Full table scan - This option is not the fastest way for Oracle to retrieve a single row. A full table scan involves reading every row in the table, which can be time-consuming and resource-intensive. It is generally used when retrieving multiple rows or when there is no appropriate index available.

The correct answer is C) Table access by ROWID. This option is the fastest way for Oracle to retrieve a single row because it directly accesses the specific row using its unique ROWID identifier.

Tables, views , incexes are all part of database objects

technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

technology databases

  1. DROP

  2. DELETE

  3. CASCADE

  4. TRUNCATE

Show answer
Correct Option: D
Explanation:

To solve this question, the user needs to know the basic SQL commands for deleting data from a table.

Option A: DROP is used to delete an entire table, not just its data. This option is incorrect.

Option B: DELETE is used to delete data from a table. However, it writes the deleted data to the rollback segment in case it needs to be recovered later. This option is incorrect.

Option C: CASCADE is an option used with the DROP command to delete all objects that depend on the specified object before dropping that object. This option is incorrect.

Option D: TRUNCATE is used to delete all data from a table without logging the individual row deletions. It does not write the deleted data to the rollback segment, making it a faster operation compared to DELETE. This option is correct.

Therefore, the answer is: D. TRUNCATE.

Which character function can be used to return a specified portion of a character string?

technology databases

  1. INSTR

  2. SUBSTRING

  3. SUBSTR

  4. POS

Show answer
Correct Option: C

AUTONOMUS_TRANSACTION is a

technology databases

  1. Programming technique

  2. Automatically used in all prpgramme

  3. PL/SQL compiler directive

  4. All of the above

Show answer
Correct Option: C

PACK_MESSAGE is used in

technology databases

  1. queeing

  2. piping

  3. Autonomus transaction

  4. Host I/O

Show answer
Correct Option: B

What is the command used to encrypt a PL/SQL application

technology databases

  1. ENCRYPT

  2. DECRYPT

  3. WRAP

  4. UNWRAP

Show answer
Correct Option: C

Which is true for ROWID% data type

technology databases

  1. Binary data upto 4GB

  2. Character data upto 4 GB

  3. A hexadecimal string representing the unique address of a row in its table

  4. Binary data stored in an external file

Show answer
Correct Option: C
Explanation:

To solve this question, the user needs to know about the ROWID data type in databases.

The ROWID is a pseudo column added by Oracle to all tables, which stores the row's unique identifier. The ROWID is represented in hexadecimal format, and it uniquely identifies each row in a table.

Now, let's go through each option and explain why it is right or wrong:

A. Binary data upto 4GB: This option is incorrect because ROWID is not a data type that stores binary data.

B. Character data upto 4 GB: This option is incorrect because ROWID is not a data type that stores character data.

C. A hexadecimal string representing the unique address of a row in its table: This option is correct. The ROWID data type stores a hexadecimal string that represents the unique address of a row in its table.

D. Binary data stored in an external file: This option is incorrect because ROWID is not a data type that stores binary data in an external file.

The Answer is: C

SELECT ROUND(TRUNC(MOD(1600,10),-1),2)

technology databases

  1. ERROR

  2. 0

  3. 1

  4. 0.00

Show answer
Correct Option: B

What can you create to restrict user access to a table?

technology databases

  1. Index

  2. synonym

  3. view

  4. trigger

Show answer
Correct Option: C

What can be used in a SELECT statement to obtain search criteria for the SELECT statement?

technology databases

  1. HAVING clause

  2. ORDER BY clause

  3. Subquery

  4. GROUP BY clause

Show answer
Correct Option: C

What database object is used to increase performance for accessing data within a database?

technology databases

  1. Roles

  2. Sequences

  3. Synonyms

  4. Index

Show answer
Correct Option: D

Which clause of the CREATE SEQUENCE statement will cause the sequence to continue to generate numbers even after the maximum limit is reached?

technology databases

  1. MAXVALUE

  2. MINVALUE

  3. CYCLE

  4. INCREMENT BY

Show answer
Correct Option: C

Which datatypes are alphanumeric?

technology databases

  1. Number

  2. Blob

  3. Char

  4. Raw

Show answer
Correct Option: C

How do you execute an anonymous block within SQL*Plus?

technology databases

  1. exec command

  2. / command

  3. execute command

  4. None of these

Show answer
Correct Option: B

Where can NOT a subquery be used within a SQL statement that is in a PL/SQL block?

technology databases

  1. WHERE

  2. FROM

  3. INSERT

  4. UPDATE

Show answer
Correct Option: B

What tasks are you able to perform within a PL/SQL block?

technology databases

  1. DELETE

  2. CREATE

  3. UPDATE

  4. ALTER

Show answer
Correct Option: A,C

Which database model allows you to store and execute a PL/SQL program as part of an object?

technology databases

  1. Hierarchical

  2. Relational

  3. Object Relational

  4. Network

Show answer
Correct Option: C

What data dictionary view will display information about the columns in the database that have constraints?

technology databases

  1. USER_CONSTRAINTS

  2. USER_CONS_COLUMNS

  3. DBA_CONSTRAINTS

  4. DBA_TABLE

Show answer
Correct Option: B

What PL/SQL control structure is known as an IF-THEN statement?

technology databases

  1. Conditional

  2. Sequential

  3. Iterative

  4. Loop

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