Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?

Show Answer Hide Answer

The creator of an index or an index specification automatically receives which privilege on the index?

Show Answer Hide Answer

Application 1 executes the following statements:

INSERT INTO TAB1 (NAME,AMOUNT) VALUES ('John,100);

COMMIT;

UPDATE TAB1 SET AMOUNT=90 WHERE NAME='John';

After a few seconds, application 2 executes the following query:

SELECT AMOUNT FROM TAB1 WHERE NAME='John'

Assuming the Currently Committed (CUR_COMMIT) configuration parameter is enabled, which of the following is TRUE?

Show Answer Hide Answer

Below are the SQL statements a DBA is planning to execute on a database:

CREATE TABLE t1 (name VARCHAR (1));

INSERT INTO t1 VALUES ('A'), ('B'), ('C'), ('D');

ALTER TABLE t1 ALTER COLUMN name SET DATA TYPE INT;

What will be the outcome of the last statement?

Show Answer Hide Answer

How can you tell what privileges on a table or view have been granted to a user? (Choose two.)

Show Answer Hide Answer