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
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.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
