Question :
52) Which SQL keyword used to name a new table : 1526319
52) Which SQL keyword is used to name a new table and describe the table's columns?
A) SET
B) CREATE
C) SELECT
D) ALTER
53) If the table PRODUCT has a column PRICE that has the data type Numeric (8,2), the value 12345 will be displayed by the DBMS as ________.
A) 123.45
B) 12345
C) 12345.00
D) 123450.00
54) Which SQL keyword is used to impose restrictions on a table, data or relationship?
A) SET
B) CREATE
C) SELECT
D) CONSTRAINT
55) One advantage of using the CONSTRAINT phrase to define a primary key is that the database designer controls the ________.
A) name of the table
B) name of the foreign key field
C) name of the constraint
D) name of the primary key field
56) Which of the following illustrates the authors' preferred style of defining a primary key?
A) CREATE TABLE CUSTOMER (
CustomerIDIntegerPrimary Key
LastNameChar(35)Not Null
First NameChar(25)Null
);
B) CREATE TABLE CUSTOMER (
CustomerIDIntegerNot Null
LastNameChar(35)Not Null
First NameChar(25)Null
CONSTRAINT CustomerPK PRIMARY KEY (CustomerID)
);
C) CREATE TABLE CUSTOMER (
CustomerIDIntegerNot Null
LastNameChar(35)Not Null
First NameChar(25)Null
);
ALTER TABLE CUSTOMER
ADD CONSTRAINT CustomerPK PRIMARY KEY (CustomerID);
D) Both B and C are correct
57) Given the SQL statement
CREATE TABLE SALESREP (
SalesRepNointNOT NULL,
RepNamechar(35)NOT NULL,
HireDatedateNOT NULL,
CONSTRAINTSalesRepPKPRIMARY KEY (SalesRepNo),
CONSTRAINTSalesRepAK1UNIQUE (RepName)
);
we know that ________.
A) RepName is the primary key
B) RepName is a foreign key
C) RepName is a candidate key
D) RepName is a surrogate key
58) The SQL keyword used to limit column values to specific values is ________.
A) CONSTRAINT
B) CHECK
C) NOT NULL
D) UNIQUE
59) Which SQL keyword is used to change the structure, properties or constraints of a table?
A) SET
B) CREATE
C) SELECT
D) ALTER
60) Which SQL keyword is used to delete a table's structure?
A) DELETE
B) DROP
C) DISPOSE
D) ALTER
61) When the correct SQL command is used to delete a table's structure, what happens to the data in the table?
A) If the deleted table was a parent table, the data is added to the appropriate rows of the child table.
B) If the deleted table was a child table, the data is added to the appropriate rows of the parent table.
C) The data in the table is also deleted.
D) Nothing because there was no data in the table since only an empty table can be deleted.
