In SQL, which command(s) is(are) used to enable/disable a database trigger?

When using SQL*Plus, Oracle commands, column names, table names and all other database elements:

A

are case insensitive.

B

are case sensitive.

C

must always be in lower case.

D

must always be in upper case.

In an enterprise-class database system, business users interact directly with database applications, which directly access the database data.

A

True

B

False

In an Enterprise-class database system, business users interact directly with database applications that interact with the DBMS, which directly accesses the database data.

A

True

B

False

Which of the following is an SQL trigger supported by Oracle?

A

BEFORE

B

INSTEAD OF

C

AFTER

D

None of the above

In SQL, which of the following is not a data Manipulation Language Commands?

A

Delete

B

Truncate

C

Update

D

Create

SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.

A

True

B

False

Which command is used to remove an index from the database in SQL?

A

DELETE INDEX

B

DROP INDEX

C

REMOVE INDEX

D

ROLL BACK INDEX

E

None of the above

Which command is used to remove a table from the database in SQL?

A

DELETE TABLE

B

DROP TABLE

C

ERASE TABLE

D

UNATTACH TABLE

E

None of the above

In SQL, which command is used to create a database user?

A

ADD USER TO DATABASE

B

MK USER

C

CREATE USER

D

All of the above

E

None of the above

In SQL, which command is used to remove a stored function from the database?

A

REMOVE FUNCTION

B

DELETE FUNCTION

C

DROP FUNCTION

D

ERASE FUNCTION

E

None of the above

In SQL, which command(s) is(are) used to enable/disable a database trigger?

Related Questions