Have an account?

Need An Account,

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account?

Sorry, you do not have permission to ask a question, You must login to ask a question. Please subscribe to paid membership

Don't have account,
Please subscribe to paid membership

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Search
Ask A Question
Home/ SQLAlchemy/SQLAlchemy Multiple-Choice Questions (MCQs)

Quearn Latest Articles

On: June 21, 2023 Posted in SQLAlchemy Comments: 0 Views: 52

SQLAlchemy Multiple-Choice Questions (MCQs)

SQLAlchemy is an open-source SQL toolkit and object-relational mapper for the Python programming language released under the MIT License.

SQLAlchemy MCQs: This section contains multiple-choice questions and answers on the various topics of SQLAlchemy. Practice these MCQs to test and enhance your skills on SQLAlchemy.

List of SQLAlchemy MCQs

1. What do you mean by ORM?

  1. Oriented relational mapping
  2. Object-relational mapping
  3. Object relation method

Answer: B) Object-relational mapping

Explanation:

ORM stands for object-relational mapping.

2. Why do we use ORM?

  1. It acts as a bridge between object-oriented programs and relational databases.
  2. It acts as a bridge between object-oriented programs and non-relational databases.
  3. It acts as a bridge between relational databases and non-relational databases.

Answer: A) It acts as a bridge between object-oriented programs and relational databases.

Explanation:

It acts as a bridge between object-oriented programs and relational databases.

3. Which of the following tools can be used as alternatives to SQLAlchemy?

  1. Django
  2. Hibernate
  3. Pandas
  4. MySQL
  5. All of the above

Answer: E) All of the above

Explanation:

Some alternatives of SQLAlchemy are as follows: Django, Hibernate, Pandas, MySQL, Sequelize, etc.

4. Which of the following is the creator of SQLAlchemy?

  1. Raymond Boyce
  2. Donald Chamberlin.
  3. Michael Bayer

Answer: C) Michael Bayer

Explanation:

Michael Bayer created SQLAlchemy.

5. Which of the following commands will you use to install SQLAlchemy using PIP?

  1. Pip install alchemy
  2. Pip install SQL alchemy
  3. Pip install sqlalchemy
  4. Pip install SQL
  5. Pip install alchemy

Answer: C) Pip install sqlalchemy

Explanation:

Pip install sqlalchemy, is the command which we will use for installing SQLAlchemy using the python package manager.

6. How many distinct components does SQLAlchemy have?

  1. 4
  2. 5
  3. 3
  4. 2

Answer: D) 2

Explanation:

SQLAlchemy has two distinct components mainly known as core and ORM.

7. Which SQLAlchemy component consists of the SQL rendering engine, DBAPI integration, transaction integration, and schema description services?

  1. SQLAlchemy Core
  2. SQLAlchemy ORM

Answer: A) SQLAlchemy Core

Explanation:

SQLAlchemy Core components consist of the SQL rendering engine, DBAPI integration, transaction integration, and schema description services.

8. Which SQLAlchemy component provides a domain-centric mode of usage?

  1. SQLAlchemy Core
  2. SQLAlchemy ORM

Answer: B) SQLAlchemy ORM

Explanation:

SQLAlchemy ORM component provides a domain-centric mode of usage.

9. Which SQLAlchemy component provides schema-centric usage?

  1. SQLAlchemy Core
  2. SQLAlchemy ORM

Answer: A) SQLAlchemy Core

Explanation:

SQLAlchemy Core component provides schema-centric usage.

10. Which class connects a pool and a dialect in SQLAlchemy?

  1. Core class
  2. ORM class
  3. Engine class
  4. Object class

Answer: C) Engine class

Explanation:

Engine class connects a pool and a dialect in SQLAlchemy.

11. How do you instantiate the object of the engine class?

  1. Using object_engine()
  2. Using create_object()
  3. Using engine_object()
  4. Using create_engine()

Answer: D) Using create_engine()

Explanation:

Using the create_engine() function we instantiate the object of the engine class.

12. Which of the following is a shortcut to established SQLAlchemy logging?

  1. Flag=1
  2. Echo flag
  3. Flag=0

Answer: B) Echo flag

Explanation:

Echo flag is a shortcut to established SQLAlchemy logging.

13. What does the create_engine() function return?

  1. Object
  2. Value
  3. Engine object
  4. Engine object value

Answer: C) Engine object

Explanation:

Create_engine() function returns the engine object.

14. Which of the following returns the connection object?

  1. Connect()
  2. Execute()
  3. Dispose()
  4. Transaction()

Answer: A) Connect()

Explanation:

Connect() method returns us the connection object.

15. Which of the following methods will you use if you want to cast out the connection pool?

  1. Driver()
  2. Execute()
  3. Dispose()
  4. Transaction()

Answer: C) Dispose()

Explanation:

Dispose() method is used when you want to cast out/ dispose of the connection pool.

