Sawaal
0
Q:

Which of the following statements is true concerning subqueries?

A) Does not start with the word SELECT. B) Involves the use of an inner and outer query.
C) Cannot return the same result as a query that is not a subquery. D) All of the above

Answer:   B) Involves the use of an inner and outer query.



Explanation:
Subject: SQL
Job Role: Analyst , Database Administration , IT Trainer
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 3599
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 5153
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 4262
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 4817
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 26287
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 6010
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 3549
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 2986