Quiz - Nutshell Infosoft Pvt Ltd

Intern 2024

The number of attempts remaining is 1

1 / 30

1. Which function combines the two different columns?

A. None of the above

B. ADD

C. MERGE

D. CONCAT

2 / 30

2. How do you manage access rights and record rules in Odoo for a specific model?

A. By writing them in XML files under the security directory of the module

B. By defining them in the model's Python file

C. By configuring them in the Odoo user interface under Settings

D. none

3 / 30

3. Which of the following provides a correct syntax for UPDATE statement?

A. Update table_name Values column1=value1, column2=value2, … Where condition(s);

B. Update table_name Set column1=value1, column2=value2, … Where condition(s);

C. Update table_name Modify column1=value1, column2=value2, … Where condition(s);

D. Update table_name Alter column1=value1, column2=value2, … Where condition(s);

4 / 30

4. NULL values can be inserted into a table using INSERT INTO statement

A. True

B. False

5 / 30

5. Which of the following operator can be used with a multiple-row subquery?

A. =

B. BETWEEN

C. <>

D. NOT IN

6 / 30

6. Which of the following is a valid conditional statement in Python?

A. if a = 5:

B. if (a = 5):

C. if a == 5:

D. if a <> 5:

7 / 30

7. Which of these data types does Python not natively support?

A. Tuples

B. Dictionaries

C. Lists

D. Arrays

8 / 30

8. How can you change “Thomas” into “Michel” in the “LastName” column in the Users table?

A. MODIFY Users SET LastName = 'Thomas' INTO LastName = 'Michel'

B. MODIFY Users SET LastName = 'Michel' WHERE LastName = 'Thomas'

C. UPDATE Users SET LastName = 'Michel' WHERE LastName = 'Thomas'

D. UPDATE User SET LastName = 'Thomas' INTO LastName = 'Michel'

9 / 30

What does the following code snippet do?

9. DELETE FROM STUDENTS WHERE AGE = 16; ROLLBACK;

A. deletes the row from the table where AGE=16

B. performs an undo operation on the delete operation

C. deletes the entire table

D. none of the above

10 / 30

10. What will be the output of the following code snippet?

example = [“Sunday”, “Monday”, “Tuesday”, “Wednesday”];

del example[2]

print(example)

A. ["Sunday", "Monday", "Tuesday", "Wednesday"]

B. ["Sunday", "Monday", "Tuesday"]

C. ["Monday", "Tuesday", "Wednesday"]

D. ["Sunday", "Monday", "Wednesday"]

11 / 30

11. What is QWeb in Odoo?

A. A database management system

B. A front-end framework

C. A reporting engine

12 / 30

What is the purpose of the 12. res.partner model in Odoo?

A. To manage user permissions

B. To store contact and company information

C. To handle financial transactions

D. To manage product information

13 / 30

13. Which of the following is a Immutable data type in Python?

A. List

B. Tuple

14 / 30

14. Which file contains the main configuration settings for an Odoo instance?

A. settings.py

B. config.xml

C. odoo.conf

D. config.ini

15 / 30

15. what is transient model in Odoo?

A. Regular model

B. used for wizard-style user interaction

C. None

16 / 30

16. What is the functionality of SQL COUNT?

A. It returns the no of record of row

B. It returns the no of record of database

C. It returns the no of record of column

D. It returns the no of record of table

17 / 30

17. What is the purpose of an if statement in Python?

A. To define a function

B. To execute a block conditionally

C. To handle exceptions

D. To loop through a sequence

18 / 30

18. Which XML tag is used to define a menu item in Odoo?

A. <record>

B. <item>

C. <menu>

19 / 30

19. Which statement is TRUE about the GROUP BY Clause?

A. In order to select the defined groups, GROUP BY Clause is used

B. In order to return the rows, GROUP BY Clause is used.

C. In order to group the rows that share the same property, GROUP BY Clause is used.

D. In order to retrieve rows, GROUP BY Clause is used.

20 / 30

20. What is a dictionary in Python?

A. A mutable collection of key-value pairs

B. A collection of unique elements

C. An ordered collection of elements

21 / 30

21. What is Odoo?

A. A content management system

B. A database management system

C. An enterprise resource planning software

D. A programming language

22 / 30

22. Which of the following are valid string manipulation functions in Python?

A. count()

B. all of the above

C. upper()

D. strip()

23 / 30

23. In SQL, what is the difference between CHAR and VARCHAR data types?

A. VARCHAR is used only for numeric data

B. No difference

C. CHAR is fixed length, VARCHAR is variable length

D. CHAR is variable length, VARCHAR is fixed length

24 / 30

24. In order to delete duplicate rows from the table, which keyword is used?

A. DELETE

B. WHERE

C. DISTINCT

D. FROM

25 / 30

25. Which method is used to create a new record in Odoo’s ORM?

A. create_record()

B. new()

C. create()

D. add()

26 / 30

26. How do you define a default value for a field in an Odoo model?

A. Using the 'default' attribute in the field definition

B. By defining a default_value method in the model

27 / 30

27. For inheritance in odoo we used

A. inherit

B. _inherits

C. _inherit

28 / 30

28. Which of the following is a valid field type in Odoo?

A. File

B. Binary

C. Media

D. Image

29 / 30

29. Which directive is used to define a QWeb template in Odoo?

A. <view>

B. <qweb>

C. <xml>

D. <template>

30 / 30

30. Which of the following function returns the total sum of a numeric column?

A. addition( )

B. add( )

C. totalsum( )

D. sum()

Your score is