IT-6202 - Database Management System 1 (Oracle) oed answer key

Showing 61 to 80 of 144 total answers.

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

This is used to brings together data that is stored in different tables by specifying the link between them.

Answer

Joins

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

Which of the following is the correct example of modifying the column JOB_ID? Change the datatype size to 10.

Answer

ALTER TABLE EMPLOYEESMODIFY JOB_ID CHAR(10);

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

Which of the following is the correct example of modifying the column lastname? Change the datatype size to 20.

Answer

ALTER TABLE EMPLOYEESMODIFY LASTNAME VARCHAR(20);

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

Which of the following is the correct example updating all student COURSE to =E2=80=98BSIT' from STUDENTS table?

Answer

UPDATE STUDENTSSET COURSE = =E2=80=98BSIT=E2=80=99;

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

Which of the following is the correct example updating all student COURSE to =E2=80=98BSIT' from STUDENTS table?

Answer

UPDATE STUDENTSSET COURSE = =E2=80=98BSIT';

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

Suppose that a user uses the DELETE statement as shown below: what is/are the possible output. DELETE from STUDENT;

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

Which of the following is the correct example of adding a new column ADDRESS datatypevarchar size 20 to EMPLOYEES table?

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

Which of the following is the correct example of inserting new values to STUDENTS table where the course is set to NULL;

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

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

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

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

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

Which of the following is the correct example of adding a new column CONTACT_NOdatatypeNUMBER size 11 to EMPLOYEES table?

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

Which of the following is the correct example of creating a new table STUDENTS? The column STUD_ID is set to primary key.

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

Which of the following is the correct example of deleting a student record from STUDENTS table whose COURSE is equal to NULL;

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

This is use to Selects the columns in a table that are returned by a query. Selects a few or as many of the columns as required.

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

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?

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

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

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

Suppose that a user wanted to change the datatype of column ADDRESS from Varchar to Char which of the following is the correct example.

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

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

#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

Suppose that a user wanted to add a new column name as CITY datatype set to char size 10. Which of the following is the correct sql statement?

Page 4 of 8