Question: Which of the following is a valid SQL command? a. ALTER TABLE books ADD CONSTRAINT UNIQUE (pubid); b. ALTER TABLE books ADD CONSTRAINT PRIMARY KEY

Which of the following is a valid SQL command?
a. ALTER TABLE books ADD CONSTRAINT UNIQUE (pubid);
b. ALTER TABLE books ADD CONSTRAINT PRIMARY KEY (pubid);
c. ALTER TABLE books MODIFY (pubid CONSTRAINT NOT NULL);
d. ALTER TABLE books ADD FOREIGN KEY CONSTRAINT (pubid) REFERENCES publisher (pubid);
e. None of the above commands is valid.

Step by Step Solution

★★★★★

3.49 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

e None ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (2 attachments)

1803_60b8c12122684_716081.pdf

180 KBs PDF File

1803_60b8c12122684_716081.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!

Which of the following is a valid SQL statement? a. ALTER TABLE secustomersspent ADD DATE lastorder; b. ALTER TABLE secustomerorders DROP retail; c. CREATE TABLE newtable AS(SELECT * FROM customers);...

Which of the following is a valid SQL statement? a. CREATE TABLE tablel (col1 NUMBER PRIMARY KEY, col2 VARCHAR2 (20) PRIMARY KEY, col3 DATE DEFAULT SYSDATE, col4 VARCHAR2 (2)); b. CREATE TABLE tablel...

Which of the following is a valid SQL statement? a. SELECT * WHERE amid = J100 FOR UPDATE; b. INSERT INTO homeworkl0 VALUES (SELECT * FROM acctmanager); c. DELETE amid FROM acctmanager; d. rollback;...

CHAPTER 3 1. Which of the following is a correct statement? a. You can restore the data deleted with the DROP COLUMN clause, but not the data deleted with the SET UNUSED clause. b. You cant create...

Which of the following is a correct statement? a. You can restore the data deleted with the DROP COLUMN clause, but not the data deleted with the SET UNUSED clause. b. You cant create empty tablesall...

Which of the following SQL statements is invalid and returns an error message? a. ALTER TABLE books ADD CONSTRAINT books_pubid_uk UNIQUE (pubid); b. ALTER TABLE books ADD CONSTRAINT books_pubid_pk...

CAPTULO 3 1. Cul de las siguientes es una afirmacin correcta? a. Puede restaurar los datos eliminados con la clusula DROP COLUMN, pero no los datos eliminados con la clusula SET UNUSED. b. No se...

Below is my ER model with brief comments: - - Created Database CREATE DATABASE SchoolDB; - - After creation of Database, to use it we will use the following command USE SchoolDB; - - Created COURSE...

Starter Text File: create table Worker ( WID number (9) Constraint pk_Wkr primary key, First_Name varchar2 (30) constraint nn_FN not null, Last_Name varchar2 (30) constraint nn_LN not null, MI...

) Create the SQL statements for displaying the results for each of the following scenarios in the Academic Database. Save these statements in a script called M06_LastNameFirstName_ Queries (where...

Which type of audit is used most often to substantiate the reported items of income or deduction for individuals who have only wages? a. Field b. Office c. Correspondence

In Example 11.4, a 12-hr unit hydrograph (UH12) is computed. Using the UH12, compute a 24-hr unit hydrograph (UH24).

Coronado Inc is involved in a lawsuit at December 3 1 , 2 0 2 5 . ( a ) Prepare the December 3 1 entry assuming it is probable that Coronado will be liable for $ 8 6 3 , 6 0 0 as a result of this...

2. Dccomposition is used ill dcycloping ___ _ a. thc managcmctH plan h. the communications pian c. the earncd value J. the WBt:>

Suppose you have three nonempty stacks R, S, and T. Describe a sequence of operations that results in S storing all elements originally in T below all of Ss original elements, with both sets of those...

Show how to use the transfer method, described in Exercise R-6.4, and two temporary stacks, to replace the contents of a given stack S with those same elements, but in reversed order.

Suppose Alice has picked three distinct integers and placed them into a stack S in random order. Write a short, straightline piece of pseudocode (with no loops or recursion) that uses only one...

A stock has a beta of 1.00 and an expected return of 10 percent. A risk-free asset currently earns 2.2 percent. a. What is the expected return on a portfolio that is equally invested in the two...

Steven Company has fixed costs of 3764,278 . The unit selling price, variable cost per unit, and contritution margin per unit for the comparyys two products are 35 follows: whole number. x units of x...

Note: In addition to your solution to each computational problem, you must show the supporting work leading to your solution to receive credit for your answer.