Question 1

Given the following customer table:

Which of the following ORM snippets would return the ID, state, and country of all customers with the newest customers appearing first?

Options :

A :

B :

C :

D :

Answer: B

Question 2

A database administrator wants to create a database that does not have a predefined schema. Which of the following tools should the administrator use to create this type of database? (Choose two.)

Options :

A : PostgreSQL

B : MariaDB

C : MySQL

D : SQL Server

E : MongoDB

F : Cosmos

Answer: E,F

Question 3

A company is launching a proof-of-concept, cloud-based application. One of the requirements is to select a database engine that will allow administrators to perform quick and simple queries on unstructured data. Which of the following would be best suited for this task?

Options :

A : MongoDB

B : MS SQL

C : Oracle

D : Graph database

Answer: A

Question 4

Which of the following tools is used for natively running a Linux system in Windows?

Options :

A : WSL

B : Remote Desktop Protocol

C : SSH

D : Telnet

Answer: A

Question 5

A company needs information about the performance of users in the sales department. Which of the following commands should a database administrator use for this task?

Options :

A : DROP

B : UPDATE

C : DELETE

D : SELECT

Answer: D