1
Q:

A database is used to

A) store data B) modify data
C) extract data D) All of the above

Answer:   D) All of the above



Explanation:

A database is used to store, modify, extract and to search for the data within it.

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 Workspace Report Error Discuss

0 38
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 Workspace Report Error Discuss

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

1 37
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 Workspace Report Error Discuss

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

0 123
Q:

Oracle SQL developer is an

Answer

Oracle SQL developer is an Oracle Database IDE.

Report Error

View answer Workspace Report Error Discuss

0 112
Q:

AND, OR and NOT are examples of

A) Clauses B) Boolean operators
C) Conjuctive operators D) Exclusive operators
 
Answer & Explanation Answer: B) Boolean operators

Explanation:
Report Error

View Answer Workspace Report Error Discuss

0 135
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 Workspace Report Error Discuss

0 151
Q:

A DBMS query language is designed to

A) Specify the structure of a database B) Support in the development of complex applications software
C) Support end users who use English-like commands D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:
Report Error

View Answer Workspace Report Error Discuss

0 222
Q:

A UNION query is which of the following?

A) Combines the output from multiple queries and does not include the same number of columns. B) Combines the output from multiple queries and must include the same number of columns.
C) Combines the output from no more than two queries and does not include the same number of columns. D) Combines the output from no more than two queries and must include the same number of columns.
 
Answer & Explanation Answer: B) Combines the output from multiple queries and must include the same number of columns.

Explanation:

A UNION query combines the output from multiple queries and must include the same number of columns.

Report Error

View Answer Workspace Report Error Discuss

2 452