Tag: technology

Questions Related to technology

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 is the value of x and y after running this code? class a { public static void main(String args[]) { int x=1; int y=x++; } }
technology programming languages

  1. x=1 and y=1

  2. x=1 and y=2

  3. x=2 and y=2

  4. x=2 and y=1

Show answer
Correct Option: D

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.

The command "whoami" is used to
technology

  1. Returns error.

  2. Lists your last logins.

  3. Returns your username.

  4. Tells you where you currently are.

Show answer
Correct Option: C

The command "wc" is used to
technology

  1. Compares files, and shows where they differ.

  2. Tells you how many lines, words, and characters there are in a file.

  3. Removes a file

  4. Shows the first part of a file.

Show answer
Correct Option: B

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

The "write" command is used to
technology

  1. Lets you write data in file.

  2. Lets you change the read, write, and execute permissions on your files

  3. Converts plain text files into postscript for printing

  4. Lets you exchange one-line messages with another user

Show answer
Correct Option: D

what is the value of x and y after running this code? class a { public static void main(String args[]) { int x=1; int y=x++; } }
technology programming languages

  1. x=1 and y=1

  2. x=2 and y=2

  3. x=1 and y=2

  4. x=2 and y=1

Show answer
Correct Option: D

What is the output:class a { public static void main (String args[]) { int x; int y=10; if (y>0) { x = 10; } System.out.println(x); } }
technology programming languages

  1. 10

  2. 0

  3. Garbage Value

  4. Compile time error

Show answer
Correct Option: D

The command "who" is used to
technology

  1. Show disk space available on the system

  2. Show the last few lines of a file

  3. Show who are all logged into the local system

  4. Show error

Show answer
Correct Option: C