16. What is metadata?

  1. Metadata contains the rows information only.
  2. Metadata contains the column information only.
  3. Metadata contains the definition of the table but not their associated objects.
  4. Metadata contains the definitions of tables including the associated objects like views etc.

Answer: D) Metadata contains the definitions of tables including the associated objects like views etc.

Explanation:

Metadata holds the definitions of tables including the associated objects like views etc.

17. All defined table objects are created using the engine object and stored in metadata via the ____ function.

  1. Create_engine()
  2. Create_table()
  3. Create_all()
  4. Create_db()

Answer: C) Create_all()

Explanation:

All defined table objects are created using the engine object and stored in metadata via the Create_all() function.

18. The object returned by the. The Execute() method is known as ____-?

  1. Result Proxy
  2. Result
  3. Result_object

Answer: A) Result Proxy

Explanation:

The object returned by the. The Execute() method is known as the resultproxy.

19. How many records does the fetchone() function return?

  1. All the records
  2. Only single record
  3. All the columns
  4. All the rows

Answer: B) Only single record

Explanation:

Fetchone() function returns us the single record.

20. How do you combine multiple conditions in the WHERE clause in SQLAlchemy?

  1. And()
  2. And_()
  3. Or()
  4. Or_()

Answer: B) And_()

Explanation:

And_() is used to combine multiple conditions in the WHERE clause in SQLAlchemy.

21. If you want to turn a selectable object into an alias, which function will you use?

  1. alias()
  2. Same()
  3. From clause. Alias()
  4. .alias()

Answer: C) From clause. Alias()

Explanation:

From clause. Alias() function turns a selectable object into an alias.

22. Which of the following you will use, if you want to use an operator in SQLAlchemy?

  1. Or
  2. Or_()
  3. Or()
  4. _or()

Answer: B) Or_()

Explanation:

In SQLAlchemy or operator is written as or_().

23. Which of the following is the correct syntax to sort the names in ascending order?

  1. pool = select([students]).order_by.asc(students.c.name)
  2. pool = select([students]).asc(students.c.name)
  3. pool = select([students]).where(asc(students.c.name))
  4. pool = select([students]).order_by(asc(students.c.name))

Answer: D) pool = select([students]).order_by(asc(students.c.name))

Explanation:

The correct syntax to sort the names in ascending order is:

pool = select([students]).order_by(asc(students.c.name))

24. Which of the following functions is used when you have to check if the value of a certain column falls between a range?

  1. Between()
  2. Range()
  3. Asc()
  4. Check()

Answer: A) Between()

Explanation:

Between() function is used when you have to check if the value of a certain column falls between a range.

25. Which of the following functions returns the number of rows selected from a table?

  1. total()
  2. Range()
  3. count()
  4. fetchone()

Answer: C) count()

Explanation:

Count() function returns the number of rows selected from a table.

26. In SQLAlchemy, if you want to use the max function, what syntax would you write?

  1. Max()
  2. Max_()
  3. Func.max()
  4. Max

Answer: C) Func.max()

Explanation:

Func.max() is the correct syntax to use max in SQLAlchemy.

27. In SQLAlchemy, if you want to use the min function, which API will you import?

  1. Import min
  2. Import min function
  3. Import minimum
  4. Import func

Answer: D) Import func

Explanation:

The func keyword in SQLAlchemy API is used to generate generic functions.

28. Which of the following functions is used to eradicate duplicates from the result set?

  1. Remove()
  2. Remove_dup()
  3. Union()
  4. Intersect()

Answer: C) Union()

Explanation:

Union() function is used to eradicate duplicates from the result set.

29. ____ function or operators are used when merging two SELECT statements and returning rows that were not returned by the second SELECT statement?

  1. Remove()
  2. Except()
  3. Union()
  4. Intersect()

Answer: B) Except()

Explanation:

Except() function or operator is used when merging two SELECT statements and returning rows that were not returned by the second SELECT statement.

30. Which of the following functions shows mutual rows from both the SELECT statements?

  1. Remove()
  2. Except()
  3. Union()
  4. Intersect()

Answer: D) Intersect()

Explanation:

Intersect() function shows mutual rows from both the SELECT statements.

31. How many arguments does the create_engine() function take?

  1. 2
  2. 3
  3. 4
  4. 1

Answer: A) 2

Explanation:

Create engine takes two arguments, the name of the database and the echo partner.

32. Declarative swaps all the Column objects with special Python accessors known as ____?

  1. Accessors
  2. Descriptors
  3. Descriptions

Answer: B) Descriptors

Explanation:

Declarative replaces all the Column objects with special Python accessors known as descriptors.

33. Which of the following functions flushes all items and any transaction in progress?

  1. Commit()
  2. Flush()
  3. Expire()
  4. Rollback()

Answer: A) Commit()

Explanation:

Commit() function flushes all items and any transaction in the progress.

34. Which of the following functions closes the session using connection invalidation?

  1. Flush()
  2. Expire()
  3. Rollback()
  4. Invalidate()

