GoConqr has a new look! Let us know what you think.

Sign up free

Flashcards

Oracle Practice Exam 3

Amber Saxon Oracle SQL English 120 cards

Cards in this deck (120)

  1. 1The 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? a) The row was created completely wrong. No data ended up in the correct columns. b) The row was created with the correct data in two of three columns. c) The row was created with the correct data in all three columns. d) The row was created with the correct data in one of the three columns.c) The row was created with the correct data in all three columns.
  2. 2Which statement about the VALUES clause of an INSERT statement is true? a) The VALUES clause in an INSERT statement is mandatory in a subquery. b) If no column list is specified, the values must be listed in the same order that the columns are listed in the table. c) Character, date, and numeric data must be enclosed within single quotes in the VALUES clause. d) To specify a null value in the VALUES clause, use an empty string (" ").b) If no column list is specified, the values must be listed in the same order that the columns are listed in the table.
  3. 3You need to add a row to an existing table. Which DML statement should you use? a) DELETE b) CREATE c) INSERT d) UPDATEc) INSERT
  4. 4Assume all the column names are correct. The following SQL statement will execute which of the following? INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (70, 'Public Relations', 100, 1700); a) 'Public Relations' will be inserted into the manager_name column. b) 70 will be inserted into the department_id column. c) 100 will be inserted into the department_id column. d) 1700 will be inserted into the manager_id column.b) 70 will be inserted into the department_id column.
  5. 5You have been instructed to add a new customer to the CUSTOMERS table. Because the new customer has not had a credit check, you should not add an amount to the CREDIT column. The CUSTOMERS table contains these columns: CUST_ID NUMBER(10) COMPANY VARCHAR2(30) CREDIT NUMBER(10) POC VARCHAR2(30) LOCATION VARCHAR2(30) Which two INSERT statements will accomplish your objective? a) INSERT INTO customers VALUES (200, 'InterCargo', null, 'tflanders', 'samerica'); b) INSERT INTO customers VALUES (200, InterCargo, 0, tflanders, samerica); c) INSERT INTO customers (cust_id, company, poc, location) VALUES (200, 'InterCargo', 'tflanders', 'samerica'); d) INSERT INTO customers VALUES (cust_id, company, credit, poc, location) (200, 'InterCargo', 0, 'tflanders', 'samerica');a) INSERT INTO customers
    VALUES (200, 'InterCargo', null, 'tflanders', 'samerica');
    c) INSERT INTO customers (cust_id, company, poc, location)
    VALUES (200, 'InterCargo', 'tflanders', 'samerica');
  6. 6When inserting rows into a table, all columns must be given values. True or False? a) True b) Falseb) False
  7. 7If the employees table has 7 rows, how many rows are inserted into the copy_emps table with the following statement: INSERT INTO copy_emps (employee_id, first_name, last_name, salary, department_id) SELECT employee_id, first_name, last_name, salary, department_id FROM employees a) 7 rows, as no WHERE-clause restricts the rows returned on the subquery. b) 10 rows will be created. c) No rows, as the SELECT statement is invalid. d) No rows, as you cannot use subqueries in an insert statement.a) 7 rows, as no WHERE-clause restricts the rows returned on the subquery.
  8. 8A column in a table can be given a default value. This option prevents NULL values from automatically being assigned to the column if a row is inserted without a specified value for the column. True or False ? a) True b) Falsea) True
  9. 9A multi-table insert statement can insert into more than one table. (True or False?) a) True b) Falsea) True
  10. 10Multi-table inserts can be conditional or unconditional. True or False? a) True b) Falsea) True
  11. 11If 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 or False? a) True b) Falseb) False
  12. 12A DEFAULT value can be specified for a column when the table is created. True or false? a) True b) Falsea) True
  13. 13Evaluate this statement: DELETE FROM customer; Which statement is true? Mark for Review (1) Points a) The statement deletes the first row in the CUSTOMERS table. b) The statement deletes all the rows from the CUSTOMER table. c) The statement deletes the CUSTOMER column. d) The statement removes the structure of the CUSTOMER table from the database.b) The statement deletes all the rows from the CUSTOMER table.
  14. 14Which of the following represents the correct syntax for an INSERT statement? a) INSERT VALUES INTO customers (3178 J. Smith 123 Main Street Nashville TN 37777; b) INSERT INTO customers VALUES '3178' 'J.' 'Smith' '123 Main Street' 'Nashville' 'TN' '37777'; c) INSERT INTO customers VALUES ('3178', 'J.', 'Smith', '123 Main Street', 'Nashville', 'TN', '37777'); d) INSERT customers VALUES 3178, J., Smith, 123 Main Street, Nashville, TN, 37777;c) INSERT INTO customers VALUES ('3178', 'J.', 'Smith', '123 Main Street', 'Nashville', 'TN', '37777');
  15. 15Examine the structures of the PLAYERS, MANAGERS, and TEAMS tables: PLAYERS: PLAYER_ID NUMBER Primary Key LAST_NAME VARCHAR2 (30) FIRST_NAME VARCHAR2 (25) TEAM_ID NUMBER MGR_ID NUMBER SIGNING_BONUS NUMBER(9,2) SALARY NUMBER(9,2) MANAGERS: MANAGER_ID NUMBER Primary Key LAST_NAME VARCHAR2 (20) FIRST_NAME VARCHAR2 (20) TEAM_ID NUMBER TEAMS: TEAM_ID NUMBER Primary Key TEAM_NAME VARCHAR2 (20) OWNER_LAST_NAME VARCHAR2 (20) OWNER_FIRST_NAME VARCHAR2 (20) Which situation would require a subquery to return the desired result? a) To display the names of each player on the Lions team b) To display the maximum and minimum player salary for each team c) To display the names of the managers for all the teams owned by a given owner d) To display each player, their manager, and their team name for all teams with an id value greater than 5000c) To display the names of the managers for all the teams owned by a given owner
  16. 16If the subquery returns one row, how many rows will be deleted from the employees table? DELETE FROM employees WHERE department_id = (SELECT department_id FROM departments WHERE department_name LIKE '%Public%'); b) No rows will be deleted. c) One row will be deleted, as the subquery only returns one row. d) All rows in the employees table of employees who work in the given department will be deleted. e) All rows in the employees table will be deleted, no matter the department_id.d) All rows in the employees table of employees who work in the given department will be deleted.
  17. 17A column in a table can be given a default value. This option prevents NULL values from automatically being assigned to the column if a row is inserted without a specified value for the column. True or False ? a) True c) Falsea) True
  18. 18In a conditional multi-table insert, you can specify either __________ or __________. a) First; Second b) All; First c) All; Second d) Null; Defaultb) All; First
  19. 19The default value must match the __________ of the column. a) Table b) Datatype c) Size d) Column nameb) Datatype
  20. 20One of the sales representatives, Janet Roper, has informed you that she was recently married, and she has requested that you update her name in the employee database. Her new last name is Cooper. Janet is the only person with the last name of Roper that is employed by the company. The EMPLOYEES table contains these columns and all data is stored in lowercase: EMPLOYEE_ID NUMBER(10) PRIMARY KEY LAST_NAME VARCHAR2(20) FIRST_NAME VARCHAR2(20) DEPARTMENT_ID VARCHAR2 (20) HIRE_DATE DATE SALARY NUMBER(10) Which UPDATE statement will accomplish your objective? a) UPDATE employees last_name = 'cooper' WHERE last_name = 'roper'; b) UPDATE employees SET cooper = 'last_name' WHERE last_name = 'roper'; c) UPDATE employees SET last_name = 'roper' WHERE last_name = 'cooper'; d) UPDATE employees SET last_name = 'cooper' WHERE last_name = 'roper';d) UPDATE employees
    SET last_name = 'cooper'
    WHERE last_name = 'roper';
  21. 21When the WHERE clause is missing in a DELETE statement, what is the result? a) The table is removed from the database. b) All rows are deleted from the table. c) An error message is displayed indicating incorrect syntax. d) Nothing. The statement will not execute.b) All rows are deleted from the table.
  22. 22DELETE FROM customer; Which statement is true? a) The statement deletes all the rows from the CUSTOMER table. b) The statement deletes the CUSTOMER column. c) The statement deletes the first row in the CUSTOMERS table. d) The statement removes the structure of the CUSTOMER table from the database.a) The statement deletes all the rows from the CUSTOMER table.
  23. 23The STUDENTS table contains these columns: STU_ID NUMBER(9) NOT NULL LAST_NAME VARCHAR2 (30) NOT NULL FIRST_NAME VARCHAR2 (25) NOT NULL DOB DATE STU_TYPE_ID VARCHAR2(1) NOT NULL ENROLL_DATE DATE You create another table, named FT_STUDENTS, with an identical structure.You want to insert all full-time students who have a STU_TYPE_ID value of "F" into the new table. You execute this INSERT statement: INSERT INTO ft_students (SELECT stu_id, last_name, first_name, dob, stu_type_id, enroll_date FROM students WHERE UPPER(stu_type_id) = 'F'); What is the result of executing this INSERT statement? a) An error occurs because you CANNOT use a subquery in an INSERT statement. b) An error occurs because the INSERT statement does NOT contain a VALUES clause. c) All full-time students are inserted into the FT_STUDENTS table. d) An error occurs because the FT_STUDENTS table already exists.c) All full-time students are inserted into the FT_STUDENTS table.
  24. 24You need to copy rows from the EMPLOYEE table to the EMPLOYEE_HIST table. What could you use in the INSERT statement to accomplish this task? a) A function b) A SET clause c) A subquery d) An ON clausec) A subquery
  25. 25When inserting a new row, the null keyword can be included in the values list for any column that allows nulls. True or False? a) True d) Falsea) True
  26. 26Using the INSERT statement and assuming that a column can accept null values, how can you implicitly insert a null value in a column? a) Use the ON clause b) It is not possible to implicitly insert a null value in a column. c) Omit the column in the column list. d) Use the NULL keyword.c) Omit the column in the column list.
  27. 27Is it possible to insert more than one row at a time using an INSERT statement with a VALUES clause? a) No, you can only create one row at a time when using the VALUES clause. b) No, there is no such thing as INSERT ... VALUES. c) Yes, you can just list as many rows as you want; just remember to separate the rows with commas.a) No, you can only create one row at a time when using the VALUES clause. (*)
  28. 28Examine the structures of the PLAYERS, MANAGERS, and TEAMS tables: PLAYERS: PLAYER_ID NUMBER Primary Key LAST_NAME VARCHAR2 (30) FIRST_NAME VARCHAR2 (25) TEAM_ID NUMBER MGR_ID NUMBER SIGNING_BONUS NUMBER(9,2) SALARY NUMBER(9,2) MANAGERS: MANAGER_ID NUMBER Primary Key LAST_NAME VARCHAR2 (20) FIRST_NAME VARCHAR2 (20) TEAM_ID NUMBER TEAMS: TEAM_ID NUMBER Primary Key TEAM_NAME VARCHAR2 (20) OWNER_LAST_NAME VARCHAR2 (20) OWNER_FIRST_NAME VARCHAR2 (20) Which situation would require a subquery to return the desired result? a) To display the names of each player on the Lions team b) To display the maximum and minimum player salary for each team c) To display the names of the managers for all the teams owned by a given owner d) To display each player, their manager, and their team name for all teams with an id value greater than 5000c) To display the names of the managers for all the teams owned by a given owner
  29. 29To change an existing row in a table, you can use the UPDATE or INSERT statements. True or False? a) True b) Falseb) False (*)
  30. 30The TEACHERS and CLASS_ASSIGNMENTS tables contain these columns: TEACHERS: TEACHER_ID NUMBER(5) NAME VARCHAR2(25) SUBJECT_ID NUMBER(5) HIRE_DATE DATE SALARY NUMBER(9,2) CLASS_ASSIGNMENTS: CLASS_ID NUMBER(5) TEACHER_ID NUMBER(5) START_DATE DATE MAX_CAPACITY NUMBER(3) Which scenario would require a subquery to return the desired results? a) You need to display the start date for each class taught by a given teacher. b) You need to create a report to display the teachers who were hired more than five years ago. c) You need to display the names of the teachers who teach classes that start within the next week. d) You need to create a report to display the teachers who teach more classes than the average number of classes taught by each teacher.d) You need to create a report to display the teachers who teach more classes than the average number of classes taught by each teacher.
  31. 31The DEFAULT keyword can be used in the following statements: a) INSERT and UPDATE b) INSERT and DELETE c) DELETE and UPDATE d) All of the abovea) INSERT and UPDATE
  32. 32If you are performing an UPDATE statement with a subquery, it MUST be a correlated subquery? (True or False) a) True b) Falseb) False
  33. 33You need to update both the DEPARTMENT_ID and LOCATION_ID columns in the EMPLOYEES table using one UPDATE statement. Which clause should you include in the UPDATE statement to update multiple columns? a) The SET clause b) The WHERE clause c) The USING clause d) The ON clausea) The SET clause
  34. 34You need to delete a record in the EMPLOYEES table for Tim Jones, whose unique employee identification number is 348. The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(5) PRIMARY KEY LAST_NAME VARCHAR2(20) FIRST_NAME VARCHAR2(20) ADDRESS VARCHAR2(30) PHONE NUMBER(10) Which DELETE statement will delete the appropriate record without deleting any additional records? a) DELETE * FROM employees WHERE employee_id = 348; b) DELETE FROM employees WHERE last_name = jones; c) DELETE 'jones' FROM employees; d) DELETE FROM employees WHERE employee_id = 348;d) DELETE FROM employees
    WHERE employee_id = 348;
  35. 35When inserting a new row, the null keyword can be included in the values list for any column that allows nulls. True or False? a) True b) Falsea) True
  36. 36A column that will be used to store binary data up to 4 Gigabytes in size should be defined as which datatype? a) BLOB b) LONG c) NUMBER d) LONGRAWa) BLOB
  37. 37You are designing a table for the Sales department. You need to include a column that contains each sales total. Which data type should you specify for this column? a) DATE b) VARCHAR2 c) CHAR d) NUMBERd) NUMBER
  38. 38The ELEMENTS column is defined as: NUMBER(6,4) How many digits to the right of the decimal point are allowed for the ELEMENTS column? a) Four b) Zero c) Six d) Twoa) Four
  39. 39Evaluate this CREATE TABLE statement: CREATE TABLE sales ( sales_id NUMBER(9), customer_id NUMBER(9), employee_id NUMBER(9), description VARCHAR2(30), sale_date TIMESTAMP WITH LOCAL TIME ZONE DEFAULT SYSDATE, sale_amount NUMBER(7,2)); Which business requirement will this statement accomplish? a) All employee identification values are only 6 digits so the column should be variable in length. b) Today's date should be used if no value is provided for the sale date. c) Sales identification values could be either numbers or characters, or a combination of both. d) Description values can range from 0 to 30 characters so the column should be fixed in length.b) Today's date should be used if no value is provided for the sale date.
  40. 40Which of the following are valid Oracle datatypes? a) DATE, TIMESTAMP WITH LOCAL TIME ZONE, BLOB b) DATE, BLOB, LOB, VARCHAR2 c) SYSDATE, TIMESTAMP, DATE, LOCAL TIME ZONE d) TIMESTAMP, LOB, VARCHAR2, NUMBERa) DATE, TIMESTAMP WITH LOCAL TIME ZONE, BLOB
  41. 41Your supervisor has asked you to modify the AMOUNT column in the ORDERS table. He wants the column to be configured to accept a default value of 250. The table contains data that you need to keep. Which statement should you issue to accomplish this task? a) ALTER TABLE orders MODIFY (amount DEFAULT 250); b) DELETE TABLE orders; CREATE TABLE orders (orderno varchar2(5) CONSTRAINT pk_orders_01 PRIMARY KEY, customerid varchar2(5) REFERENCES customers (customerid), orderdate date, amount DEFAULT 250) c) ALTER TABLE orders CHANGE DATATYPE amount TO DEFAULT 250; d) DROP TABLE orders; CREATE TABLE orders (orderno varchar2(5) CONSTRAINT pk_orders_01 PRIMARY KEY, customerid varchar2(5) REFERENCES customers (customerid), orderdate date, amount DEFAULT 250);a) ALTER TABLE orders
    MODIFY (amount DEFAULT 250);
  42. 42You can use DROP COLUMN to drop all columns in a table, leaving a table structure with no columns. True or False? a) True b) Falseb) False
  43. 43A column's data type can always be changed from NUMBER to VARCHAR2 but not from VARCHAR2 to NUMBER, provided the table is empty. True or False? a) True b) Falseb) False
  44. 449. Evaluate the structure of the EMPLOYEE table: EMPLOYEE_ID NUMBER(9) LAST_NAME VARCHAR2(25) FIRST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER(9) MANAGER_ID NUMBER(9) SALARY NUMBER(7,2) The EMPLOYEE_ID column currently contains 500 employee identification numbers. Business requirements have changed and you need to allow users to include text characters in the identification values. Which statement should you use to change this column's data type? a) You CANNOT modify the data type of the EMPLOYEE_ID column, as the table is not empty. b) ALTER TABLE employee REPLACE (employee_id VARCHAR2(9)); c) ALTER employee TABLE MODIFY COLUMN (employee_id VARCHAR2(15)); d) ALTER TABLE employee MODIFY (employee_id VARCHAR2(9));a) You CANNOT modify the data type of the EMPLOYEE_ID column, as the table is not empty.
  45. 45Comments on tables and columns can be stored for documentation by: Mark for Review (1) Points a) Using the COMMENT ON TABLE or COMMENT on COLUMN b) Using an UPDATE statement on the USER_COMMENTS table c) Embedding /* comment */ within the definition of the table. d) Using the ALTER TABLE CREATE COMMENT syntaxa) Using the COMMENT ON TABLE or COMMENT on COLUMN
  46. 46DCL, which is the acronym for Data Control Language, allows: a) The ALTER command to be used. b) The CONTROL TRANSACTION statement can be used. c) The TRUNCATE command to be used. d) A Database Administrator the ability to grant privileges to users.d) A Database Administrator the ability to grant privileges to users.
  47. 47Once they are created, external tables are accessed with normal SQL statements. (True or False?) a) True b) Falsea) True
  48. 48You want to create a table named TRAVEL that is a child of the EMPLOYEES table. Which of the following statements should you issue? a) CREATE TABLE travel (destination_id number primary key, departure_date date, return_date date, emp_id number(10) REFERENCES employees (emp_id)); b) CREATE TABLE travel (destination_id number primary key, departure_date date, return_date date, t.emp_id = e.emp_id); c) CREATE TABLE travel (destination_id number primary key, departure_date date, return_date date, JOIN emp_id number(10) ON employees (emp_id)); d) CREATE TABLE travel (destination_id primary key, departure_date date, return_date date, emp_id REFERENCES employees (emp_id));a) CREATE TABLE travel
    (destination_id number primary key, departure_date date, return_date date, emp_id number(10) REFERENCES employees (emp_id));
  49. 49Which statement about table and column names is true? a) If any character other than letters or numbers is used in a table or column name, the name must be enclosed in double quotation marks. b) Table and column names cannot include special characters. c) Table and column names can begin with a letter or a number. d) Table and column names must begin with a letter.d) Table and column names must begin with a letter.
  50. 50Evaluate this CREATE TABLE statement: 1. CREATE TABLE customer#1 ( 2. cust_1 NUMBER(9), 3. sales$ NUMBER(9), 4. 2date DATE DEFAULT SYSDATE); Which line of this statement will cause an error? a) 1 b) 4 c) 3 d) 2b) 4
  51. 51Which statement about a column is NOT true? a) You can modify the data type of a column if the column contains non-null data. b) You can increase the width of a CHAR column. c) You can convert a DATE data type column to a VARCHAR2 column. d) You can convert a CHAR data type column to the VARCHAR2 data type.a) You can modify the data type of a column if the column contains non-null data.
  52. 52The TEAMS table contains these columns: TEAM_ID NUMBER(4) Primary Key TEAM_NAME VARCHAR2(20) MGR_ID NUMBER(9) The TEAMS table is currently empty. You need to allow users to include text characters in the manager identification values. Which statement should you use to implement this? a) ALTER teams MODIFY (mgr_id VARCHAR2(15)); b) ALTER TABLE teams REPLACE (mgr_id VARCHAR2(15)); c) ALTER TABLE teams MODIFY (mgr_id VARCHAR2(15)); d) ALTER teams TABLE MODIFY COLUMN (mgr_id VARCHAR2(15)); e) You CANNOT modify the data type of the MGR_ID column.c) ALTER TABLE teams
    MODIFY (mgr_id VARCHAR2(15));
  53. 53Evaluate the structure of the EMPLOYEE table: EMPLOYEE_ID NUMBER(9) LAST_NAME VARCHAR2(25) FIRST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER(9) MANAGER_ID NUMBER(9) SALARY NUMBER(7,2) Which statement should you use to increase the LAST_NAME column length to 35 if the column currently contains 200 records? a) You CANNOT increase the width of the LAST_NAME column. b) ALTER TABLE employee RENAME last_name VARCHAR2(35); c) ALTER employee TABLE ALTER COLUMN (last_name VARCHAR2(35)); d) ALTER TABLE employee MODIFY (last_name VARCHAR2(35));d) ALTER TABLE employee
    MODIFY (last_name VARCHAR2(35));
  54. 54Which statement about table and column names is true? a) Table and column names cannot include special characters. b) Table and column names must begin with a letter. c) Table and column names can begin with a letter or a number. D) If any character other than letters or numbers is used in a table or column name, the name must be enclosed in double quotation marks.b) Table and column names must begin with a letter.
  55. 55Given this employee table: (employee_id NUMBER(10) NOT NULL, first_name VARCHAR2(25) NOT NULL, last_name VARCHAR2(30) NOT NULL, hire_date DATE DEFAULT sysdate) What will be the result in the hire_date column following this insert statement: INSERT INTO employees VALUES (10, 'Natacha', 'Hansen', DEFAULT); a) The character string SYSDATE. b) Statement will work and the hire_date column will have the value of the date when the statement was run. c) The column for hire_date will be null. d) Statement will fail, as you must list the columns into which you are inserting.b) Statement will work and the hire_date column will have the value of the date when the statement was run.
  56. 56You want to create a database table that will contain information regarding products that your company released during 2001. Which name can you assign to the table that you create? a) PRODUCTS--2001 b) PRODUCTS_2001 c) 2001_PRODUCTS d) PRODUCTS_(2001)b) PRODUCTS_2001
  57. 57Which of the following SQL statements will create a table called Birthdays with three columns for storing employee number, name and date of birth? a) CREATE table BIRTHDAYS (EMPNO, EMPNAME, BIRTHDATE); b) CREATE TABLE Birthdays (Empno NUMBER, Empname CHAR(20), Birthdate DATE); c) CREATE table BIRTHDAYS (employee number, name, date of birth); d) CREATE TABLE Birthdays (Empno NUMBER, Empname CHAR(20), Date of Birth DATE);b) CREATE TABLE Birthdays (Empno NUMBER, Empname CHAR(20), Birthdate DATE);
  58. 58Which statement about creating a table is true? a) With a CREATE TABLE statement, a table will always be created in the current user's schema. b) If no schema is explicitly included in a CREATE TABLE statement, the CREATE TABLE statement will fail. c) If a schema is explicitly included in a CREATE TABLE statement and the schema does not exist, it will be created. d) If no schema is explicitly included in a CREATE TABLE statement, the table is created in the current user's schema.d) If no schema is explicitly included in a CREATE TABLE statement, the table is created in the current user's schema.
  59. 59The BLOB datatype can max hold 128 Terabytes of data. True or False? a) True b) Falsea) True
  60. 60The SPEED_TIME column should store a fractional second value. Which data type should you use? a) DATETIME b) TIMESTAMP c) DATE d) INTERVAL DAY TO SECONDb) TIMESTAMP
  61. 61To store large amounts of text you should simply create a series of VARCHAR2 columns in a table. True or False? a) True b) Falseb) False
  62. 62Evaluate this statement: ALTER TABLE inventory MODIFY backorder_amount NUMBER(8,2); Which task will this statement accomplish? e) Alters the definition of the BACKORDER_AMOUNT column to NUMBER(8 2) a) Alters the definition of the BACKORDER_AMOUNT column to NUMBER(2,8) b) Alters the definition of the BACKORDER_AMOUNT column to NUMBER c) Changes the definition of the BACKORDER_AMOUNT column to NUMBER(8,2) d) Alters the definition of the BACKORDER_AMOUNT column to NUMBER(8.2)c) Changes the definition of the BACKORDER_AMOUNT column to NUMBER(8,2)
  63. 63RENAME old_name to new_name can be used to: a) Rename a row. b) Rename a column. c) Rename a table. d) All of the above.c) Rename a table.
  64. 64You need to change the name of the EMPLOYEES table to the EMP table. Which statement should you use? a) RENAME employees emp; b) ALTER TABLE employees TO emp; c) ALTER TABLE employees RENAME TO emp; d) RENAME employees TO emp;d) RENAME employees TO emp;
  65. 65You are designing a table for the Human Resources department. This table must include a column that contains each employee's hire date. Which data type should you specify for this column? a) INTERVAL YEAR TO MONTH b) CHAR c) DATE d) TIMESTAMPc) DATE
  66. 66The TIMESTAMP data type allows what? a) Time to be stored as an interval of years and months. b) Time to be stored as a date with fractional seconds. c) Time to be stored as an interval of days to hours, minutes and seconds. d) None of the above.b) Time to be stored as a date with fractional seconds.
  67. 67Once they are created, external tables are accessed with normal SQL statements. (True or False?) a) True d) Falsea) True
  68. 68Which column name is valid? a) NUMBER b) 1_NUMBER# c) NUMBER_1$ d) 1NUMBERc) NUMBER_1$
  69. 69It is possible to create a table by using the CREATE TABLE command in conjunction with a subquery. True or False? a) True b) Falsea) True
  70. 70I have a table named School_Friends in my schema. You want to build a table in your schema named School_Friends. This is ______________, because ____________________________________. a) impossible; no matter what, there can never be two tables with the same name, even if they are in separate schemas. b) possible; my schema is separate from yours, and it is okay for us to have like-named tables in our separate schemas. c) impossible; School_Friends is a reserved term in SQL. d) possible; our data will merge into one table, and we can more easily access our mutual friends information.b) possible; my schema is separate from yours, and it is okay for us to have like-named tables in our separate schemas.
  71. 71CREATE TABLE bioclass (hire_date DATE DEFAULT SYSDATE, first_name varchar2(15), last_name varchar2(15)); The above CREATE TABLE statement is acceptable, and will create a Table named bioclass that contains a hire_date, first_name, and last_name column. True or False? a) True b) Falsea) True
  72. 72You want to create a table named TRAVEL that is a child of the EMPLOYEES table. Which of the following statements should you issue? a) CREATE TABLE travel (destination_id number primary key, departure_date date, return_date date, JOIN emp_id number(10) ON employees (emp_id)); b) CREATE TABLE travel (destination_id number primary key, departure_date date, return_date date, t.emp_id = e.emp_id); c) CREATE TABLE travel (destination_id primary key, departure_date date, return_date date, emp_id REFERENCES employees (emp_id)); d) CREATE TABLE travel (destination_id number primary key, departure_date date, return_date date, emp_id number(10) REFERENCES employees (emp_id));CREATE TABLE travel
    (destination_id number primary key, departure_date date, return_date date, emp_id number(10) REFERENCES employees (emp_id));
  73. 73You are creating the EMPLOYEES table. This table should contain the COMMISSION_PCT column and use a value of 10 percent if no commission value is provided when a record is inserted. Which line should you include in the CREATE TABLE statement to accomplish this task? a) commission_pct NUMBER(4,2) (DEFAULT, 0.10) b) commission_pct NUMBER(4,2) DEFAULT = 0.10 c) commission_pct NUMBER(4,2) DEFAULT 0.10 d) commission_pct NUMBER(4,2) IS DEFAULT 0.10c) commission_pct NUMBER(4,2) DEFAULT 0.10
  74. 74I have a table named School_Friends in my schema. You want to build a table in your schema named School_Friends. This is ______________, because ____________________________________. a) impossible; no matter what, there can never be two tables with the same name, even if they are in separate schemas. b) impossible; School_Friends is a reserved term in SQL. c) possible; my schema is separate from yours, and it is okay for us to have like-named tables in our separate schemas. d) possible; our data will merge into one table, and we can more easily access our mutual friends information.c) possible; my schema is separate from yours, and it is okay for us to have like-named tables in our separate schemas.
  75. 75Which SQL statement below will correctly create the EMP table based on the structure of the EMPLOYEES table? Include only the EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY, and DEPARTMENT_ID columns. Mark for Review (1) Points a) CREATE TABLE emp AS SELECT employee_id, first_name, last_name, salary, department_id FROM employees; b) CREATE TABLE employee AS SELECT employee_id, first_name, last_name, salary, department_id FROM employees; c) CREATE TABLE emp (employee_id, first_name, last_name, salary, department_id); d) CREATE TABLE emp SELECT (employee_id, first_name, last_name, salary, department_id FROM employees);a) CREATE TABLE emp
    AS SELECT employee_id, first_name, last_name, salary, department_id
    FROM employees;
  76. 76When should you use the SET UNUSED command? a) You should only use this command if you want the column to still be visible when you DESCRIBE the table. b) You should use it when you need a quick way of dropping a column. c) Never, there is no SET UNUSED command. d) You should use it if you think the column may be needed again later.b) You should use it when you need a quick way of dropping a column.
  77. 77The FLASHBACK QUERY statement can restore data back to a point in time before the last COMMIT. True or False? a) True b) Falseb) False
  78. 78You need to remove all the rows from the SALES_HIST table. You want to release the storage space, but do not want to remove the table structure. Which statement should you use? a) The DELETE statement b) The DROP TABLE statement c) The TRUNCATE TABLE statement d) The ALTER TABLE statementc) The TRUNCATE TABLE statement
  79. 79The TEAMS table contains these columns: TEAM_ID NUMBER(4) Primary Key TEAM_NAME VARCHAR2(20) MGR_ID NUMBER(9) The TEAMS table is currently empty. You need to allow users to include text characters in the manager identification values. Which statement should you use to implement this? Mark for Review (1) Points e) ALTER TABLE teams MODIFY (mgr_id VARCHAR2(15)); a) ALTER TABLE teams REPLACE (mgr_id VARCHAR2(15)); b) ALTER teams TABLE MODIFY COLUMN (mgr_id VARCHAR2(15)); c) You CANNOT modify the data type of the MGR_ID column. d) ALTER teams MODIFY (mgr_id VARCHAR2(15));e) ALTER TABLE teams
    MODIFY (mgr_id VARCHAR2(15));
  80. 80You want to issue the following command on a database that includes your company's inventory information: ALTER TABLE products SET UNUSED COLUMN color; What will be the result of issuing this command? a) The column named COLOR in the table named PRODUCTS will not be returned in subsequent reads of the table by Oracle, as it has been deleted logically. b) The column named COLOR in the table named PRODUCTS will be assigned default values. c) The column named COLOR in the table named PRODUCTS will be created. d) The column named COLOR in the table named PRODUCTS will be deleted.a) The column named COLOR in the table named PRODUCTS will not be returned in subsequent reads of the table by Oracle, as it has been deleted logically.
  81. 81You are designing a table for the Human Resources department. This table must include a column that contains each employee's hire date. Which data type should you specify for this column? a) INTERVAL YEAR TO MONTH b) TIMESTAMP c) CHAR d) DATEd) DATE
  82. 82The BLOB datatype can max hold 128 Terabytes of data. True or False? a) True b) Falsea) True
  83. 83Which statement about data types is true? a) The CHAR data type should be defined with a size that is not too large for the data it contains (or could contain) to save space in the database. b) The BFILE data type stores character data up to four gigabytes in the database. c) The VARCHAR2 data type should be used for fixed-length character data. d) The TIMESTAMP data type is a character data type.a) The CHAR data type should be defined with a size that is not too large for the data it contains (or could contain) to save space in the database.
  84. 84You need to store the SEASONAL data in months and years. Which data type should you use? a) INTERVAL YEAR TO MONTH b) DATE c) TIMESTAMP d) INTERVAL DAY TO SECONDa) INTERVAL YEAR TO MONTH
  85. 85To store large amounts of text you should simply create a series of VARCHAR2 columns in a table. True or False? a) True b) Falseb) False
  86. 86Which statement about data types is true? a) The VARCHAR2 data type should be used for fixed-length character data. b) The CHAR data type should be defined with a size that is not too large for the data it contains (or could contain) to save space in the database. c) The BFILE data type stores character data up to four gigabytes in the database. d) The TIMESTAMP data type is a character data type.b) The CHAR data type should be defined with a size that is not too large for the data it contains (or could contain) to save space in the database.
  87. 87A table has a column: RESPONSE_TIME. This is used to store the difference between the time the problem was reported and the time the problem was resolved. Data in the RESPONSE_TIME column needs to be stored in days, hours, minutes and seconds. Which data type should you use? a) INTERVAL DAY TO SECOND b) TIMESTAMP c) INTERVAL YEAR TO MONTH d) DATETIMEa) INTERVAL DAY TO SECOND
  88. 88Which statement about creating a table is true? a) If no schema is explicitly included in a CREATE TABLE statement, the CREATE TABLE statement will fail. b) If no schema is explicitly included in a CREATE TABLE statement, the table is created in the current user's schema. c) With a CREATE TABLE statement, a table will always be created in the current user's schema. d) If a schema is explicitly included in a CREATE TABLE statement and the schema does not exist, it will be created.b) If no schema is explicitly included in a CREATE TABLE statement, the table is created in the current user's schema.
  89. 89You are creating the EMPLOYEES table. This table should contain the COMMISSION_PCT column and use a value of 10 percent if no commission value is provided when a record is inserted. Which line should you include in the CREATE TABLE statement to accomplish this task? a) commission_pct NUMBER(4,2) DEFAULT 0.10 b) commission_pct NUMBER(4,2) DEFAULT = 0.10 c) commission_pct NUMBER(4,2) IS DEFAULT 0.10 d) commission_pct NUMBER(4,2) (DEFAULT, 0.10)a) commission_pct NUMBER(4,2) DEFAULT 0.10
  90. 90CREATE TABLE student_table (id NUMBER(6), lname VARCHAR(20), fname VARCHAR(20), lunch_num NUMBER(4)); Which of the following statements best describes the above SQL statement: a) Creates a table named student_table with four columns: lname, fname, lunch, num b) Creates a table named student with four columns: id, lname, fname, lunch_num c) Creates a table named student_table with four columns: id, lname, fname, lunch_num d) Creates a table named student_table with four columns: lname, fname, lunch, numc) Creates a table named student_table with four columns: id, lname, fname, lunch_num
  91. 91Evaluate the structure of the EMPLOYEE table: EMPLOYEE_ID NUMBER(9) LAST_NAME VARCHAR2(25) FIRST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER(9) MANAGER_ID NUMBER(9) SALARY NUMBER(7,2) The EMPLOYEE_ID column currently contains 500 employee identification numbers. Business requirements have changed and you need to allow users to include text characters in the identification values. Which statement should you use to change this column's data type? a) You CANNOT modify the data type of the EMPLOYEE_ID column, as the table is not empty. b) ALTER TABLE employee REPLACE (employee_id VARCHAR2(9)); c) ALTER employee TABLE MODIFY COLUMN (employee_id VARCHAR2(15)); d) ALTER TABLE employee MODIFY (employee_id VARCHAR2(9));a) You CANNOT modify the data type of the EMPLOYEE_ID column, as the table is not empty.
  92. 92Examine the structure of the DONATIONS table. DONATIONS: PLEDGE_ID NUMBER DONOR_ID NUMBER PLEDGE_DT DATE AMOUNT_PLEDGED NUMBER (7,2) AMOUNT_PAID NUMBER (7,2) PAYMENT_DT DATE You need to reduce the precision of the AMOUNT_PLEDGED column to 5 with a scale of 2 and ensure that when inserting a row into the DONATIONS table without a value for the AMOUNT_PLEDGED column, a price of $10.00 will automatically be inserted. The DONATIONS table currently contains NO records. Which statement is true? a) Both changes can be accomplished with one ALTER TABLE statement. b) You must use the ADD OR REPLACE option to achieve these results. c) You CANNOT decrease the width of the AMOUNT_PLEDGED column. d) You must drop and recreate the DONATIONS table to achieve these results.a) Both changes can be accomplished with one ALTER TABLE statement.
  93. 93Evaluate this statement: ALTER TABLE employees SET UNUSED (fax); Which task will this statement accomplish? a) Deletes the FAX column b) Frees the disk space used by the data in the FAX column c) Prevents data in the FAX column from being displayed, by performing a logical drop of the column d) Prevents a new FAX column from being added to the EMPLOYEES tablec) Prevents data in the FAX column from being displayed, by performing a logical drop of the column
  94. 94Which statement about decreasing the width of a column is true? a) You cannot decrease the width of a character column unless the table in which the column resides is empty. b) When a character column contains data, you cannot decrease the width of the column. c) When a character column contains data, you can decrease the width of the column without any restrictions. d) When a character column contains data, you can decrease the width of the column if the existing data does not violate the new size.d) When a character column contains data, you can decrease the width of the column if the existing data does not violate the new size.
  95. 95To do a logical delete of a column without the performance penalty of rewriting all the table datablocks, you can issue the following command: a) Alter table modify column b) Alter table drop column c) Alter table set unused d) Drop column "columname"c) Alter table set unused
  96. 96Evaluate this CREATE TABLE statement: CREATE TABLE sales ( sales_id NUMBER(9), customer_id NUMBER(9), employee_id NUMBER(9), description VARCHAR2(30), sale_date TIMESTAMP WITH LOCAL TIME ZONE DEFAULT SYSDATE, sale_amount NUMBER(7,2)); Which business requirement will this statement accomplish? a) All employee identification values are only 6 digits so the column should be variable in length. b) Today's date should be used if no value is provided for the sale date. c) Sales identification values could be either numbers or characters, or a combination of both. d) Description values can range from 0 to 30 characters so the column should be fixed in length.b) Today's date should be used if no value is provided for the sale date.
  97. 97our supervisor has asked you to modify the AMOUNT column in the ORDERS table. He wants the column to be configured to accept a default value of 250. The table contains data that you need to keep. Which statement should you issue to accomplish this task? a) ALTER TABLE orders MODIFY (amount DEFAULT 250); b) DELETE TABLE orders; CREATE TABLE orders (orderno varchar2(5) CONSTRAINT pk_orders_01 PRIMARY KEY, customerid varchar2(5) REFERENCES customers (customerid), orderdate date, amount DEFAULT 250) c) ALTER TABLE orders CHANGE DATATYPE amount TO DEFAULT 250; d) DROP TABLE orders; CREATE TABLE orders (orderno varchar2(5) CONSTRAINT pk_orders_01 PRIMARY KEY, customerid varchar2(5) REFERENCES customers (customerid), orderdate date, amount DEFAULT 250);a) ALTER TABLE orders
    MODIFY (amount DEFAULT 250);
  98. 98You can use DROP COLUMN to drop all columns in a table, leaving a table structure with no columns. True or False? a) True b) Falseb) False
  99. 99You want to create a table named TRAVEL that is a child of the EMPLOYEES table. Which of the following statements should you issue? a) CREATE TABLE travel (destination_id number primary key, departure_date date, return_date date, emp_id number(10) REFERENCES employees (emp_id)); b) CREATE TABLE travel (destination_id number primary key, departure_date date, return_date date, t.emp_id = e.emp_id); c) CREATE TABLE travel (destination_id number primary key, departure_date date, return_date date, JOIN emp_id number(10) ON employees (emp_id)); d) CREATE TABLE travel (destination_id primary key, departure_date date, return_date date, emp_id REFERENCES employees (emp_id));a) CREATE TABLE travel
    (destination_id number primary key, departure_date date, return_date date, emp_id number(10) REFERENCES employees (emp_id));
  100. 100Which statement about table and column names is true? a) If any character other than letters or numbers is used in a table or column name, the name must be enclosed in double quotation marks. b) Table and column names cannot include special characters. c) Table and column names can begin with a letter or a number. d) Table and column names must begin with a letter.d) Table and column names must begin with a letter.
  101. 101Which statement about a column is NOT true? a) You can modify the data type of a column if the column contains non-null data. b) You can increase the width of a CHAR column. c) You can convert a DATE data type column to a VARCHAR2 column. d) You can convert a CHAR data type column to the VARCHAR2 data type.a) You can modify the data type of a column if the column contains non-null data.
  102. 102The TEAMS table contains these columns: TEAM_ID NUMBER(4) Primary Key TEAM_NAME VARCHAR2(20) MGR_ID NUMBER(9) The TEAMS table is currently empty. You need to allow users to include text characters in the manager identification values. Which statement should you use to implement this? a) ALTER teams MODIFY (mgr_id VARCHAR2(15)); b) ALTER TABLE teams REPLACE (mgr_id VARCHAR2(15)); c) ALTER TABLE teams MODIFY (mgr_id VARCHAR2(15)); d) ALTER teams TABLE MODIFY COLUMN (mgr_id VARCHAR2(15));c) ALTER TABLE teams
    MODIFY (mgr_id VARCHAR2(15));
  103. 103Evaluate the structure of the EMPLOYEE table: EMPLOYEE_ID NUMBER(9) LAST_NAME VARCHAR2(25) FIRST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER(9) MANAGER_ID NUMBER(9) SALARY NUMBER(7,2) Which statement should you use to increase the LAST_NAME column length to 35 if the column currently contains 200 records? a) You CANNOT increase the width of the LAST_NAME column. b) ALTER TABLE employee RENAME last_name VARCHAR2(35); c) ALTER employee TABLE ALTER COLUMN (last_name VARCHAR2(35)); d) ALTER TABLE employee MODIFY (last_name VARCHAR2(35));d) ALTER TABLE employee
    MODIFY (last_name VARCHAR2(35));
  104. 104ALTER TABLE inventory MODIFY backorder_amount NUMBER(8,2); Which task will this statement accomplish? e) Alters the definition of the BACKORDER_AMOUNT column to NUMBER(8 2) a) Alters the definition of the BACKORDER_AMOUNT column to NUMBER(2,8) b) Alters the definition of the BACKORDER_AMOUNT column to NUMBER c) Changes the definition of the BACKORDER_AMOUNT column to NUMBER(8,2) d) Alters the definition of the BACKORDER_AMOUNT column to NUMBER(8.2)c) Changes the definition of the BACKORDER_AMOUNT column to NUMBER(8,2)
  105. 105ou need to change the name of the EMPLOYEES table to the EMP table. Which statement should you use? a) RENAME employees emp; b) ALTER TABLE employees TO emp; c) ALTER TABLE employees RENAME TO emp; d) RENAME employees TO emp;d) RENAME employees TO emp;
  106. 106The TIMESTAMP data type allows what? a) Time to be stored as an interval of years and months. b) Time to be stored as a date with fractional seconds. c) Time to be stored as an interval of days to hours, minutes and seconds. d) None of the above.b) Time to be stored as a date with fractional seconds.
  107. 107CREATE TABLE bioclass (hire_date DATE DEFAULT SYSDATE, first_name varchar2(15), last_name varchar2(15)); The above CREATE TABLE statement is acceptable, and will create a Table named bioclass that contains a hire_date, first_name, and last_name column. True or False? a) True b) Falsea) True
  108. 108You are creating the EMPLOYEES table. This table should contain the COMMISSION_PCT column and use a value of 10 percent if no commission value is provided when a record is inserted. Which line should you include in the CREATE TABLE statement to accomplish this task? a) commission_pct NUMBER(4,2) (DEFAULT, 0.10) b) commission_pct NUMBER(4,2) DEFAULT = 0.10 c) commission_pct NUMBER(4,2) DEFAULT 0.10 d) commission_pct NUMBER(4,2) IS DEFAULT 0.10c) commission_pct NUMBER(4,2) DEFAULT 0.10
  109. 109Which SQL statement below will correctly create the EMP table based on the structure of the EMPLOYEES table? Include only the EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY, and DEPARTMENT_ID columns. a) CREATE TABLE emp AS SELECT employee_id, first_name, last_name, salary, department_id FROM employees; b) CREATE TABLE employee AS SELECT employee_id, first_name, last_name, salary, department_id FROM employees; c) CREATE TABLE emp (employee_id, first_name, last_name, salary, department_id); d) CREATE TABLE emp SELECT (employee_id, first_name, last_name, salary, department_id FROM employees);a) CREATE TABLE emp
    AS SELECT employee_id, first_name, last_name, salary, department_id
    FROM employees;
  110. 110When should you use the SET UNUSED command? a) You should only use this command if you want the column to still be visible when you DESCRIBE the table. b) You should use it when you need a quick way of dropping a column. c) Never, there is no SET UNUSED command. d) You should use it if you think the column may be needed again later.b) You should use it when you need a quick way of dropping a column.
  111. 111You need to remove all the rows from the SALES_HIST table. You want to release the storage space, but do not want to remove the table structure. Which statement should you use? a) The DELETE statement b) The DROP TABLE statement c) The TRUNCATE TABLE statement d) The ALTER TABLE statementc) The TRUNCATE TABLE statement
  112. 112The TEAMS table contains these columns: TEAM_ID NUMBER(4) Primary Key TEAM_NAME VARCHAR2(20) MGR_ID NUMBER(9) The TEAMS table is currently empty. You need to allow users to include text characters in the manager identification values. Which statement should you use to implement this? e) ALTER TABLE teams MODIFY (mgr_id VARCHAR2(15)); a) ALTER TABLE teams REPLACE (mgr_id VARCHAR2(15)); b) ALTER teams TABLE MODIFY COLUMN (mgr_id VARCHAR2(15)); c) You CANNOT modify the data type of the MGR_ID column. d) ALTER teams MODIFY (mgr_id VARCHAR2(15));e) ALTER TABLE teams
    MODIFY (mgr_id VARCHAR2(15));
  113. 113You want to issue the following command on a database that includes your company's inventory information: ALTER TABLE products SET UNUSED COLUMN color; What will be the result of issuing this command? a) The column named COLOR in the table named PRODUCTS will not be returned in subsequent reads of the table by Oracle, as it has been deleted logically. b) The column named COLOR in the table named PRODUCTS will be assigned default values. c) The column named COLOR in the table named PRODUCTS will be created. d) The column named COLOR in the table named PRODUCTS will be deleted.a) The column named COLOR in the table named PRODUCTS will not be returned in subsequent reads of the table by Oracle, as it has been deleted logically.
  114. 114You need to store the SEASONAL data in months and years. Which data type should you use? a) INTERVAL YEAR TO MONTH b) DATE c) TIMESTAMP d) INTERVAL DAY TO SECONDa) INTERVAL YEAR TO MONTH
  115. 115Which statement about data types is true? a) The VARCHAR2 data type should be used for fixed-length character data. b) The CHAR data type should be defined with a size that is not too large for the data it contains (or could contain) to save space in the database. c) The BFILE data type stores character data up to four gigabytes in the database. d) The TIMESTAMP data type is a character data type.b) The CHAR data type should be defined with a size that is not too large for the data it contains (or could contain) to save space in the database.
  116. 116A table has a column: RESPONSE_TIME. This is used to store the difference between the time the problem was reported and the time the problem was resolved. Data in the RESPONSE_TIME column needs to be stored in days, hours, minutes and seconds. Which data type should you use? a) INTERVAL DAY TO SECOND b) TIMESTAMP c) INTERVAL YEAR TO MONTH d) DATETIMEa) INTERVAL DAY TO SECOND
  117. 117Examine the structure of the DONATIONS table. DONATIONS: PLEDGE_ID NUMBER DONOR_ID NUMBER PLEDGE_DT DATE AMOUNT_PLEDGED NUMBER (7,2) AMOUNT_PAID NUMBER (7,2) PAYMENT_DT DATE You need to reduce the precision of the AMOUNT_PLEDGED column to 5 with a scale of 2 and ensure that when inserting a row into the DONATIONS table without a value for the AMOUNT_PLEDGED column, a price of $10.00 will automatically be inserted. The DONATIONS table currently contains NO records. Which statement is true? a) Both changes can be accomplished with one ALTER TABLE statement. b) You must use the ADD OR REPLACE option to achieve these results. c) You CANNOT decrease the width of the AMOUNT_PLEDGED column. d) You must drop and recreate the DONATIONS table to achieve these results.a) Both changes can be accomplished with one ALTER TABLE statement.
  118. 118Evaluate this statement: ALTER TABLE employees SET UNUSED (fax); Which task will this statement accomplish? a) Deletes the FAX column b) Frees the disk space used by the data in the FAX column c) Prevents data in the FAX column from being displayed, by performing a logical drop of the column d) Prevents a new FAX column from being added to the EMPLOYEES tablec) Prevents data in the FAX column from being displayed, by performing a logical drop of the column
  119. 119Which statement about decreasing the width of a column is true? a) You cannot decrease the width of a character column unless the table in which the column resides is empty. b) When a character column contains data, you cannot decrease the width of the column. c) When a character column contains data, you can decrease the width of the column without any restrictions. d) When a character column contains data, you can decrease the width of the column if the existing data does not violate the new size.d) When a character column contains data, you can decrease the width of the column if the existing data does not violate the new size.
  120. 120To do a logical delete of a column without the performance penalty of rewriting all the table datablocks, you can issue the following command: a) Alter table modify column b) Alter table drop column c) Alter table set unused d) Drop column "columname"c) Alter table set unused

Information

Description
Oracle SQL Flashcards on Oracle Practice Exam 3, created by Amber Saxon on 22/02/2020.
Created by
Amber Saxon · Feb 2020
Updated
Feb 26, 2020
Views
4
Rating

Feedback

What is it about?

What do you think of the new look?

How do you like it?