MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 23 Mcqs, each offering curated multiple-choice questions to sharpen your Certification Questions knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which dml command is used in conjunction with identity? |
| A. | INSERT and UPDATE |
| B. | UPDATE and DELETE |
| C. | SCOPE_IDENTITY and IDENT_CURRENT |
| D. | Commit and rollback |
| Answer» D. Commit and rollback | |
| 2. |
Which packages contain the JDBC classes? |
| A. | java.sql |
| B. | java.sl |
| C. | java.jd |
| D. | java.jdbc |
| Answer» B. java.sl | |
| 3. |
Which command is used to return maximum value from result set? |
| A. | MAX |
| B. | MIN |
| C. | MAXIMUM |
| D. | MAXI |
| Answer» B. MIN | |
| 4. |
Which among the following keys are used to identify each row of the table uniquely? |
| A. | Primary key |
| B. | Unique key |
| C. | Partial key |
| D. | None of the above |
| Answer» B. Unique key | |
| 5. |
what will be the output of the following code?_x005F_x000D_ class Value_x005F_x000D_ {_x005F_x000D_ public int i = 15;_x005F_x000D_ }_x005F_x000D_ public class Test_x005F_x000D_ {_x005F_x000D_ public static void main(String argv[])_x005F_x000D_ {_x005F_x000D_ Test t = new Test();_x005F_x000D_ t.first();_x005F_x000D_ }_x005F_x000D_ public void first()_x005F_x000D_ {_x005F_x000D_ int i = 5;_x005F_x000D_ Value v = new Value();_x005F_x000D_ v.i = 25;_x005F_x000D_ second(v, i);_x005F_x000D_ System.out.println(v.i);_x005F_x000D_ }_x005F_x000D_ public void second(Value v, int i)_x005F_x000D_ {_x005F_x000D_ i = 0;_x005F_x000D_ v.i = 20;_x005F_x000D_ Value val = new Value();_x005F_x000D_ v = val;_x005F_x000D_ System.out.println(v.i + " " + i);_x005F_x000D_ }_x005F_x000D_ } |
| A. | 15 0 2 |
| B. | 15 0 0 |
| C. | 15 20 0 |
| D. | 15 0 20 |
| Answer» E. | |
| 6. |
What is the maximum number of triggers, can apply to a single table? |
| A. | 8 |
| B. | 10 |
| C. | 12 |
| D. | 14 |
| Answer» D. 14 | |
| 7. |
What is the default return value of a function? |
| A. | int |
| B. | char |
| C. | string |
| D. | None of the above |
| Answer» B. char | |
| 8. |
What is the output after compile and run the following code ?_x005F_x000D_ int Output = 10;boolean b = false;if((b == true) && ((Output += 10) == 20)){ System.out.println("We are equal " + Output);}else{ System.out.println("Not equal! " + Output);} |
| A. | Compilation and output of "We are equal 10" |
| B. | Compilation and output of "Not equal! 10" |
| C. | Compilation error, attempting to perform binary comparison on logical data type |
| D. | Compilation and output of "Not equal! 20" |
| Answer» C. Compilation error, attempting to perform binary comparison on logical data type | |
| 9. |
STUFF and REPLACE are used to replace characters in a string |
| A. | 1 |
| B. | |
| C. | |
| D. | |
| Answer» B. | |
| 10. |
Multiple users can share a local temporary table |
| A. | 1 |
| B. | |
| C. | |
| D. | |
| Answer» C. | |
| 11. |
MOV extension refers usually to what kind of files? |
| A. | Audio |
| B. | Movies or other Videos |
| C. | Images |
| D. | Documents |
| Answer» C. Images | |
| 12. |
Insert command falls in which sub-language of SQL ? |
| A. | DCL |
| B. | DQL |
| C. | DML |
| D. | DDL |
| Answer» D. DDL | |
| 13. |
In R-DBMS, the data is organized in the form of _____. |
| A. | Hierarchical structure |
| B. | Tabular structure |
| C. | Linked structure |
| D. | All of the above |
| Answer» C. Linked structure | |
| 14. |
In the following pieces of code, B and D will compile without any error. True or false ?_x005F_x000D_ A: StringBuffer sb1 = "abcd";_x005F_x000D_ B: Boolean b = new Boolean("abcd"); _x005F_x000D_ C: byte b = 255; _x005F_x000D_ D: int x = 0x1234; _x005F_x000D_ E: float fl = 1.2; |
| A. | 1 |
| B. | |
| C. | |
| D. | |
| Answer» B. | |
| 15. |
How many joining conditions are required to join 4 tables in SQL? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» D. 4 | |
| 16. |
Go command is a signal to execute the entire batch of SQL statements after previous Go |
| A. | 1 |
| B. | |
| C. | |
| D. | |
| Answer» B. | |
| 17. |
Data integrity constraints are used to |
| A. | Ensure that duplicate records are not entered into the table |
| B. | Prevent users from changing the values stored in the table |
| C. | Control who is allowed access to the data |
| D. | Improve the quality of data entered for a specific property like table column |
| Answer» E. | |
| 18. |
Count function in SQL returns the number of |
| A. | groups |
| B. | values or rows |
| C. | columns |
| D. | distinct values |
| Answer» C. columns | |
| 19. |
Copying the logs on the standby/backup server is an operation of Log Shipping |
| A. | 1 |
| B. | |
| C. | |
| D. | |
| Answer» B. | |
| 20. |
Breaking of relationships is allowed once referential integrity on a database is enforced |
| A. | 1 |
| B. | |
| C. | |
| D. | |
| Answer» C. | |
| 21. |
Can’t update primary table’s primary key if row being modified has related rows in secondary table once referential integrity is enforced |
| A. | 1 |
| B. | |
| C. | |
| D. | |
| Answer» B. | |
| 22. |
A Transparent DBMS |
| A. | Keep its logical structure hidden from users |
| B. | Can access control |
| C. | Keeps its physical structure hidden from users |
| D. | Can not hide sensitive information from users |
| Answer» D. Can not hide sensitive information from users | |
| 23. |
A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can't contain Nulls |
| A. | 1 |
| B. | |
| C. | |
| D. | |
| Answer» B. | |