Question: Which of the following SQL statements changes the size of the Title column in the BOOKS table from the current length of 30 characters to

Which of the following SQL statements changes the size of the Title column in the BOOKS table from the current length of 30 characters to the length of 35 characters?
a. ALTER TABLE books CHANGE title VARCHAR(35);
b. ALTER TABLE books MODIFY (title VARCHAR2(35));
c. ALTER TABLE books MODIFY title (VARCHAR2(35));
d. ALTER TABLE books MODIFY (title VARCHAR2(+5));

Step by Step Solution

★★★★★

3.47 Rating (183 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

b ALTER T... 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_60b8c12121cc1_716053.pdf

180 KBs PDF File

1803_60b8c12121cc1_716053.docx

120 KBs Word File

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

Which of the following SQL statements returns all books published after March 20, 2005? a. SELECT * FROM books WHERE pubdate > 03-20-2005; b. SELECT * FROM books WHERE pubdate > '03-20-2005'; c....

Which of the following SQL statements is not valid? a. SELECT b.isbn, p.name FROM books b NATURAL JOIN publisher p; b. SELECT isbn, name FROM books b, publisher p WHERE b.pubid = p.pubid; c. SELECT...

Which of the following SQL statements is not valid? a. SELECT isbn FROM books MINUS SELECT isbn FROM orderitems; b. SELECT isbn, name FROM books, publisher WHERE books.pubid (+) = publisher.pubid(+);...

Run your MySQL Workbench and work in the following questions. You need to upload 3 files: 1 . bookcreate.sql 2 . bookinsert.sql 3 . bookretrieve.sql I. Create a script file called bookcreate.sql ,...

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...

ATTENTION TUTORS PLEASE HELP ME IN ANSWERING THIS ATTACHMENT WORKSHEET I NEED IT FOR CLASS IN ACCOUNTING THANK YOU HAVE THE ANSWERS IN YELLOW PLEASE SEE ATTACHMENT Question 1 of 15 1. A small...

I would like assist for my assessment. The subject is Subsidiary Accounts and Ledgers and Foundation Skills. T-1.8.1 Details of Assessment Term and Year 1, 2017 Time allowed Week 2-7 Assessment No 1...

please help me with number 1,2,3,4,5,6,7,8,9,10,11,12,13,14 You need to create a table for keeping customer's banking details for the JustLee Books database. One of the columns in the table has the...

this is how the screenshoot should look like please my name should be writing in the screen capture here is my name patrick desc vendor; --Amritpreet, 0.1 CREATE TABLE CUST2 (CUST_ID, NAME, ADDRESS,...

Let X1, X2, ... , X8 be a random sample of size n = 8 from a Poisson distribution with mean . Reject the simple null hypothesis H0: = 0.5, and accept H1: > 0.5, if the observed sum 8i=1 xi 8. (a)...

The directors of L Ltd appointed a new sales manager towards the end of 20X2. This manager devised a plan to increase sales and profit by means of a reduction in selling price and extended credit...

What are the main methods banks use to measure their liquidity risk exposure? Compare the liquidity index, peer group ratio comparisons, and net liquidity position.

10. lIIatch the following items to their descriptions; Lessolls learned a. Leal'e a elear :md complete history of a project Project audits b. Rcvicw project progress alld results Project archives c....

Given a database D of n cost-performance pairs (c, p), describe an algorithm for finding the maxima pairs of C in O(nlogn) time.

Suppose we are given two sorted search tables S and T, each with n entries (with S and T being implemented with arrays). Describe an O(log 2 n)-time algorithm for finding the k th smallest key in the...

Although keys in a map are distinct, the binary search algorithm can be applied in a more general setting in which an array stores possibly duplicative elements in nondecreasing order. Consider the...

You have invested only in the BlueChip Fund, a mutual fund that invests mainly in stocks. At the moment, the Blue Chip Fund has an expected return of 34% and a volatility of 15%. Your broker suggests...

My appointed company is Restaurant Brands NZ Examine your firm's dividend policy and identify if there have been any major changes over the past five years. (You may want to look at your company's...

1 - In order to establish a sinking fund of $125,000, how much will have to be invested at the end of each year at the rate of 11.2% compounded annually for 8 years? a) O $10,245.73 b) O $11.435.22 C...