PRE TEST QUESTION 1 Which three tasks can be performed using SQL functions built into Oracle Database? A. Displaying a date in a nondefault format B. Finding the number of characters in an expression C. Substituting a character string in a text expression with a specified string D. Combining more than two columns or expressions into a single column in the output Correct Answer: ABC QUESTION 4 You want to display 5 percent of the employees with the highest salaries in the EMPLOYEES table. Which query will generate the required result? A. Option A B. Option B C. Option C D. Option D Correct Answer: D QUESTION 7 Which normal form is a table in if it has no multi-valued attributes and no partial dependencies? A. First normal form B. Second normal form C. Third normal form D. Fourth normal form Correct Answer: B
QUESTION 8 Examine the types and examples of relationships that follow: 1. One-to-one a) Teacher to students 2. One-to-many b) Employees to Manager 3. Many-to-one c) Person to SSN 4. Many-to-many d) Customers to products Which option indicates the correctly matched relationships? A. 1-a, 2-b, 3-c, and 4-d B. 1-c, 2-d, 3-a, and 4-b C. 1-c, 2-a, 3-b, and 4-d D. 1-d, 2-b, 3-a, and 4-c Correct Answer: C QUESTION 12 View the Exhibit and examine the structure of the customers table. NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have the same data types and size as the corresponding columns in the customers table. Evaluate the following insert statement: The insert statement fails when executed. What could be the reason? A. The values clause cannot be used in an INSERT with a subquery. B. Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match. C. The where clause cannot be used in a subquery embedded in an INSERT statement.
- Winter '20
- Paul Manaf
- Database normalization