MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 10 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
_______________RETURNS_THE_RANK_OF_ROWS_WITHIN_THE_PARTITION_OF_A_RESULT_SET,_WITHOUT_ANY_GAPS_IN_THE_RANKING.?$ |
| A. | RANK |
| B. | NTILE |
| C. | DENSE_RANK |
| D. | ROW_NUMBER |
| Answer» D. ROW_NUMBER | |
| 2. |
Built in Functions in SQL Server is categorized in to how many category ?$ |
| A. | 4 |
| B. | 5 |
| C. | 6 |
| D. | 7 |
| Answer» B. 5 | |
| 3. |
Which of the the following is not conversion function? |
| A. | CAST and CONVERT |
| B. | PARSE |
| C. | TRY_CAST |
| D. | TRY_CASE |
| Answer» E. | |
| 4. |
Text and Image Functions are ___________ |
| A. | nondeterministic |
| B. | deterministic |
| C. | table valued |
| D. | All of the mentioned |
| Answer» B. deterministic | |
| 5. |
DecryptByKeyAutoCert is ________________ type function. |
| A. | Symmetric Encryption and decryption |
| B. | Encryption Hashing |
| C. | Asymmetric Encryption and decryption |
| D. | Symmetric decryption with Automatic key handling |
| Answer» E. | |
| 6. |
__________ are used for supporting encryption, decryption, digital signing and their validation. |
| A. | Cryptographic functions |
| B. | Cursor functions |
| C. | Configuration functions |
| D. | None of the mentioned |
| Answer» B. Cursor functions | |
| 7. |
NESTLEVEL function falls under which of the following category ? |
| A. | Configuration functions |
| B. | Cursor functions |
| C. | Mathematical functions |
| D. | Date and Time Data Functions |
| Answer» B. Cursor functions | |
| 8. |
Which of the following is not a mathematical function ? |
| A. | ATN2 |
| B. | POWER |
| C. | PI |
| D. | CEIL |
| Answer» E. | |
| 9. |
Which of the following function checks whether the expression is a valid date or not ? |
| A. | ISDATE |
| B. | ISDAY |
| C. | ISVALID |
| D. | ISYEAR |
| Answer» B. ISDAY | |
| 10. |
______________ function returns current date and time. |
| A. | SET DATEFIRST |
| B. | SYSDATETIME |
| C. | Cert_ID |
| D. | GETDATE |
| Answer» E. | |