DBMS_B1_04032020

You need to update the area code of employees that live in Atlanta. Evaluate this partial UPDATE statement:

UPDATE employee SET area_code = 770

Which of the following should you include in your UPDATE statement to achieve the desired results?

• WHERE city = 'Atlanta';

• SET city = 'Atlanta';

• LIKE 'At%';

• UPDATE city = Atlanta;

One employee has the last name of 'King' in the employees table. How many rows will be deleted from the employees table with the following statement?

DELETE FROM employees WHERE last_name = 'king';

• All rows with last_name = 'King' will be deleted

• No rows will be deleted, as no employees match the WHERE-clause.

• One will be deleted, as there exists one employee named King.

• All the rows in the employees table will be deleted.

If a default value was set for a null column, Oracle sets the column to the default value. However, if no default value was set when the column was created, Oracle inserts an empty space.

• True

• False

What is the quickest way to use today's date when you are creating a new row?

• Simply use the keyword DATE in the insert statement.

• Use the TODAYS_DATE function.

• Use the SYSDATE function.

• Simply write today's date in the format 'dd-mon-rrrr'.

Using the INSERT statement and assuming that a column can accept null values, how can you implicitly insert a null value in a column? Mark for Review

• It is not possible to implicitly insert a null value in a column.

• Use the NULL keyword.

• Omit the column in the column list.

• Use the ON clause

When inserting rows into a table, all columns must be given values. True or False?

• True

• False

You want to execute one DML statement to change the salary of all employees in department 10 to equal the new salary of employee number 89898. Currently, all employees in department 10 have the same salary value. Which statement should you execute?

• UPDATE employees SET salary = (SELECT salary FROM employees WHERE employee_id = 89898);

• UPDATE employees SET salary = (SELECT salary FROM employees WHERE employee_id = 89898 AND department_id = 10);

• UPDATE employees SET salary = SELECT salary FROM employees WHERE employee_id = 89898;

• UPDATE employees SET salary = (SELECT salary FROM employees WHERE employee_id = 89898)

  WHERE department_id = 10;

The PLAYERS table contains these columns:

PLAYER_ID NUMBER NOT NULL

PLAYER_LNAME VARCHAR2(20) NOT NULL

PLAYER_FNAME VARCHAR2(10) NOT NULL

TEAM_ID NUMBER

SALARY NUMBER(9,2)

You need to increase the salary of each player for all players on the Tiger team by 12.5 percent. The TEAM_ID value for the Tiger team is 5960. Which statement should you use?

• UPDATE players (salary) SET salary = salary * 1.125;

• UPDATE players SET salary = salary * .125 WHERE team_id = 5960;

• UPDATE players SET salary = salary * 1.125 WHERE team_id = 5960;

• UPDATE players (salary) VALUES(salary * 1.125) WHERE team_id = 5960;

The PRODUCTS table contains these columns:

PROD_ID NUMBER(4)

PROD_NAME VARCHAR2(25)

PROD_PRICE NUMBER(3)

You want to add the following row of data to the PRODUCTS table:

(1) a NULL value in the PROD_ID column

(2) "6-foot nylon leash" in the PROD_NAME column

(3) "10" in the PROD_PRICE column

You issue this statement:

INSERT INTO products

VALUES (null,'6-foot nylon leash', 10);

What row data did you add to the table?

• The row was created completely wrong. No data ended up in the correct columns.

• The row was created with the correct data in two of three columns.

• The row was created with the correct data in all three columns.

• The row was created with the correct data in one of the three columns.

Which statement about the VALUES clause of an INSERT statement is true?

• The VALUES clause in an INSERT statement is mandatory in a subquery.

• If no column list is specified, the values must be listed in the same order that the columns are listed in the table.

• Character, date, and numeric data must be enclosed within single quotes in the VALUES clause.

• To specify a null value in the VALUES clause, use an empty string (" ").