Tag: databases

Questions Related to databases

How do you handle an Exception?
technology databases

  1. a) Trap it with a Handler

  2. b) Propagate it to the Calling Environment

  3. c) a & then b

  4. d) b & then a

Show answer
Correct Option: C

This statement fails when executed: CREATE OR REPLACE TRI GGER CALC_TEAM_AVG AFTER I NSERT ON PLAYER BEGIN INSERT INTO PLAYER_BATSTAT ( PLAYER_I D, SEASON_YEAR, AT_BATS, HI TS) VALUES ( : NEW. I D, 1 997, 0, 0) ; END; To which type must you convert the trigger to correct the error?
technology databases

  1. a) Row

  2. b) Statement

  3. c) ORACLE FORM trigger

  4. d) Before

Show answer
Correct Option: A

Which type of argument passes a value from a calling environment?
technology databases

  1. a) VARCHER2.

  2. b) BOOLEAN.

  3. c) OUT.

  4. d) IN.

Show answer
Correct Option: D
Explanation:

To answer this question, the user needs to have knowledge of different types of arguments in programming.

a) VARCHER2: This is not a type of argument. It is a data type used to store character strings in Oracle database.

b) BOOLEAN: This is not a type of argument that passes a value from a calling environment.

c) OUT: This type of argument passes a value to the calling environment. It is used when a function or procedure needs to return more than one value.

d) IN: This type of argument passes a value from the calling environment to the function or procedure. It is used when a function or procedure needs to receive values from the calling environment.

Therefore, the correct answer is:

The Answer is: D. IN.

All users currently have the INSERT privileges on the PLAYER table. You want only your users to insert into this table using the ADD_PLAYER procedure. Which two actions must you take? (Choose two)
technology databases

  1. a) GRANT SELECT ON ADD_PLAYER TO PUBLIC;

  2. b) GRANT EXECUTE ON ADD_PLAYER TO PUBLIC;

  3. c) GRANT INSERT ON PLAYER TO PUBLIC;

  4. d) GRANT EXECUTE, INSERT ON ADD_PLAYER TO PUBLIC;

  5. e) REVOKE INSERT ON PLAYER FROM PUBLIC;

Show answer
Correct Option: B,E

SQL is a procedural language?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

With optimistic locking a user may have to redo their work when a conflict occurs?
technology databases

  1. True

  2. False

Show answer
Correct Option: A
Explanation:

The answer is: A

Explanation:

Optimistic locking is a technique used to prevent data conflicts in a multi-user environment. It involves checking for conflicts only at the time of update, that is, when a user tries to modify a piece of data that may have already been modified by another user. If a conflict is detected, the optimistic locking mechanism rolls back the transaction and the user has to redo their work. Therefore, option A is correct. Option B is incorrect because it contradicts the explanation given above.

The two types of SQL environment are interactive and embedded?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Catch_#22 valid column name?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

In a select with a group by clause, a where clause, and a having clause, the where conditions are applied before the having conditions?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which statement about a table is true?
technology databases

  1. A table can have up to 10,000 columns.

  2. The size of a table does NOT need to be specified

  3. A table CANNOT be created while users are using the database

  4. The structure of a table CANNOT be modified while the table is online

Show answer
Correct Option: B