MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 9 Mcqs, each offering curated multiple-choice questions to sharpen your Technical MCQs knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
We add data to PostgreSQL by using which statement? |
| A. | Insert |
| B. | Add |
| C. | Select |
| D. | Update |
| E. | |
| Answer» B. Add | |
| 2. |
A meta-command always begins with what? |
| A. | Forwardslash character (/) |
| B. | Dollar sign ($) |
| C. | Backslash character () |
| D. | Question mark (?) |
| Answer» D. Question mark (?) | |
| 3. |
How many types of SQL bit there? |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» B. 3 | |
| 4. |
Geometric data types represent? |
| A. | one dimensional |
| B. | boolean |
| C. | enum |
| D. | two dimensional |
| Answer» E. | |
| 5. |
ANALYZE [ VERBOSE ] [ table [ (column [, ...] ) ] ]6.The ________ type stores a currency amount with a fixed fractional precision. |
| A. | character |
| B. | money |
| C. | binary |
| D. | numeric |
| Answer» C. binary | |
| 6. |
Which syntax is used to Change the definition of a procedural language? |
| A. | UPDATE LANGUAGE name RENAME TO new_name |
| B. | ALTER LANGUAGE name RENAME TO new_name |
| C. | ALTER LANGUAGE name OWNER TO new_name |
| D. | UPDATE LANGUAGE name OWNER TO new_name |
| Answer» C. ALTER LANGUAGE name OWNER TO new_name | |
| 7. |
Using psql, you can generate a complete list of commands by using the ________ command |
| A. | help |
| B. | /help |
| C. | $help |
| D. | &help |
| Answer» B. /help | |
| 8. |
PostgreSQL, originally called ? |
| A. | Ingres |
| B. | Postgres |
| C. | Pregres |
| D. | None of the above |
| Answer» C. Pregres | |
| 9. |
Which of the following is true regarding PostgreSQL? |
| A. | PostgreSQL is a powerful |
| B. | PostgreSQL is open source |
| C. | PostgreSQL is object-relational database system |
| D. | All of the above |
| Answer» E. | |