Which of the following is true about the result of the following query? SELECT ID, NAME, EMAIL FROM CLIENT a. It has three rows of the CLIENT table. b. It has all rows with null ID, NAME, or EMAIL from the CLIENT table. c. It has three columns of the CLIENT table. d. It has all rows with non null ID, NAME, and EMAIL from the CLIENT table.

Which of the following is true about the result of the following query? SELECT ID, NAME, EMAIL FROM CLIENT a. It has three rows of the CLIENT table. b. It has all rows with null ID, NAME, or EMAIL from the CLIENT table. c. It has three columns of the CLIENT table. d. It has all rows with non null ID, NAME, and EMAIL from the CLIENT table.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter3: Table Creation And Management

Section: Chapter Questions

Problem 5MC: Which of the following is true? a. If you truncate a table, you cant add new data to the table. b....

See similar textbooks

Similar questions

Which of the following SELECT statements displays a list of customer names from the CUSTOMERS table? SELECT customer names FROM customers; SELECT “Names” FROM customers; SELECT firstname, lastname FROM customers; SELECT firstname, lastname, FROM customers; SELECT firstname, lastname, “Customer Names” FROM customers;
Which of the following symbols is used in a SELECT clause to display all columns from a table? / & * "
Which of the following commands drops any columns marked as unused from the SECUSTOMERORDERS table? DROP COLUMN FROM secustomerorders WHERE column_status = UNUSED ALTER TABLE secustomerorders DROP UNUSED COLUMNS; ALTER TABLE secustomerorders DROP (unused); DROP UNUSED COLUMNS;
Which of the following characters can be used in a table name? a. b. ( c. % d. !
Which of the following statements deletes all rows in the HOMEWORK10 table? a. DELETE FROM homework10; b. DELETE . FROM homework10; c. DELETE FROM homework10; d. DELETE FROM homework10 WHERE amid = ; e. Both c and d delete all rows in the HOMEWORK10 table.
Which of the following is not a valid statement? You can change the name of a table only if it doesn’t contain any data. You can change the length of a column that doesn’t contain any data. You can delete a column that doesn’t contain any data. You can add a column to a table.
Which of the following commands creates a new table containing two columns? CREATE TABLE newname (coll DATE, col2 VARCHAR2); CREATE TABLE newname AS (SELECT title, retail, cost FROM books); CREATE TABLE newname (col1, co12); CREATE TABLE newname (col1 DATE DEFAULT SYSDATE, co12 VARCHAR2 (1));
When must a comma be used in the SELECT clause of a query? a. when a field name is followed by a column alias b. to separate the SELECT clause and the FROM clause when only one field is selected c. Its never used in the SELECT clause. d. when listing more than one field name and the fields arent concatenated e. when an arithmetic expression is included in the SELECT clause
Which of the following is true? a. If you truncate a table, you cant add new data to the table. b. If you change the default value of an existing column, all existing rows containing a NULL value in the same column are set to the new DEFAULT value. c. If you delete a column from a table, you cant add a column to the table with the same name as the previously deleted column. d. If you add a column to an existing table, its always added as the last column of the table.
Which of the following queries is used to list a unique value for Emp_name, where the list will produce only a list of those values that are different from one another? Select different emp_name from Employee; Select only emp_name from Employee; Select distinct emp_name from Employee; Select unique emp_name from Employee;
Which of the following queries contains an equality join? (refer to the tables in the JustLee Books database.)a. SELECT title, authoridFROM books, bookauthorWHERE books.isbn ¼ bookauthor.isbnAND retail > 20;b. SELECT title, nameFROM books CROSS JOIN publisher;c. SELECT title, giftFROM books, promotionWHERE retail >¼ minretailAND retail <¼ maxretail;d. none of the above
Which of the following queries is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another? SELECT ONLY V_CODE FROM PRODUCT; SELECT UNIQUE V_CODE FROM PRODUCT; SELECT DIFFERENT V_CODE FROM PRODUCT; SELECT DISTINCT V_CODE FROM PRODUCT;

SEE MORE QUESTIONS

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

	a.	It has three rows of the CLIENT table.
	b.	It has all rows with null ID, NAME, or EMAIL from the CLIENT table.
	c.	It has three columns of the CLIENT table.
	d.	It has all rows with non null ID, NAME, and EMAIL from the CLIENT table.