Q1. When creating a part of a data model (such as creating a table) in a databas

Question

Q1. When creating a part of a data model (such as creating a table) in a database, which category of SQL statement is used?

A. DML

B. DQL

C. DDL

D. DCL

Q2. In MySQL which of the following datatypes would allow 5.98 entered for a column?

A. INT

B. FLOAT(2,2)

C. DECIMAL(2,2)

D. DECIMAL(8,2)

E. FLOAT(8,0)

Q3. A "ONE-TO-ONE" relationship (optional or mandatory) can be enforced within the database by setting the Foreign Key to have which property?

A. UNIQUE

B. NOT NULL

C. ZERO FILLED

D. NULL

Q4. Which best describes a column with the CHAR(n) datatype in MySQL

A. The column stores strings of exactly "n" characters, right padded with spaces if needed, using a constant "n" bytes of disk storage to do so.

B. The column stores strings of length less than or equal to "n" characters using a constant "n" bytes of disk storage to do so.

C. The column stores strings of length less than or equal to "n" characters using a variable number of the bytes of disk storage to do so.

D. The column stores strings of exactly "n" characters, right padded with spaces if needed, using a variable number of the bytes of disk storage to do so.

Q5. When inserting data into a database, which category of SQL statement is used

A. DML

B. DQL

C. DDL

D. DCL

Explanation / Answer

1.Answer: C

The syntax is same as computer programming language to describe the data structures mainly database schemas.

2.Answer: D

3.Answer: A

4.Answer: C

5.Answer: A

Used to handle and insert the data in a dataabase using this DML SQL statement .They are not permanent for a database and capable to rollback.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.