Sawaal
12
Q:

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

A) Data Manipulation Language(DML) B) Data Definition Language(DDL)
C) Both A & B D) None

Answer:   B) Data Definition Language(DDL)



Explanation:

The Data Definition Language (DDL) is used to manage table and index structure.

CREATE,

ALTER,

RENAME,

DROP and

TRUNCATE

statements are the names of few data definition elements.

Subject: SQL
Job Role: IT Trainer , Database Administration , Analyst
Related Questions
Q:

The arranging of data in a logical sequence is called

A) Summarizing B) Classifying
C) Sorting D) Rearranging
 
Answer & Explanation Answer: C) Sorting

Explanation:

The process of arranging any items in a systematic manner in a logical sequence is called as Sorting. It can be of two types :

1. Ordering

Arranging items following some criterion like ascending or descending order

2. Categorizing

Grouping items with similar properties together.

Report Error

View Answer Report Error Discuss

Filed Under: SQL
Exam Prep: AIEEE , Bank Exams , CAT

3 3615
Q:

Which SQL keyword is used to sort the result-set?

A) ORDER B) ORDER BY
C) SORT BY D) SORT
 
Answer & Explanation Answer: B) ORDER BY

Explanation:

SQL keyword ORDER BY is used to sort the result-set.

Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: Analyst , Database Administration , IT Trainer

1 5188
Q:

Embedded SQL is which of the following?

A) The process of making an application capable of generating specific SQL code on the fly. B) Hard-coded SQL statements in a trigger.
C) Hard-coded SQL statements in a program language such as Java. D) Hard-coded SQL statements in a procedure.
 
Answer & Explanation Answer: C) Hard-coded SQL statements in a program language such as Java.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: SQL
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

2 4290
Q:

The SQL SELECT statement is capable of

A) Projection B) Selection
C) Protection & Security D) Both A & B
 
Answer & Explanation Answer: D) Both A & B

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: SQL
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

2 4856
Q:

A subquery in an SQL SELECT statement is enclosed in

A) [ ] B) { }
C) < > D) ( )
 
Answer & Explanation Answer: D) ( )

Explanation:

A subquery in an SQL SELECT statement is enclosed in parenthesis (...).

Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: Database Administration , IT Trainer , Software Architect

8 26315
Q:

SQL views can be used to hide?

A) Complicated SQL syntax B) Rows
C) Columns D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

In SQL, a SQL view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table.

 

SQL views can be used to hide rows and columns and complicated SQL syntax.

 

The fields in a view are fields from one or more real tables in the database.

Report Error

View Answer Report Error Discuss

Filed Under: SQL
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

3 6036
Q:

Which of the following is not a relational database?

A) 4th Dimension B) Reflex
C) dBASE IV D) FoxPro
 
Answer & Explanation Answer: B) Reflex

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: Database Administration , IT Trainer

1 3577
Q:

Oracle SQL developer is an

Answer

Oracle SQL developer is an Oracle Database IDE.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL
Job Role: Analyst , Database Administration , IT Trainer

0 2998