Database interview questions
Database interview questions
Take as many assements as you can to improve your validate your skill rating
Total Questions: 17
1. A single set of related data values is referred to as
Correct Answer is : Record
2. What is used to uniquely identify each record in a table?
Correct Answer is : Primary key
3. ___________ data type stores date and time values between the years 100 through 9999.
Correct Answer is : Date/Time
4. In the datasheet view of the Student table, the StudentAddress field needs to be displayed as Address. Which field property can be used to achieve this?
Correct Answer is : Caption
5. The ______________ of a table is used to modify the design of a table, like modifying the name of a field or changing the data type of a field.
Correct Answer is : Design View
6. openDatabase() method does not take the argument in __________
Correct Answer is : server name
7. The sign is used for the placeholder _____________
Correct Answer is : ?
8. Which feature is not used when SQL features are not being supported?
Correct Answer is : END
9. transaction() does not take the argument _______
Correct Answer is : database name
10. Which method is used to verifythe version number?
Correct Answer is : changeVersion()
11. Which error is invoked when SQLTransactionCallback does not execute?
Correct Answer is : INVALID_STATE_ERR
12. Which object is created for read-only transaction?
Correct Answer is : SQLTransactionSync
13. insertId attribute returns ____________
Correct Answer is : row ID
14. Number of rows is returned by the attribute __________
Correct Answer is : rowsAffected
15. Which of the error is raised when the quantity of data is too much?
Correct Answer is : TOO_LARGE_ERR
16. What is the required argument to openDatabase?
Correct Answer is : version number
17. Which attribute is used for getting an individual row?
Correct Answer is : results.rows.item(i)
