Machine-translated by Google. Questions are authored in English.
Top

Discussion

Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)

  • A.Create table Employee(EMPNO int, EMPNAME char(10));
  • B.Create table Employee(EMPNO integer, EMPNAME String(10))
  • C.Create table Emplo(EMPNO number, EMPNAME string);
  • D.Create table Emp(EMPNO int, EMPNAME char(10));

Answer: A

Correct answer: Create table Employee(EMPNO int, EMPNAME char(10));

A ten-character column is declared char(10); String is not an SQL type and a bare string has no length. The table must also be named as the question specifies, which rules out the options calling it Emplo or Emp.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.