You want to create a sales table with the following column specifications and data types:
SALESID: Number
STOREID: Number
ITEMID: Number
QTY: Number, should be set to 1 when no value is specified
SLSDATE: Date, should be set to current date when no value is specified
PAYMENT: Characters up to 30 characters, should be set to CASH when no value is specified
Which statement would create the table?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Explanation:
This answer is wrong!!!!
The option correct is B
SQL> CREATE TABLE TB_TEST(COD NUMBER, PAYMENT VARCHAR2(20) DEFAULT = “CASH”);
CREATE TABLE TB_TEST(COD NUMBER, PAYMENT VARCHAR2(20) DEFAULT = “CASH”)
*
ERRO na linha 1:
ORA-00936: expressÒo nÒo encontrada
SQL> CREATE TABLE TB_TEST(COD NUMBER, PAYMENT VARCHAR2(20) DEFAULT ‘CASH’);
Tabela criada.
The answer is wrong. Option B is the correct answer.
It’s B
This site is full of wrong answers. I think they do it intentionally so people fail and they can sell more of this bullshit.
@Leandro: You name it.
Selling certificates is just one more business case to Oracle… 😉
Usually posts some really exciting stuff like this. If you are new to this site.
It’s in reality a great and helpful piece of information. I’m happy that you simply shared this helpful information with us. Please stay us up to date like this. Thanks for sharing.|
This site really has all of the info I needed concerning this subject and didn’t know who to ask. |
http://thecraniofacialsurgeon.com
B is correct.