Question 1 To view the column names and data types of the LOCATION table you wou

Question

Question 1 To view the column names and data types of the LOCATION table you would type DESCRIBE LOCATION; at the SQL*Plus prompt. True False 2 points Question 2 Client/server databases create a lot of network traffic because the entire database is sent between the client and server for every request. True False 2 points Question 3 The same Sequences can use for different fields in different tables. True False 2 points Question 4 The VARCHAR2 data types stores trailing spaces True False 2 points Question 5 A one-to-many relationship (1:M) is the most common relationship for database design. True False 2 points Question 6 What is the default format for a DATE value? a. MM/DD/YY b. DD-MON-YY c. MM/DD/YYYY d. MON-DD-YYYY 2 points Question 7 The query INSERT INTO student ____ (‘abc’, ‘123’); inserts a new row into the student table. a. DATA b. COLS c. ROWS d. VALUES 2 points Question 8 Which of the following is not part of a DDL command? a. create table ... b. drop table ... c. create constraint ... d. select table_name from ... 2 points Question 9 The ____ command is used to run a script. a. begin b. open c. Start d. Newscript 2 points Question 10 A table is in 2NF if it fulfills these two conditions: it is in 1NF, and it has ____ dependencies. a. no partial b. no total c. all partial d.

Explanation / Answer

Question 1 To view the column names and data types of the LOCATION table you would type DESCRIBE LOCATION; at the SQL*Plus prompt

Ans: True. DESCRIBE command gives the structure of table.

Question 2 Client/server databases create a lot of network traffic because the entire database is sent between the client and server for every request

Ans: False.

Question 3 The same Sequences can use for different fields in different tables

Ans: True

Question 4 The VARCHAR2 data types stores trailing spaces

Ans: TRue. The main advantage of using VARCHAR2 is that it avoids memory wastage.

Question 5 A one-to-many relationship (1:M) is the most common relationship for database design.

Ans: True.

Question 6 What is the default format for a DATE value

Ans: d. MON-DD-YYYY

Question 7 The query INSERT INTO student ____ (‘abc’, ‘123’); inserts a new row into the student table.

Ans: d. VALUES. syntax if insert is: insert into table name values();

Question 8 Which of the following is not part of a DDL command?

Ans: d. select table_name from. Select is dml statement.

Question 9 The ____ command is used to run a script.

Ans: a. begin

Question 10 A table is in 2NF if it fulfills these two conditions: it is in 1NF, and it has ____

Ans: a. no partial

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

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