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)
This study source was downloaded by 100000868537585 from CourseHero.com on 07-16-2023 14:18:06 GMT -05:00
https://www.coursehero.com/file/28205969/Quiz-7docx/
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)
This study source was downloaded by 100000868537585 from CourseHero.com on 07-16-2023 14:18:06 GMT -05:00
https://www.coursehero.com/file/28205969/Quiz-7docx/
