MURDOCH UNIVERSITY QUIZ 7 ICT 285 2026-2027 (4pages)

Quiz 7 Which SQL keyword is used to name a new table and describe the table's columns? Select one: a. SET TABLE b. CREATE TABLE c. SELECT TABLE d. ALTER TABLE e. CONSTRAIN TABLE Which SQL keyword is used to impose restrictions on a table, data or relationship? Select one: a. SET b. CREATE c. SELECT d. ALTER e. CONSTRAINT One advantage of using the CONSTRAINT phrase to define a primary key is that the database designer controls the ________. Select one: a. name of the primary key b. name of the foreign key c. name of the constraint d. A and B e. A, B and C When creating tables, Oracle Database automatically converts the SQL standard data type "int" into: Select one: a. number (38,0). b. integer (32). c. number (5,0). d. integer (16). e. number (64,0). Which of the following activities is NOT part of physical database design? Select one: a. Translate logical design to target DBMS b. Design file organisations and indexes c. Design security mechanisms d. Convert all tables to Third Normal Form e. Monitor and tune the operational system Given the SQL statement CREATE TABLE SALESREP ( SalesRepNo int NOT NULL, RepName char(35) NOT NULL, HireDate date NOT NULL, CONSTRAINT SalesRepPK PRIMARY KEY (SalesRepNo), CONSTRAINT SalesRepAK1 UNIQUE (RepName)