x
Info
x
Warning
x
Danger
 / 
 / 
 / 
52) Which SQL keyword used to name a new table

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.

 

Solution
5 (1 Ratings )

Solved
Computer Science 6 Months Ago 97 Views
This Question has Been Answered!
Unlimited Access Free
Explore More than 2 Million+
  • Textbook Solutions
  • Flashcards
  • Homework Answers
  • Documents
Signup for Instant Access!
Ask an Expert
Our Experts can answer your tough homework and study questions
154368 Computer Science Questions Answered!
Post a Question