8. You have successfully implemented a J2EE solution for a client. The client has become concerned that it’s database may be vulnerable to malicious attach (hacking) . What do you suggest as a solution? (Select the best solution)
A. Tell him you have tested the code and see no way in which access can be compromised.
B. Suggest creating a DMZ for the Web and Application Servers
C. Suggest creating a DBZ for the Web Server
D. Suggest a secure solution is possible by switching to SSL and issuing X500 certificates to each client.9. Your J2EE solution that you implemented has been a huge success. The number of customers is almost 5 times what has been anticipated and performance is becoming an issue. (select the best two)
A. Add more RAM to the 4 processor 4GB RAM AppServer
B. Add another AppServer set the webconnector to round-robin
C. Add a second network (LAN) card to the web server
D. Upgrade the database hardware10. Look at the diagram below, what is true
funcA()
funB()
A. funcA() is invoked by ObjA
B. funB() is a method of ObjB
C. funcB() returns type ObjC11. Look at the diagram below, what is trueA. classA is a type of classC
B. classA is a singleton
C. classB is a type of classA
D. classC is accessed by classA12. Which two types explicitly support writing programs for international audiences? (choose 2)
A. int primitive type
B. char primitive type
C. java.lang.String class
D. java.lang.Integer class
Oracle 8i
1. You issue the SQL*Plus command SPOOL ON. Which task is accomplished?
A. The next screen output from the SQL*Plus session is saved into a file named afiedt.buf.
B. The next screen output from the SQL*Plus session is saved into a file named ON.lst
C. The next screen output from the SQL*Plus session is sent to a printer.
D. Nothing happens, a file name is missing from the command.2. I want to update table TAB1 using a select clause like below:
update TAB1 set (col1,col2)=(select col1,col2 from tab2 where col1=’abc’)
where col2=’def’
I execute this SQL clause but failed, the reason is:
A. Grammar error.
B. Select clause returned no rows
C. Select clause returned more than one row.
D. Select clause returned only one row.3. What is the advantage of using the %TYPE attribute to declare a PL/SQL type?
A. The name of an unused column in the underlying table may change.
B. The data types or data type sizes of the underlying table columns may change by runtime.
C. The %TYPE attribute forces the data type of the underlying database table column to be what you specify.
D. All column constraints are applied to the variables declared using %TYPE.4. The PL/SQL executable section contains which type of statements?
A. PL/SQL and SQL statements to manipulate data in the database
B. The procedure or function name and input/output variable definitions
C. The definition of program variables, constants, exceptions, and cursors
D. Statements to deal with error handling5. Which three are true regarding the use of outer joins? (Choose three)
A. You cannot use IN operator in a condition that involves an outerjoin.
B. You use (+) on both sides of the WHERE condition to perform an outerjoin.
C. You use (*) on both sides of the WHERE condition to perform an outerjoin.
D. You use an outerjoin to see only the rows that do not meet the join condition.
E. In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.
F. You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.
A. Tell him you have tested the code and see no way in which access can be compromised.
B. Suggest creating a DMZ for the Web and Application Servers
C. Suggest creating a DBZ for the Web Server
D. Suggest a secure solution is possible by switching to SSL and issuing X500 certificates to each client.9. Your J2EE solution that you implemented has been a huge success. The number of customers is almost 5 times what has been anticipated and performance is becoming an issue. (select the best two)
A. Add more RAM to the 4 processor 4GB RAM AppServer
B. Add another AppServer set the webconnector to round-robin
C. Add a second network (LAN) card to the web server
D. Upgrade the database hardware10. Look at the diagram below, what is true
funcA()
funB()
A. funcA() is invoked by ObjA
B. funB() is a method of ObjB
C. funcB() returns type ObjC11. Look at the diagram below, what is trueA. classA is a type of classC
B. classA is a singleton
C. classB is a type of classA
D. classC is accessed by classA12. Which two types explicitly support writing programs for international audiences? (choose 2)
A. int primitive type
B. char primitive type
C. java.lang.String class
D. java.lang.Integer class
Oracle 8i
1. You issue the SQL*Plus command SPOOL ON. Which task is accomplished?
A. The next screen output from the SQL*Plus session is saved into a file named afiedt.buf.
B. The next screen output from the SQL*Plus session is saved into a file named ON.lst
C. The next screen output from the SQL*Plus session is sent to a printer.
D. Nothing happens, a file name is missing from the command.2. I want to update table TAB1 using a select clause like below:
update TAB1 set (col1,col2)=(select col1,col2 from tab2 where col1=’abc’)
where col2=’def’
I execute this SQL clause but failed, the reason is:
A. Grammar error.
B. Select clause returned no rows
C. Select clause returned more than one row.
D. Select clause returned only one row.3. What is the advantage of using the %TYPE attribute to declare a PL/SQL type?
A. The name of an unused column in the underlying table may change.
B. The data types or data type sizes of the underlying table columns may change by runtime.
C. The %TYPE attribute forces the data type of the underlying database table column to be what you specify.
D. All column constraints are applied to the variables declared using %TYPE.4. The PL/SQL executable section contains which type of statements?
A. PL/SQL and SQL statements to manipulate data in the database
B. The procedure or function name and input/output variable definitions
C. The definition of program variables, constants, exceptions, and cursors
D. Statements to deal with error handling5. Which three are true regarding the use of outer joins? (Choose three)
A. You cannot use IN operator in a condition that involves an outerjoin.
B. You use (+) on both sides of the WHERE condition to perform an outerjoin.
C. You use (*) on both sides of the WHERE condition to perform an outerjoin.
D. You use an outerjoin to see only the rows that do not meet the join condition.
E. In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.
F. You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.
LAST_NAME DEPARTMENT_ID SALARY
Getz 10 3000
Davis 20 1500
King 20 2200
Davis 30 5000
Which three subqueries work? (Choose three)
A. SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department.id);
B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);
C. SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);
D. SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);
E. SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);
F. SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));7. Evaluate the following Oracle SQL statement:
SELECT a.emp_name, a.sal, a.dept_id, b.maxsal
FROM employees a,
(SELECT dept_id, MAX(sal) maxsal
FROM employees
GROUP BY dept_id) b
WHERE a.dept_id = b.dept_id
AND a.sal < b.maxsal;What is the result of the statement?
A. The statement produces an error at line 1.
B. The statement produces an error at line 3.
C. The statement produces an error at line 6.
D. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.
E. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.8. You want to display the titles of books that meet these criteria:
1. Purchased before January 21, 2001
2. Price is less then $500 or greater than $900
You want to sort the results by their data of purchase, starting with the most recently bought book.Which statement should you use?
A. SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase_date;
B. SELECT book_title FROM books WHERE price IN (500,900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date ASC;
C. SELECT book_title FROM books WHERE price < 500 or > 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;
D. SELECT book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;9. CREATE TABLE orders
(SER_NO NUMBER UNIQUE,
ORDER_ID NUMBER,
ORDER_DATE DATE NOT NULL
STATUS VARCHARD2(10)
CHECK (status IN (‘CREDIT’,’CASH’)), PROD_ID_NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order id, order date));For which columns would an index be automatically created when you execute the above SQL statement? (Choose two)
A. SER_NO
B. ORDER_ID
C. STATUS
D. PROD_ID
E. ORD_TOTAL
F. Composite index on ORDER_ID and ORDER_DATE10. Examine the description of the STUDENTS table:
STD_ID NUMBER(4)
COURSE_ID VARCHARD2(10)
START_DATE DATE
END_DATE DATEWhich two aggregate functions are valid on the START_DATE column? (Choose two)
A. SUM(start_date)
B. AVG(start_date)
C. COUNT(start_date)
D. AVG(start_date, end_date)
E. MIN(start_date)
F. MAXIMUM(start_date)11. For which two constraints does the Oracle Server implicitly create a unique index?
(Choose two.)
A. NOT NULL
B. PRIMARY KEY
C. FOREIGN KEY
D. CHECK
E. UNIQUE 16. I have the following table that contains all my students in my class.
--------------------------------------------------------------------------------------
Table name: Students
Column: Name Varchar2 (40)
Score Number (5,2)
-------------------------------------------------------------------------------------
I want to give scholarship to those on top 3 scores (not top 3 persons, as there may be 4 with 100 s, 3 with 99 s, 5 with 97 s, …etc)
Please use one SQL statement to show me the name and score of the top 3 scores.
B
E
B
B
B
D
D