Discussion
Home ‣ Interview ‣ Technology Comments
- Question
SQL views can be used to hide?
Options- A. Complicated SQL syntax
- B. Rows
- C. Columns
- D. All of the above
- Correct Answer
- All of the above
ExplanationIn 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.
- 1. A database is used to
Options- A. store data
- B. modify data
- C. extract data
- D. All of the above Discuss
- 2. We can modify an existing Company from
Options- A. Company Info > Alter
- B. Gateway of Tally > Modify Company
- C. Company Info > Alter Company
- D. All of the above Discuss
- 3. What is Catalog Views? Discuss
- 4. What are the properties and different Types of Sub-Queries? Discuss
- 5. What are user defined data-types and when do you use them? Discuss
- 6. The arranging of data in a logical sequence is called
Options- A. Summarizing
- B. Classifying
- C. Sorting
- D. Rearranging Discuss
- 7. What is the use of 'pretty printer' ? Discuss
- 8. When do we use End-of-selection ? Discuss
- 9. What is a prompt box? Discuss
- 10. Text/Html is called the __________ of the page
Options- A. content type
- B. MIME type
- C. content type/MIME type
- D. None of these Discuss
Technology problems
Search Results
Correct Answer: All of the above
Explanation:
A database is used to store, modify, extract and to search for the data within it.
Correct Answer: Company Info > Alter
Correct Answer: Catalog views return information that is used by the SQL Server Database Engine Catalog Views are the most general interface to the catalog metadata and provide the most efficient way to obtain, transform, and present customized forms of this information All user- available catalog metadata is exposed through catalog views
Correct Answer: Properties of Sub-Query - A sub-query must be enclosed in the parenthesis - A sub-query must be put in the right hand of the comparison operator, and - A sub-query cannot contain an ORDER-BY clause - A query can contain more than one sub-query Types of Sub-Query - Single-row sub-query, where the sub-query returns only one row - Multiple-row sub-query, where the sub-query returns multiple rows, and - Multiple column sub-query, where the sub-query returns multiple columns
Correct Answer: User defined data-types in SQL is an extension to the base SQL server data-types by provision of a descriptive name We use them to format the database and segregate specific repetitions of rows and columns in the database
Correct Answer: 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.
Correct Answer: To format the ABAP code 'pretty printer' is used
Correct Answer: End of the selection event is mostly used when we are writing HR-ABAP code In the HR-ABAP code, data is retrieved in the start of selection event and printing on the list and all will be done at the end of the selection event
Correct Answer: A prompt box allows the user to enter input by providing a text box
Correct Answer: content type/MIME type
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.