SQL Basics - CSE Questions and Answers

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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

Data Definition Language(DDL)

Data Manipulation Language(DML)

Both of above

None

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Which operator performs pattern matching?

BETWEEN operator

LIKE operator

EXISTS operator

None of these

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

What operator tests column for the absence of data?

EXISTS operator

NOT operator

IS NULL operator

None of these

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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

ALTER TABLE

MODIFY TABLE

CHANGE TABLE

All of the above

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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

RENAME

REVOKE

GRANT

UPDATE

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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 above

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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

Insert

Modify

Look-up

All of the above

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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 these

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

The FROM SQL clause is used to...

specify what table we are selecting or deleting data FROM

specify range for search condition

specify search condition

None of these