Answer: D) Invalidate()

Explanation:

Invalidate() function closes the session using connection invalidation.

35. To add multiple records, which of the following functions will you use?

  1. add()
  2. add_all()
  3. commit()
  4. Invalidate()

Answer: B) add_all()

Explanation:

add_all() function is used to add multiple records.

36. To add one or more columns, which of the following functions will you use?

  1. columns()
  2. columns_add()
  3. add_columns()

Answer: C) add_columns()

Explanation:

add_columns() function is used to add one or more columns.

37. In which of the following methods, the instance returned will provide direct access to the identity map of the session that owns the primary key identifier?

  1. join()
  2. one()
  3. add()
  4. Get()

Answer: D) Get()

Explanation:

In get() function the instance returned will provide direct access to the identity map of the session that owns the primary key identifier.

38. If you want to validate whether the column value belongs to a collection of items in a list then which of the following functions you will use?

  1. In()
  2. Like()
  3. Set_in()
  4. In_()

Answer: A) In()

Explanation:

In_() method validates whether the column value belongs to a collection of items in a list.

39. Is there any difference between the first() method and one() method?

  1. Yes
  2. No

Answer: A) YES

Explanation:

First() method typically applies a limit of one and returns the foremost result whereas one() method completely fetches all rows.

40. Which of the following methods returns the first element of the first result?

  1. One()
  2. First()
  3. Scalar()
  4. Fetch()

Answer: C) Scalar()

Explanation:

Scalar() method returns the first element of the first result.

41. Is the scalar() method and one() method both perform the same functionality?

  1. Yes
  2. No

Answer: B) NO

Explanation:

No, both are different. Scalar() method returns the first element of the first result, whereas the one() method completely fetches all rows.

42. In which of the following function text is composed into a statement that is passed to the database with the majority of its original form?

  1. Filter()
  2. Text()
  3. Query()
  4. Text_all()

Answer: B) Text()

Explanation:

In the Text() method, the text is composed into a statement that is passed to the database with the majority of its original form.

43. How many relationship patterns does SQLAlchemy provide?

  1. 5
  2. 6
  3. 4
  4. 3

Answer: C) 4

Explanation:

SQLAlchemy provides four types of relationship patterns: one-to-many, many-to-one, one-to-one, and many to many.

44. Which kind of relationship refers to a parent with the help of a foreign key on the child table?

  1. One to many
  2. Many to one
  3. One to one
  4. Many to many.

Answer: A) One to many

Explanation:

One-to-many relationships refers to parents with the help of a foreign key on the child table.

45. Which kind of relationship places a foreign key in the parent table referencing the child?

  1. One to many
  2. Many to one
  3. One to one
  4. Many to many.

Answer: B) Many to one

Explanation:

Many-to-one relationship places a foreign key in the parent table referencing the child.

46. To achieve the left outer join, which of the following functions is used?

  1. Join()
  2. Join_left()
  3. Outerjoin()
  4. Outer_join()

Answer: C) Outerjoin()

Explanation:

Outerjoin() is used to achieve left outer join.

47. If you want to apply a JOIN to a SELECT statement so that the related rows are loaded in the same result set, which form of relationship loading will you use?

  1. Lazyload()
  2. Joinedload()
  3. Subqueryload()

Answer: B) Joinedload()

Explanation:

Joinedload() is used when you want to apply a JOIN to a SELECT statement so that the related rows are loaded in the same result set.

48. ____ is the system SQLAlchemy uses to interconnect with various types of DBAPI implementations and databases.

  1. Dialect
  2. core
  3. ORM

Answer: A) Dialect

Explanation:

Dialect is the system that SQLAlchemy uses to interconnect with various types of DBAPI implementations and databases.

49. Which of the following dialects are included in the SQLAlchemy?

  1. PostgreSQL
  2. MySQL and MariaDB
  3. SQLite
  4. All of the above

Answer: D) All of the above

Explanation:

Following dialects are included in SQLAlchemy: Firebird, Microsoft SQL Server, MySQL, Oracle, PostgreSQL.

50. Which of the following is the default DBAPI that the MYSQL dialect uses?

  1. MySQL
  2. mysql-python
  3. Basic_MySQL
  4. Mysql_PY

Answer: B) mysql-python

Explanation:

mysql-python is the default DBAPI that MYSQL dialect uses.

51. Which language does SQLAlchemy use?

  1. Python
  2. C++
  3. C
  4. JAVA

Answer: A) Python

Explanation:

SQLAlchemy is based on python language.

52. When did SQLAlchemy come into existence?

  1. 14 Jan 2006
  2. 14 Feb 2006
  3. 14 Feb 2008
  4. 14 Feb 2010

Answer: B) 14 Feb 2006

Explanation:

SQLAlchemy was released on 14 Feb 2006.

MCQSQLAlchemy

You must login to add a comment.

Need An Account,