Sawaal
  • Home/
  • Searching for SQL

 Searching for "SQL"

Q:

The FROM SQL clause is used to 

A) specify what table we are selecting or deleting data FROM B) specify search condition  
C) specify range for search condition   D) None of these
 
Answer & Explanation Answer: A) specify what table we are selecting or deleting data FROM

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

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

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

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

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

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

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

Q:

Which of the following is a comparison operator in SQL?

A) = B) <>
C) ` D) /
 
Answer & Explanation Answer: A) =

Explanation:

The comparison operator that is used in SQL is '='. Comparison operators test whether two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image data types.

Report Error

View Answer Report Error Discuss

Filed Under: SQL
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer