Choose the correct syntax to insert rows into dim_country table
Which ones are correct, i kept on trying but test always shows wrong. Any ideas?
The 3rd one is correct. (I'm not sure about the 5th one, since that is not T-SQL (SQL Server) but some other rdbms.)
thanks for your answer but if I pick only third one and press submit it says incorrect.
The first one already checked looked correct. Add the 3rd one to that. And likely the one after the last one selected.
So, overall: 3rd, 6th and 8th would be my best guess.
Assuming this is PostGreSQL, then 5 is also a valid option, in addition to 3,6 and 8.
1, 2 and 4 are syntactically incorrect.
I don't know what to tell you, except to install a PostGreSQL instance and try them out. Or simply try every answer combination until you get the "correct" answer. I'm not a PostGres expert, other than the ones I mentioned being invalid syntax.
#3 is valid syntax and should work for the example DDL posted, and #6 is also valid, unless there's a problem with the date formats in the VALUES clause.
thanks for trying, I really appreciate it.
Is a SERIAL column actually the same as people think of an IDENTITY column? In other words, while you can't insert into a classic IDENTITY column without jumping through a hoop or two, can you insert into a SERIAL column without jumping through such a hoop?
The example they give at the intersection pages 158/159 in the documentation looks like this and they explain it with the alternative.
CREATE TABLE tablename ( colname SERIAL ); -- is equivalent to specifying: CREATE SEQUENCE tablename_colname_seq AS integer; CREATE TABLE tablename ( colname integer NOT NULL DEFAULT nextval('tablename_colname_seq') );
The alternative is a sequence and there's absolutely NOTHING to prevent you from inserting into a column that has a default of "nextval" for a sequence. Of course, you could have a UNIQUE constraint on the column to prevent you from entering DUPLICATE values but there's nothing to prevent you from entering a value with a DEFAULT of a sequence "nextval".
Since they're saying the two are identical, I'm thinking you can enter values into a column designated as a SERIAL.
I don't have Postgres to try it with, either.
soo, which answers do you think should correct?
I think we've given enough advice.
Have you tried any of these examples on a PostGreSQL instance? It's free to install and use. I've already made this suggestion.
We don't have the test in front of us, and I assume you're taking this test in order to get some certification. Actually using the product will teach you more about it that any test will.
Heh... you're the one that has to have Postgres loaded. And it looks like the "test" give you instant feedback. Spend a minute and try the bloody code!
I tried it and it seems indeed confusing as certain codes work but then i mark it test shows incorrect...
So... do what I would do... Contact the people that provide the test and ask them! Not all people that create tests and answers are actually correct.
To insert rows into the
dim_country table, you can use the following syntax:
- Inserting a single row:
INSERT INTO dim_country (column1, column2, column3) VALUES (value1, value2, value3);
column3 with the actual column names in the
dim_country table, and
value3 with the corresponding values you want to insert for each column.
- Inserting multiple rows in a single statement:
INSERT INTO dim_country (column1, column2, column3) VALUES (value1, value2, value3), (value4, value5, value6), (value7, value8, value9);
In this syntax, you can provide multiple sets of values separated by commas within the
VALUES clause. Each set corresponds to a row that will be inserted into the
Remember to replace
column3 with the actual column names, and
value3, etc., with the desired values for each row.
Ensure that the number of columns and the order of the values match the structure of the
Note: Make sure you have the necessary permissions to insert data into the