1. Supposed that the user uses the ff SELECT statement: what will be the possibl

Question

1.

Supposed that the user uses the ff SELECT statement: what will be the possible output.
SELECT GRADE AS STUDENT MARK
FROM GRADE_REPORT;

Select one:

a. Error because of missing “” mark.

b. Will display the column GRADE rename as STUDENT MAK

c. Will display all rows and columns.

d. Error because of the keyword AS.

2.

Suppose that the user wanted to add a new column name as CUST_NAME data type char size 6. What is the correct SQL statement to use?

Select one:

a. ALTER PARTS
ADD CUST_NAME CHAR(6);

b. ALTER TABLE PARTS
ADD CUST_NAME CHAR(6);

c. ALTER PARTS
SET CUST_NAME = CHAR(6);

d. ALTER TABLE PARTS
SET CUST_NAME = CHAR(6);

3.

Suppose that a user wanted to insert a new value using the implicit method which of the following is the correct example.

Select one:

a. INSERT INTO STUDENST(USN_ID, FIRSTNAME) VALUES(10,’ELENA’);

b. INSERT INTO STUDENTS VALUES (10,’ELENA’);

c. INSERT INTO STUDENTS VALUES (10, NULL,’ELENA’,NULL);

d. INSERT INTO STUDENTS VALUES (USN_ID, FIRSTNAME) (10,’ELENA’);

Explanation / Answer

1. b

Will display the column GRADE rename as STUDENT MARK

2. b

ALTER TABLE PARTS
ADD CUST_NAME CHAR(6);

3. a

INSERT INTO STUDENST(USN_ID, FIRSTNAME) VALUES(10,’ELENA’);

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.