[Solved] Following Command Allows Create File Logtxt Contain Results Sql Queries Submitted Oracle D Q37246645

Which of the following command allows to create the file Log.txt which will contain the results of the SQL queries submitted in Oracle database Select one: O a CREATE FILE Log.txt 。b. NEW FILE Log.txt O c. SPOOL Log.tot O d CREATE Log. bt The table CUSTOMER has an attribute CUSTOMER_CITY of type VARCHAR2(10). Which of the following statement will have incorrect input Select one: O a INSERT INTO CUSTOMER (CustomeriD, Customer_City) VALUES (002, ‘LA 05) O b. INSERT INTO CUSTOMER (CustomerID, Customer City) VALUES (004, 94132) O c. INSERT INTO CUSTOMER (CustomeriD, Customer_ City) VALUES (003, San Francisco’) O d. INSERT INTO CUSTOMER (CustomeriD, Customer_City) VALUES (001, Miami) Which of the following command allows to execute the sql script named: TableCreate.txt Select one: O a. START TableCreate.tt O b. TableCreate.brt O c. START TableCreate O d. OPEN TableCreate Which of the following allows for a correct date comparison? Assume that StartDate is an attribute of type DATE Select one O a WHERE StartDate date(25-Dec-17) O b. WHERE StartDate< 25-Dec-17 O c. WHERE StartDate”25-Dec-17 O d. WHERE StartDateto_ date(’25-Dec-17) CASCADE CONSTRAINTS can be used with the DROP TABLE statement to avoid deletion errors due to referential integrity constraints Select one: O True O False Show transcribed image text Which of the following command allows to create the file Log.txt which will contain the results of the SQL queries submitted in Oracle database Select one: O a CREATE FILE Log.txt 。b. NEW FILE Log.txt O c. SPOOL Log.tot O d CREATE Log. bt The table CUSTOMER has an attribute CUSTOMER_CITY of type VARCHAR2(10). Which of the following statement will have incorrect input Select one: O a INSERT INTO CUSTOMER (CustomeriD, Customer_City) VALUES (002, ‘LA 05) O b. INSERT INTO CUSTOMER (CustomerID, Customer City) VALUES (004, 94132) O c. INSERT INTO CUSTOMER (CustomeriD, Customer_ City) VALUES (003, San Francisco’) O d. INSERT INTO CUSTOMER (CustomeriD, Customer_City) VALUES (001, Miami) Which of the following command allows to execute the sql script named: TableCreate.txt Select one: O a. START TableCreate.tt O b. TableCreate.brt O c. START TableCreate O d. OPEN TableCreate
Which of the following allows for a correct date comparison? Assume that StartDate is an attribute of type DATE Select one O a WHERE StartDate date(25-Dec-17) O b. WHERE StartDate

Expert Answer

---

Answer to Which of the following command allows to create the file Log.txt which will contain the results of the SQL queries submi… . . .