Which of the following is the correct definition of alias in SQL statement? a. It specifies the table containing the columns listed in the SELECT clause b. It retrieves information from the database c. It is a way of renaming a column heading in the output d. It is a value that is unavailable, unassigned, unknown, or inapplicable

Which of the following is the correct definition of alias in SQL statement? a. It specifies the table containing the columns listed in the SELECT clause b. It retrieves information from the database c. It is a way of renaming a column heading in the output d. It is a value that is unavailable, unassigned, unknown, or inapplicable

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter5: Data Manipulation And Transaction Control

Section: Chapter Questions

Problem 11MC

See similar textbooks

Similar questions

Which of the following is a correct statement?a. A commit is issued implicitly when a user exits SQL Developer or SQL*Plus.b. A commit is issued implicitly when a DDL command is executed.c. A commit is issued automatically when a DML command is executed.d. All of the above are correct.e. Both a and b are correct.f. Both a and c are correct
Which of the following SQL statements changes the size of the Title column in the BOOKS table from the current length of 30 characters to the length of 35 characters? (refer to the tables in the JustLee Books database)a. ALTER TABLE books CHANGE title VARCHAR(35);b. ALTER TABLE books MODIFY (title VARCHAR2(35));c. ALTER TABLE books MODIFY title (VARCHAR2(35));d. ALTER TABLE books MODIFY (title VARCHAR2(+5))
I am trying to create this index in oracle, the table and the column exists and is not found anywhere else in the database, but it's still telling me 'Province' is an invalid identifier. I've tried changing the column name (and create statement with it), but its all just not working. CREATE INDEX StudentProvince ON ADDRESS_KR (Province);
Which SQL statement key word can be used to delete a record within a table?a. DELETEb. DROPc. REMOVEd. CLEAR
Which of the following functions can be used to substitute a value for a NULL value? (refer to the tables in the JustLee Books database.)a. NVLb. TRUNCc. NVL2d. SUBSTRe. both a and df. both a and c
138. Evaluate the following SQL statements in the given order.Which statement is true regarding the above FLASHBACK operation?DROP TABLE dept; CREATE TABLE dept (deptno NUMBER(3) PRIMARY KEY, deptname VARCHAR2(10)); DROP TABLE dept; FLASHBACK TABLE dept TO BEFORE DROP; a. It recovers only the first DEPT table b. It recovers only the second DEPT table c. It does not recover any of the tables because FLASHBACK is not possible in this case d. It recovers both the tables but the names would be changed to the ones assigned in the RECYCLEBIN View Answer Report Discuss Too Difficult!
Which command of the followings doesn't belong to SQL DDL? Create Commit Alter Drop
Which of the following SQL statements is invalid and returns an error message? ( refer to the tables in the JustLee Books database). a. ALTER TABLE books ADD CONSTRAINT books_pubid_uk UNIQUE (pubid); b. ALTER TABLE books ADD CONSTRAINT books_pubid_pk PRIMARY KEY (pubid); c. ALTER TABLE books ADD CONSTRAINT books_pubid_nn NOT NULL (pubid); d. ALTER TABLE books ADD CONSTRAINT books_pubid_fk FOREIGN KEY (pubid) REFERENCES publisher (pubid); e. All of the above statements are invalid
Which of the following types of restrictions can be viewed with the DESCRIBE command? ( refer to the tables in the JustLee Books database). a. NOT NULL b. FOREIGN KEY c. UNIQUE d. CHECK
In advanced SQL, which of the following is a SQL query that performs execution of outer query for once in a row similar to looping? Choose an answer A Attribute list Subqueries B HAVING Subqueries C FROM Subqueries D Correlated Subqueries
use oracle sql command line with found or notfound method --- with table Customer(customerNo,costomerName ,gender) Employee (employeeNo,employeeName,job) ,branch(No,Name), category(catNo,catogeryName) ___ 4) Create database package pointOfSal which contain the following A. procedure to add new customer which use validation method checkExistingCustomer using cursor to validate customer name if its not exists before, then add this new customer and generate the customer number automatically using database trigger. B. Method to add new Employee which use validation method checkExistingEmployee using cursor to validate Employee name if its not exists before, then add this Employee and generate the Employee number automatically using database trigger. C. procedure to add new Category which use validation method checkExistingCategory using exception to validate category name if its not exists before, then add this category and generate the category number automatically using database…
Give an overview of the SQLiteOpenHelper and SQLiteCursor classes, including how these classes are used in CRUD operations, if at all possible.