tailieunhanh - Practice Exam

How do you implement relationships between entities of an ER diagram in the Oracle database? A. Create a primary key constraint B. Create a unique key constraint C. Create a foreign key constraint D. Create an index | Practice Exam 000 SYBEX Inc. Alameda CA 1. How do you implement relationships between entities of an ER diagram in the Oracle database A. Create a primary key constraint B. Create a unique key constraint C. Create a foreign key constraint D. Create an index 2. Which stage comes after the Analysis stage in the application development cycle A. Implementation B. Testing C. Design D. Development 3. Which datatype declaration in a column would compare MARK and MARK as the same. A. VARCHAR 10 B. CHAR 10 C. VARCHAR2 10 D. LONG 4. What will happen when you enter the following command at the SQL Plus prompt DEFINE sAlARY A. A user variable named salary is created and assigned a value of 0. B. The value of the user-defined variable salary is displayed if the variable is not defined a message is displayed stating the variable is not defined. C. A user variable named salary is created and no value is assigned. D. The value of user-defined variable salary is removed. Copyright 2000 SYBEX Inc. Alameda CA 447 5. You query the database with the following SELECT PRODUCT_ID FROM PRODUCTS WHERE PRODUCT_ID LIKE S _J _C ESCAPE Choose two PRODUCT_ID strings from the options that will satisfy the query. A. BTS_J_C B. SJC C. SKJKC D. S_J_C 6. The EMPLOYEE table is defined as follows EMP_NAME VARCHAR2 40 HIRE_DATE DATE SALARY NUMBER 14 2 Which query is most appropriate to use if you need to find the employees who were hired before 01-Jan-1998 and have a salary above 5000 or below 1000 A. SELECT emp_name FROM employee WHERE hire_date TO_DATE 01011998 MMDDYYYY AND SALARY 1000 OR 5000 B. SELECT emp_name FROM employee WHERE hire_date TO_DATE 01011998 MMDDYYYY AND SALARY 1000 OR SALARY 5000 C. SELECT emp_name FROM employee WHERE hire_date TO_DATE 01011998 MMDDYYYY AND SALARY 1000 OR SALARY 5000 D. SELECT emp_name FROM employee WHERE hire_date TO_DATE 01011998 MMDDYYYY AND SALARY BETWEEN 1000 AND 5000 Copyright 2000 SYBEX Inc. Alameda CA .