DDL statements not used for Synonym is __________

________ dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re-create the database.

A

Archival

B

Fuzzy

C

SQL

D

All of the mentioned

The HCatalog __________ supports all Hive DDL that does not require MapReduce to execute.

A

Powershell

B

CLI

C

CMD

D

All of the mentioned

Which of the following statements are not a part of Data Definition Language (DDL)?

A

CREATE

B

ALTER

C

DROP

D

GRANT

Two statements are given, followed by three conclusions numbered I, II and III. Assuming the statements to be true, even if they seem to be at variance with commonly known facts, decide which of the conclusions logically follow(s) from the statements. Statements: All statements are answers. Some statements are questions. Conclusions: I. No question is a statement. II. Some answers are statements. III. Some questions are statements.

A

Only conclusions I and III follow

B

Only conclusions II and III follow

C

Only conclusions I and II follow

D

Either conclusion I or III follows

DDL triggers can be applied to __________ statement.

A

CREATE

B

UPDATE

C

DELETE

D

INSERT

You can use the handy event name of __________ to make sure your trigger covers all DDL events.

A

DDL_DATABASE_EVENTS

B

DDL_DATABASE_LEVEL_EVENTS

C

DDL_DATABASE_LEVEL

D

All of the mentioned

DDL Trigger can capture the information about the EVENT that fired it by using __________ function.

A

EVENTDATA()

B

EVENT()

C

EVENTS()

D

None of the mentioned

Which of the following is/are the DDL statements?

A

Create

B

Drop

C

Alter

D

All of the Mentioned

Which of the following is not a DDL command?

A

UPDATE

B

TRUNCATE

C

ALTER

D

None of the Mentioned

Which of the following information does an SQL DDL not specify?

A

The schema for each relation

B

The integrity constraints

C

The operations on the tuples

D

The security and authorization information for each relation

DDL statements not used for Synonym is __________

Related Questions