Midterm Examination

What does ORM stand for in the context of Prisma?

• Object-Resource Management

• Object-Relational Model

• Online Resource Management

• Object-Relational Mapping

What is the primary purpose of Prisma ORM?

• To simplify database access and management.

• To create complex user interfaces.

• To enhance database security features.

• To provide real-time data analytics.

How do you initialize a new Prisma project?

• Type 'prisma create' in the command line.

• Run 'npx prisma init' in your terminal.

• Run 'npm start' in your terminal.

• Execute the 'prisma new' command.

What command is used to create a new migration in Prisma?

• prisma migrate dev

• prisma deploy

• prisma migrate create

• prisma generate

What is the role of the `schema.prisma` file?

• The `schema.prisma` file defines the data model and database schema for a Prisma application.

• The `schema.prisma` file manages application routing.

• The `schema.prisma` file stores user authentication details.

• The `schema.prisma` file is used for front-end UI design.

How can you define relationships between models in Prisma?

• Relationships in Prisma are defined using fields with the @relation attribute.

• Relationships are defined using the @link attribute.

• You can define relationships by creating separate model files.

• Relationships are established through direct SQL queries.

What is a one-to-many relationship in data modeling?

• A one-to-many relationship is when multiple records in a table can relate to a single record in another table.

• A one-to-many relationship is a data model where records in two tables are unrelated.

• A one-to-many relationship means that each record in a table can only relate to one record in another table.

• A one-to-many relationship is a data model where one record in a table can be related to multiple records in another table.

How do you perform a basic read operation using Prisma Client?

• const users = await prisma.user.findMany();

• const users = await prisma.user.getMany();

• const users = prisma.user.findAll();

• const users = prisma.user.fetchAll();

What is the purpose of the `prisma migrate dev` command?

• To create and apply database migrations during development.

• To generate a new database schema from scratch.

• To delete existing database migrations.

• To optimize database performance during production.

What is the difference between `findUnique` and `findFirst` in Prisma?

• `findUnique` and `findFirst` are interchangeable methods.

• `findUnique` retrieves a single record by unique identifier, while `findFirst` retrieves the first record matching specified criteria.

• `findUnique` retrieves multiple records at once.

• `findFirst` requires a unique identifier to function.