A collection of interrelated records is called a a) Databaseb) Spreadsheetc) Management information systemd) Text filee) None of these In a database, related fields are grouped to a) Fileb) Bankc) Menud) Data recorde) None of these Which of the following refers to the level of data abstraction that describes exactly how the data actually stored? … Read more
A relational database consists of a collection ofa) Tablesb) Fieldsc) Recordsd) Keyse) none of these A __ in a table represents a relationship among a set of values.a) Columnb) Keyc) Rowd) Entrye) none of these b The term _ is used to refer to a row.a) Attributeb) Tuplec) Fieldd) Instancee) none of these The term … Read more
1-Which statement would add a column CGPA to a table Student which is already created? ALTER TABLE Student ADD COLUMN (CGPA NUMBER(3,1)); ALTER TABLE Student CGPA NUMBER(3,1); ALTER TABLE Student ADD (CGPA NUMBER(3,1)); ALTER TABLE Student ADD CGPA NUMBER(3,1); 2- Which statement is TRUE regarding ALTER statement? ALTER TABLE cannot be used to remove a … Read more
1. The EXISTS keyword will be true if: Any row in the subquery meets the condition only All rows in the subquery fail the condition only Both of these two conditions are met Neither of these two conditions is met Explanation: EXISTS keyword checks for existance of a condition. 2. How many tables may be … Read more
1. To eliminate duplicate rows in a query, the ________ qualifier is used in the SQL select command. A. ONLY B. UNIQUE C. DISTINCT D. SINGLE Answer: C 2. In the SQL language, the ________ statement is used to make table definitions. A. DQL B. DML C. DDL D. DCL Answer: C
