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 2

Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = ‘VA’;

SELECT NAME IN CUSTOMER WHERE STATE IN (‘VA’);

SELECT NAME IN CUSTOMER WHERE STATE = ‘VA’;

SELECT NAME IN CUSTOMER WHERE STATE = ‘V’;

SELECT NAME FROM CUSTOMER WHERE STATE IN (‘VA’);

SHOW ANSWER

How can a SQL developer add a key on a table?

While creating a table

With Alter table command

With SQL server Properties window

All of the Mentioned

SHOW ANSWER

Which of the following is not a Key in SQL Server?

Primary

Foreign

Alternate

Secondary

SHOW ANSWER

A _______________ key is a minimal super key 

Primary

Foreign

Candidate

Non-Prime

SHOW ANSWER

A relational database developer refers to a record as

 A criteria

A relation

A tuple

An attribute 

SHOW ANSWER

The relational model is based on the concept that data is organized and stored in two-dimensional tables called _____________ 

Fields

Records

Relations

Keys

SHOW ANSWER

 What is the full form of SQL?

Structured Query Language

Structured Query List

Simple Query Language

None of the Mentioned

SHOW ANSWER

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

 Data Definition Language(DDL)

Data Manipulation Language(DML)

DDL and DML

None of the Mentioned

SHOW ANSWER

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

SELECT DISTINCT

SELECT UNIQUE

SELECT DIFFERENT

All of the Mentioned

SHOW ANSWER

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

Insert

Modify

Look-up

All of the Mentioned

SHOW ANSWER

Which of the SQL statements is correct?

SELECT Username AND Password FROM Users

SELECT Username, Password FROM Users

SELECT Username, Password WHERE Username = ‘user1’

None of the Mentioned

SHOW ANSWER

Find the temperature in increasing order of all cities

SELECT city FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather;

SELECT city, temperature FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather ORDER BY city;

SHOW ANSWER

Which of the following is/are the DDL statements? 

 Create

Drop

Alter

All 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