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

Showing 21 to 40 of 144 total answers.

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

A type of DML statement that is use to add new rows in a table.

Answer

INSERT

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

An alter statement that is used to add new column to the table.

Answer

ADD

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

It logically represents subsets of data from one or more table.

Answer

View

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

This is used to restrict the rows that are returned by a query.

Answer

Where

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

Which of the following is not part of disadvantage of database?

Answer

Data integrity

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

Which of the following is not part of other Comparison Operator?

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

Which of the following is not true about writing SQL statements?

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

Which of the following is not part of common Comparison operator?

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

Which of the following is not part of data manipulation language?

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

Which of the following is not part of characteristics of database?

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

A type of insert statement that omit the column from the column list.

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

A type of DML statement that is use to remove existing rows in a table.

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

Trims leading or trailing characters (or both) from a character string.

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

A type of DML statement that is use to update existing rows in a table.

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

It is a value that is unavailable, unassigned, unknown, or inapplicable.

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

This is used to perform wildcard searches of valid search string values.

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

An alter statement that is used to delete an existing column in the table.

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

Consists of a collection of DML statements that form a logical unit of work.

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

It is a table that is owned by the user SYS and can be accessed by all users.

Page 2 of 8