Where is metadata stored in MySQL?

_________ can be applied to the metadata or to an active session and the metadata.

A

DROP EVENT SESSION

B

ALTER EVENT SESSION,STATE=STOP

C

ALTER EVENT SESSION,STATE=START

D

All of the mentioned

MySQL maintains metadata in the database meta_sql.

A

True

B

False

Consider the following statements: 1. Aadhaar metadata cannot be stored for more than three months. 2. State cannot enter into any contract with private corporations for sharing of Aadhaar data. 3. Aadhaar is mandatory for obtaining insurance products. 4. Aadhaar is mandatory for getting benefits funded out of the Consolidated Fund of India. Which of the statements given above is / are correct ?

A

1 and 4 only

B

2 and 4 only

C

3 only

D

1, 2 and 3 only

Relational schemas and other metadata about relations are stored in a structure called the ____________

A

Metadata

B

Catalog

C

Log

D

Data Dictionary

Metadata about the relations are stored in ________

A

File header

B

Data dictionary

C

Data query

D

Data analyser

What MySQL property is used to create a surrogate key in MySQL?

A

UNIQUE

B

SEQUENCE

C

AUTO_INCREMENT

D

None of the mentioned

Replication enables data from one MySQL database server to be copied to one or more MySQL database servers.

A

True

B

False

Replication does not enable data from one MySQL database server to be copied to one or more MySQL database servers.

A

True

B

False

What is the meaning of "EMPTY SET" in the following MySQL command?

SELECT fname, lname, person_idFROM personWHERE lname=’s’;/* after Execution*/ Mysql tool RETURN EMPTY SET 0:00sec

A

No values

B

Error

C

Access denied

D

None of the mentioned

What is 'tamp' in the following MySQL command?

mysql -h xyz.host.try.net -p -u tamp

A

user name

B

password

C

host name

D

table name

Where is metadata stored in MySQL?

Related Questions