Tag: technology

Questions Related to technology

When 'select * from ' is given, oracle server checks for..
technology databases

  1. control files

  2. redo log files

  3. user_views data dictionary view

  4. base table

Show answer
Correct Option: C

data type of 'text' column stored in user_view column...

technology databases

  1. varchar2()

  2. long

  3. char()

  4. lob()

Show answer
Correct Option: B

simple view definition contains functions.....
technology databases

  1. True

  2. False

Show answer
Correct Option: B

which one is default one while creating a view...?
technology web technology

  1. force

  2. no force

  3. with read only

  4. with check option

Show answer
Correct Option: B

which one is not the view feature..?
technology databases

  1. restrict data access

  2. fast access

  3. easy maintainance for complex queries

  4. data independence

Show answer
Correct Option: B

Select two methods that correctly overload the following method? (Assume that all necessary packages have been imported). byte bMethod(short i) throws Exception {...}
technology programming languages

  1. int bMethod(int i) throws IOException{...}

  2. protected int bMethod(short s) throws FileNotFoundException{...}

  3. private String aMethod(byte b,short s) throws Exception{...}

  4. char bMethod(String s) throws RuntimeException{...}

  5. int bMethod(short sh){...}

Show answer
Correct Option: A,D

Which of the following statements are infinite loops? Select two correct answers
technology programming languages

  1. for(int i=10;i>0;i-=-2);

  2. for(int i=0;i<012;i=i++);

  3. for(int i=0;i<0;i--);

  4. for(int i=0;(i++^--i)==0;i++);

  5. for(int i=010;i==10;i+=0);

Show answer
Correct Option: B,D

Select two methods that correctly override the following method? (Assume that all necessary packages have been imported). protected int aMethod(int i) throws IOException {...}

technology programming languages

  1. int aMethod(int i) throws IOException{...}

  2. protected int aMethod(int i) throws FileNotFoundException{...}

  3. public int aMethod(int i) throws Exception{...}

  4. public int aMethod(byte i) throws IOException{...}

  5. protected int aMethod(int i) throws IOException,FileNotFoundException{...}

Show answer
Correct Option: B,E

Select three correct statements.

technology programming languages

  1. A static method may override another static method.

  2. A static method cannot override a non-static method.

  3. A non-static method cannot override a static method.

  4. A non-static method may be overloaded by a static method.

  5. A synchronized method cannot be overridden.

Show answer
Correct Option: B,C,D

Which one is useful to check whether the columns in a join view can be updated...?
technology databases

  1. user_views

  2. all_views

  3. user_updatable_columns

  4. dba_views

Show answer
Correct Option: C