I\'m in the middle of the finals and I\'m in need of some help. When creating a

Question

I'm in the middle of the finals and I'm in need of some help. When creating a table, which of the following statements is NOT correct? The schema of the table must be explicitly stated. A user can have two tables with the same name, as long as the column names are different. The column list must be enclosed in parentheses ( ). Default values cannot be assigned to all columns in a table. 2. (TCO 4) Which of the following SQL statements would you use to create a table named DEVRY? CREATE Devry ( Student_id NUMBER (12), Student_name VARCHAR2 (15), Student_city VARCHAR2 (12) ); CREATE TABLE Devry ( Student_id NUMBER (12) Student_name VARCHAR2 (15) Student_city VARCHAR2 (12) ); CREATE TABLE Devry ( Student_id NUMBER (12), Student_name VARCHAR2 (15), Student_city VARCHAR2 (12) ); CREATE TABLE Devry Student_id NUMBER (12), Student_name VARCHAR2 (15), Student_city VARCHAR2 (12); 3. (TCO 5) Which command can be used to determine whether or not a column is allowed to contain a NULL value? DISPLAY_CONSTRAINTS DESCRIBE or DESC DEFINED_CONSTRAINTS DISPLAY 4. (TCO 5) Knowing the ______________ number of entity occurrences is very helpful at the application software level. maximum minimum exact maximum and minimum 5. (TCO 6) Which of the following commands will increase the size of the CITY column in the CUSTOMERS table from 12 to 20 and increase size of the LASTNAME column from 10 to 14? ALTER TABLE customers MODIFY (city VARCHAR2(+8), lastname VARCHAR2(+4)); ALTER TABLE customers MODIFY (city VARCHAR2(20), lastname VARCHAR2(14)); ALTER TABLE customers MODIFY (city (+8), lastname (+4)); ALTER TABLE customers MODIFY (city (20), lastname (14)); 6. (TCO 6) When using the ALTER TABLE...DROP COLUMN command, which of the following is not correct? The command's effect on the table is permanent. You cannot delete the last remaining column in a table. The command deletes both the column and its contents. The command can be used to delete multiple columns from a table. 7. (TCO 6) When a column is added to a table, it is the _________ column in the table. (Points : 4) first last second third 8. (TCO 7) Given a table named EMPLOYEE, the SQL command to sort records in a specific order would be: SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE LIST BY EMP_LNAME, EMP_FNAME, EMP_INITIAL; SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL; SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE DISPLAY BY EMP_LNAME, EMP_FNAME, EMP_INITIAL; SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE SEQUENCE BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;

Explanation / Answer

impossible to read :(

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.