Oracle Interview Questions and Answers

0 votes

Q: What is the full form of SQL?

asked Nov 25, 2021 in Oracle by DavidAnderson

0 votes

Q: Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

asked Nov 25, 2021 in Oracle by DavidAnderson

0 votes

Q: In SQL, which command is used to SELECT only one copy of each set of duplicable rows

asked Nov 25, 2021 in Oracle by DavidAnderson

0 votes

Q: A command that lets you change one or more fields in a record is

asked Nov 25, 2021 in Oracle by DavidAnderson

0 votes

Q: Which of the SQL statements is correct?

asked Nov 25, 2021 in Oracle by DavidAnderson

0 votes

Q: Find the temperature in increasing order of all cities (a) SELECT city FROM weather ORDER BY temperature;

asked Nov 25, 2021 in Oracle by DavidAnderson

0 votes

Q: Which of the following is illegal?

asked Nov 25, 2021 in Oracle by DavidAnderson

0 votes

Q: Which of the following is/are the DDL statements?

asked Nov 25, 2021 in Oracle by DavidAnderson

0 votes

Q: In SQL, which command(s) is(are) used to change a table’s storage characteristics?

asked Nov 25, 2021 in Oracle by DavidAnderson

0 votes

Q: In SQL, which of the following is not a data definition language commands?

asked Nov 25, 2021 in Oracle by DavidAnderson

0 votes

Q: ________clause is an additional filter that is applied to the result.

asked Nov 25, 2021 in Oracle by DavidAnderson

0 votes

Q: ___________ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.

asked Nov 25, 2021 in Oracle by DavidAnderson

0 votes

Q: SQL has how many main commands for DDL:

asked Nov 25, 2021 in Oracle by DavidAnderson

0 votes

Q: Which command defines its columns, integrity constraint in create table:

asked Nov 25, 2021 in Oracle by DavidAnderson

0 votes

Q: Which command is used for removing a table and all its data from the database:

asked Nov 25, 2021 in Oracle by DavidAnderson

0 votes

Q: Which command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained:

asked Nov 25, 2021 in Oracle by DavidAnderson

0 votes

Q: The language used application programs to request data from the DBMS is referred to as __________

asked Nov 25, 2021 in Oracle by DavidAnderson

0 votes

Q: In SQL, which of the following is not a data Manipulation Language Commands?

asked Nov 25, 2021 in Oracle by DavidAnderson

0 votes

Q: Which of the following is not a type of SQL statement?

asked Nov 24, 2021 in Oracle by DavidAnderson

0 votes

Q: Which of the following is not included in DML (Data Manipulation Language)

asked Nov 24, 2021 in Oracle by DavidAnderson

0 votes

Q: TRUNCATE statement in SQL is a –

asked Nov 24, 2021 in Oracle by DavidAnderson

0 votes

Q: In SQL, which command is used to add new rows to a table?

asked Nov 24, 2021 in Oracle by DavidAnderson

0 votes

Q: A table that displays data redundancies yields ____________ anomalies.

asked Nov 24, 2021 in Oracle by DavidAnderson

0 votes

Q: A type of query that is placed within a WHERE or HAVING clause of another query is called

asked Nov 24, 2021 in Oracle by DavidAnderson

0 votes

Q: DCL stands for :

asked Nov 24, 2021 in Oracle by DavidAnderson

0 votes

Q: TCL stands for:

asked Nov 24, 2021 in Oracle by DavidAnderson

+1 vote

Q: In an SQL statement, which of the following parts states the conditions for row selection?

asked Nov 24, 2021 in Oracle by DavidAnderson

0 votes

Q: A transaction completes its execution is said to be

asked Nov 24, 2021 in Oracle by DavidAnderson

0 votes

Q: Which of the following keyword is used with Data Control Language (DCL) statements?

asked Nov 24, 2021 in Oracle by DavidAnderson

0 votes

Q: DCL Provides Commands To Perform Actions Like _____________

asked Nov 24, 2021 in Oracle by DavidAnderson

Page:

« prev
1
2
3
4
5
6
7
8
9
next »

...