Question 1

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

technology databases

Primary key access
Access via unique index
Table access by ROWID
Full table scan

Answer

Correct Option: C

Question 2

Tables, views , incexes are all part of database objects

technology databases

True
False

Answer

Correct Option: A

Question 3

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

technology databases

DROP
DELETE
CASCADE
TRUNCATE

Answer

Correct Option: D

Question 4

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

technology databases

INSTR
SUBSTRING
SUBSTR
POS

Answer

Correct Option: C

Question 5

AUTONOMUS_TRANSACTION is a

technology databases

Programming technique
Automatically used in all prpgramme
PL/SQL compiler directive
All of the above

Answer

Correct Option: C

Question 6

PACK_MESSAGE is used in

technology databases

queeing
piping
Autonomus transaction
Host I/O

Answer

Correct Option: B

Question 7

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

technology databases

ENCRYPT
DECRYPT
WRAP
UNWRAP

Answer

Correct Option: C

Question 8

Which is true for ROWID% data type

technology databases

Binary data upto 4GB
Character data upto 4 GB
A hexadecimal string representing the unique address of a row in its table
Binary data stored in an external file

Answer

Correct Option: C

Question 9

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

technology databases

ERROR
0
1
0.00

Answer

Correct Option: B

Question 10

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

technology databases

Index
synonym
view
trigger

Answer

Correct Option: C

Question 11

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

technology databases

HAVING clause
ORDER BY clause
Subquery
GROUP BY clause

Answer

Correct Option: C

Question 12

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

technology databases

Roles
Sequences
Synonyms
Index

Answer

Correct Option: D

Question 13

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

MAXVALUE
MINVALUE
CYCLE
INCREMENT BY

Answer

Correct Option: C

Question 14

Which datatypes are alphanumeric?

technology databases

Number
Blob
Char
Raw

Answer

Correct Option: C

Question 15

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

technology databases

exec command
/ command
execute command
None of these

Answer

Correct Option: B

Question 16

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

technology databases

WHERE
FROM
INSERT
UPDATE

Answer

Correct Option: B

Question 17

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

technology databases

DELETE
CREATE
UPDATE
ALTER

Answer

Correct Option: A,C

Question 18

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

technology databases

Hierarchical
Relational
Object Relational
Network

Answer

Correct Option: C

Question 19

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

technology databases

USER_CONSTRAINTS
USER_CONS_COLUMNS
DBA_CONSTRAINTS
DBA_TABLE

Answer

Correct Option: B

Question 20

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

technology databases

Conditional
Sequential
Iterative
Loop

Answer

Correct Option: A

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

databases Online Quiz - 227

Find more quizzes from top tags