This Quiz contains totally 10 Questions each carry 1 point for you.
1. Which of the following is true regarding PostgreSQL?
PostgreSQL is object-relational database system
PostgreSQL is powerful
PostgreSQL is open source
All of the above
Correct!
Wrong!
2. PostgreSQL, originally called ?
Ingres
Postgres
Pregres
None of these
Correct!
Wrong!
3. Using psql, you can generate a complete list of commands by using the ________ command
help
/help
&help
$help
Correct!
Wrong!
4. Which syntax is used to Change the definition of a procedural language?
UPDATE LANGUAGE name RENAME TO new_name
ALTER LANGUAGE name RENAME TO new_name
UPDATE LANGUAGE name OWNER TO new_name
ALTER LANGUAGE name OWNER TO new_name
Correct!
Wrong!
5. The below command is used to?
ANALYZE [ VERBOSE ] [ table [ (column [, ...] ) ] ]
ANALYZE [ VERBOSE ] [ table [ (column [, ...] ) ] ]
Collect statistics about a database.
Start a transaction block.
End a transaction block.
Destroy statistics about a database.
Correct!
Wrong!
6. The ________ type stores a currency amount with a fixed fractional precision.
character
money
binary
numeric
Correct!
Wrong!
7. Geometric data types represent?
one dimensional
two dimensional
enum
boolean
Correct!
Wrong!
8. How many types of SQL bit there?
2
3
4
5
Correct!
Wrong!
9. A meta-command always begins with what?
Forwardslash character (/)
Dollar sign ($)
Backslash character ()
Question mark (?)
Correct!
Wrong!
10. We add data to PostgreSQL by using which statement?
insert
select
update
add
Correct!
Wrong!
Share the quiz to show your results !
Subscribe to see your results
Ignore & go to results
Cassandra-Quiz-9
You got %%score%% of %%total%% right
%%description%%
%%description%%
Loading...