Question 1 You can nest subqueries inside all EXCEPT _______ clauses of other su

Question

Question 1

You can nest subqueries inside all EXCEPT _______ clauses of other subqueries.  

HAVING

DISTINCT

WHERE

FROM

Question 2

Oracle 11g also provides the RPAD function, which uses a symbol to pad the right side of a character string to a specific width.

True

False

Question 3

You can specify multiple columns in a GROUP BY clause.

True

False

QUESTION 4

You can insert, update, and delete individual elements in a nested table.

True

False

QUESTION 5

Which of the following syntax is NOT considered a mulitple-row comparison operator?

<ALL

>ANY

>ALL

=SOME

QUESTION 6

What is the difference between deleting all records from a table and truncating the table?

Delete does not save roll back information while truncate does

Truncating does not save roll back information while delete does

Only a DBA can truncate, anyone can delete

Deleting is faster

QUESTION 7

The ______ text item property specifies whether the user can navigate to the item using the Tab key or mouse pointer.

Read-only

Enabled

Tabbable

View

QUESTION 8

Which of the following are not a main type of single-row functions:

regular expression functions

numeric functions

description functions

conversion functions

QUESTION 9

Data in the Oracle database is stored in basic structures called data blocks.  

True

False

QUESTION 10

Which of the following declarations would be most appropriate for storing a dollar value up to $1000?

price NUMBER(5,2)

price NUMBER(2)

price NUMBER(5)

price NUMBER

QUESTION 11

Which of the following statements is false?

An object type can contain attributes and methods.

An object reference can be used to access a row in a object table.

An object type marked as NOT INSTANTIABLE prevents objects from that type from being created.

Object type cannot be used to define a column object or object table

QUESTION 12

When you declare a variable with data type NUMBER, what is the value before you assign a value?

1

-1

100

NULL

QUESTION 13

Which of the following commands can be used to change a password for a user account?

DELETE

ALTER USER

EDIT PASSWORD

CHANGE PASSWORD

QUESTION 14

Once a window has been created the title cannot be changed.

True

False

QUESTION 15

When DDL operations are performed, Oracle places an ______ lock on the table so that no other user can alter the table or attempt adding to or updating the table's contents.

exclusive

biometric

executive

master

QUESTION 16

A shorthand method of identifying a table and its contents is to give the name of the table followed by a list of the column names and data types, separated by commas, within a set of square brackets.

True

False

A.

HAVING

B.

DISTINCT

C.

WHERE

D.

FROM

Explanation / Answer

Answer :

Question 1

You can nest subqueries inside all EXCEPT _______ clauses of other subqueries.  

HAVING

DISTINCT

WHERE

FROM

Answer :

D.FROM

...........

Question 2

Oracle 11g also provides the RPAD function, which uses a symbol to pad the right side of a character string to a specific width.

True

False

Answer :

True

Explanation :

RPAD---uses symbol to pad the right side of a character string with a specific width.

...........

Question 3

You can specify multiple columns in a GROUP BY clause.

True

False

Answer :

True

.......

QUESTION 4

You can insert, update, and delete individual elements in a nested table.

True

False

Answer :

True

...

QUESTION 5

Which of the following syntax is NOT considered a mulitple-row comparison operator?

<ALL

>ANY

>ALL

=SOME

Answer :

D.=SOME

.............

QUESTION 6

What is the difference between deleting all records from a table and truncating the table?

Delete does not save roll back information while truncate does

Truncating does not save roll back information while delete does

Only a DBA can truncate, anyone can delete

Deleting is faster

Answer :

B.Truncating does not save roll back information while delete does

...........

QUESTION 13

Which of the following commands can be used to change a password for a user account?

DELETE

ALTER USER

EDIT PASSWORD

CHANGE PASSWORD

Answer :

B.ALTER USER

...............

QUESTION 14

Once a window has been created the title cannot be changed.

True

False

Answer :

True

............

QUESTION 15

When DDL operations are performed, Oracle places an ______ lock on the table so that no other user can alter the table or attempt adding to or updating the table's contents.

exclusive

biometric

executive

master

Answer :

A.exclusive

Explanation :

When DDL operations are performed, Oracle places an exclusive lock on the table so that no other user can alter the table or attempt adding to or updating the table's contents.

............

A.

HAVING

B.

DISTINCT

C.

WHERE

D.

FROM

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.