Design

Which of the following is a document-oriented NoSQL database?

A

MongoDB

B

Apache HBase

C

Apache Cassandra

D

Amazon DynamoDB

Answer

A

Design

Which of the following is the data modeling technique based on the Entity Relationship Diagram(ER diagram) that integrates information and data?

A

IDEF3

B

IDEF1X

C

IDEF1

D

IDEF0

Answer

B

Management

Which of the following options specifies the location of the configuration file when starting a MySQL database from the command line?

A

Read-file

B

Verbose-file

C

Include-file

D

Defaults-file

Answer

D

Management

What is the default port number of a MySQL database server?

A

3306

B

3011

C

3006

D

3106

Answer

A

SQL

Which of the following functions is used in Oracle to return the second argument if the first argument is a NULL value and returns the first argument if the first argument is not a NULL value?

A

NVL2

B

NULLIF

C

NVL

D

COALESCE

Answer

C

SQL

Which of the following keywords is used to eliminate duplicated data?

A

MERGE

B

DISTINCT

C

JOIN

D

UNION

Answer

B