MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 40 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. |
The ________ function can be used to create vectors of objects by concatenating things together. |
| A. | cp() |
| B. | c() |
| C. | concat() |
| D. | con() |
| Answer» C. concat() | |
| 2. |
Which of the following can be considered as object attribute? |
| A. | dimensions |
| B. | class |
| C. | length |
| D. | all of the mentioned |
| Answer» E. | |
| 3. |
R has how many atomic classes of objects? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 5 |
| Answer» E. | |
| 4. |
______________ define how the locations can be used. |
| A. | Data types |
| B. | Attributes |
| C. | Links |
| D. | Data Objects |
| Answer» C. Links | |
| 5. |
A standardized language used for commercial applications. |
| A. | C |
| B. | Java |
| C. | COBOL |
| D. | FORTRAN |
| Answer» D. FORTRAN | |
| 6. |
The program written by the programmer in high level language is called _____________ |
| A. | Object Program |
| B. | Source Program |
| C. | Assembled Program |
| D. | Compiled Program |
| Answer» C. Assembled Program | |
| 7. |
Which of the following is not a data type? |
| A. | Symbolic Data |
| B. | Alphanumeric Data |
| C. | Numeric Data |
| D. | Alphabetic Data |
| Answer» B. Alphanumeric Data | |
| 8. |
WHICH_OF_THE_FOLLOWING_DATA_TYPE_IS_USED_TO_CREATE_A_NUMBER_FOR_COUNTING_OR_INDEXING_ARRAYS??$ |
| A. | byte |
| B. | long |
| C. | int |
| D. | float |
| Answer» D. float | |
| 9. |
A_STANDARDIZED_LANGUAGE_USED_FOR_COMMERCIAL_APPLICATIONS.?$ |
| A. | C |
| B. | Java |
| C. | COBOL |
| D. | FORTRAN |
| Answer» D. FORTRAN | |
| 10. |
_______________IS_MONETARY_DATA_TYPE_IN_SQL_SERVER.?$ |
| A. | Smallmoney |
| B. | sql_variant |
| C. | Cursor |
| D. | None of the Mentioned |
| Answer» B. sql_variant | |
| 11. |
Which of the following data type stores longest floating-point value?$ |
| A. | boolean |
| B. | double |
| C. | float |
| D. | long |
| Answer» C. float | |
| 12. |
10$ |
| A. | 0 0 0 0 0 0 0 0 0 0 |
| B. | 01 |
| C. | None of the mentioned |
| Answer» C. None of the mentioned | |
| 13. |
_______________define_how_the_locations_can_be_used.$ |
| A. | Data types |
| B. | Attributes |
| C. | Links |
| D. | Data Objects |
| Answer» C. Links | |
| 14. |
Which_of_the_data_type_has_storage_size_of_8_bytes_?$ |
| A. | timestamp |
| B. | uniqueidentifier |
| C. | real |
| D. | smallmoney |
| Answer» B. uniqueidentifier | |
| 15. |
Which of the following keyword is used to declare Byte data type? |
| A. | Bytes |
| B. | Byte |
| C. | bytes |
| D. | byte |
| Answer» E. | |
| 16. |
Which of the following can be considered as object attribute ? |
| A. | dimensions |
| B. | class |
| C. | length |
| D. | all of the mentioned |
| Answer» E. | |
| 17. |
The program written by the programmer in high level language is called ____________? |
| A. | Object Program |
| B. | Source Program |
| C. | Assembled Program |
| D. | Compiled Program |
| Answer» C. Assembled Program | |
| 18. |
Which of the the following data type is not present in SQL Server ? |
| A. | bit |
| B. | boolean |
| C. | hierarchyid |
| D. | geography |
| Answer» C. hierarchyid | |
| 19. |
Which of the following is smallest integer data type? |
| A. | short |
| B. | long |
| C. | byte |
| D. | double |
| Answer» D. double | |
| 20. |
R objects can have attributes, which are like ________ for the object. |
| A. | metadata |
| B. | features |
| C. | expression |
| D. | none of the mentioned |
| Answer» B. features | |
| 21. |
What does FORTRAN stands for? |
| A. | Formula Transfer |
| B. | Formula Transformation |
| C. | Formula Translation |
| D. | Format Transformation |
| Answer» D. Format Transformation | |
| 22. |
_________ is a spatial data type. |
| A. | geometry |
| B. | sql_variant |
| C. | cursor |
| D. | all of the mentioned |
| Answer» C. cursor | |
| 23. |
Which of following cannot be stored in character data type? |
| A. | Special symbols |
| B. | String |
| C. | Letter |
| D. | Digit |
| Answer» C. Letter | |
| 24. |
Attributes of an object (if any) can be accessed using the ______ function. |
| A. | objects() |
| B. | attrib() |
| C. | attributes() |
| D. | all of the mentioned |
| Answer» D. all of the mentioned | |
| 25. |
BOOLEAN is a type of data type which basically gives a tautology or fallacy. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 26. |
You want to track date and time of the last write access per row ? |
| A. | Add TIMESTAMP column to the table |
| B. | Add a DATETIME column to the table and assign getdate() as the default value |
| C. | Add a DATETIME column to the table and write a trigger that sets its value |
| D. | Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server’s built-in functions |
| Answer» B. Add a DATETIME column to the table and assign getdate() as the default value | |
| 27. |
Which of the following is not a primitive data type? |
| A. | enum |
| B. | short |
| C. | byte |
| D. | char |
| Answer» B. short | |
| 28. |
Which of the following is not a basic data type in C language? |
| A. | float |
| B. | int |
| C. | real |
| D. | char |
| Answer» D. char | |
| 29. |
A column of type __________ may contain rows of different data types. |
| A. | ntext |
| B. | date |
| C. | smallmoney |
| D. | sql_variant |
| Answer» E. | |
| 30. |
If you explicitly want an integer, you need to specify the _____ suffix. |
| A. | D |
| B. | R |
| C. | L |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 31. |
What are the entities whose values can be changed called? |
| A. | Constants |
| B. | Variables |
| C. | Modules |
| D. | Tokens |
| Answer» C. Modules | |
| 32. |
ntext data type falls under which category ? |
| A. | Exact numerics |
| B. | Character strings |
| C. | Unicode character strings |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 33. |
Which of the following data types comes under ‘Integer’ data type?$ |
| A. | short |
| B. | long |
| C. | int |
| D. | all of the mentioned |
| Answer» E. | |
| 34. |
Numbers in R are generally treated as _______ precision real numbers. |
| A. | single |
| B. | double |
| C. | real |
| D. | all of the mentioned |
| Answer» C. real | |
| 35. |
Which of the following is not a valid representation in bits? |
| A. | 8-bit |
| B. | 24-bit |
| C. | 32-bit |
| D. | 64-bit |
| Answer» C. 32-bit | |
| 36. |
Exact Numeric data type is ___________ |
| A. | bigint |
| B. | int |
| C. | smallmoney |
| D. | all of the mentioned |
| Answer» E. | |
| 37. |
How many Primitive data types are there in Java? |
| A. | 4 |
| B. | 2 |
| C. | 8 |
| D. | 7 |
| Answer» D. 7 | |
| 38. |
*@Ac# is a type of ________________ data. |
| A. | Symbolic |
| B. | Alphanumeric |
| C. | Alphabetic |
| D. | Numeric |
| Answer» C. Alphabetic | |
| 39. |
Data types in SQL Server are organized into how many categories ? |
| A. | 6 |
| B. | 8 |
| C. | 9 |
| D. | 10 |
| Answer» B. 8 | |
| 40. |
Which of the following is large object data type ? |
| A. | varchar(max) |
| B. | varbinary(max) |
| C. | nvarchar(max) |
| D. | image |
| Answer» E. | |