Trinity - Oracle Interview Preparation Questions
Call
whatsapp
9447387064 | 9847003556
0471-2335855 | 8089080088 | 0471-2334855
9447387064 | 9847003556
0471-2335855 | 8089080088 | 0471-2334855
Cisco Training in Trivandrum, Trinity Technologies

No.1 Training Institute in Kerala

ORACLE QUESTIONS : PART 3

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

Create command

Drop table command

Alter table command

 All of the Mentioned

SHOW ANSWER

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

TRUNCATE command

Create command

Drop table command

Alter table command

SHOW ANSWER

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

Data Manipulation Language (DML)

Data Definition Language (DDL)

Data Control Language (DCL)

Data Communication Language (DCL)

SHOW ANSWER

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

INSERT

UPDATE

DELETE

CREATE

SHOW ANSWER

TRUNCATE statement in SQL is a –

DML statement

 DDL statement

DCL statement

TCL statement

SHOW ANSWER

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

Alter Table

Add row

Insert

Append

SHOW ANSWER

DCL stands for :

Data Control Language

Data Console Language

Data Console Level

Data Control Level

SHOW ANSWER

TCL stands for:

Transaction control languages

Transaction command languages

Transaction connect languages

None of the Mentioned

SHOW ANSWER

_________commands in SQL allow controlling access to data within database.

Database

Data

Data control

All of the Mentioned

SHOW ANSWER

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

Where

From

Order By

Group By

SHOW ANSWER

A transaction completes its execution is said to be

Committed

Aborte

Rolled back

Failed

SHOW ANSWER

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

SELECT

INSERT

DELETE

GRANT

SHOW ANSWER

DCL Provides Commands To Perform Actions Like _____________ 

Change The Structure Of Tables

Insert, Update Or Delete Records And Data Values

Authorizing Access And Other Control Over Database

None of the Mentioned

SHOW ANSWER
BACK | NEXT
TRINITY SOFTWARE SOLUTIONS,IInd floor, Radheyam Towers, Gandhari Amman Kovil Road, Pulimood, Trivandrum - 1
0471-2334855 | 2335855 | 9447387064 | 9847003556 info@trinitytechnology.in