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

Showing 41 to 60 of 144 total answers.

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

Which of the following is the correct example of dropping the table EMPLOYEES?

Answer

DROP TABLE EMPLOYEES;

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

Given the output below. Which of the following is the correct PL/SQL to be used

Answer

SELECT DISTINCT WAREHOUSE FROM PARTS;

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

Given the output below. Which of the following is the correct PL/SQL to be used?

Answer

SELECT DESCRIPTION, ONHAND,CLASSFROM PARTSWHERE CLASS = =E2=80=98HW=E2=80=99;

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

It is a character, a number, or a date that is included in the SELECT statement.

Answer

Literal

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

Which of the following is the correct example of truncating the table EMPLOYEES?

Answer

TRUNCATE TABLE EMPLOYEES;

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

A statement that is use to rename the table or change the existing name of the table.

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

This character is used to override the default precedence or to clarify the statement.

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

This is use to accept character input and can return both character and number values.

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

An alter statement that is used to update an existing column datatype or datatype size.

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

Which of the following is the correct example of deleting all records in STUDENTS 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?

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

Which of the following is the correct example of renaming the table EMPLOYEES to WORKERS?

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

It is a collection of relations or two-dimensional tables controlled by the Oracle server.

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

Which of the following query is correct which will display the same output as shown below?

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

This is used to in conditions that compare one expression with another value or expression.

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

What is the return value if the user try to do the following:SELECT TRUNC (65.73,-2) FROM DUAL;

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

Which of the following is the correct example of removing a column SALARY from EMPLOYEES table?

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

This is use to find the numeric position of a named character starting at character position n.

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

Which of the following is the correct example of removing a column FIRSTNAME from EMPLOYEES table?

Page 3 of 8

123456...8