Discussion
Home ‣ Database ‣ Introduction to SQL Comments
- Question
A view is which of the following?
Options- A. A virtual table that can be accessed via SQL commands
- B. A virtual table that cannot be accessed via SQL commands
- C. A base table that can be accessed via SQL commands
- D. A base table that cannot be accessed via SQL commands
- Correct Answer
- A virtual table that can be accessed via SQL commands
- 1. Using ODL, you can define which of the following?
Options- A. Attribute
- B. Structure
- C. Operation
- D. All of the above. Discuss
- 2. ODL supports which of the following types of association relationships?
Options- A. Unary
- B. Unary and Binary
- C. Unary and Binary and Ternary
- D. Unary and Binary and Ternary and higher Discuss
- 3. Which of the following is true concerning an ODBMS?
Options- A. They have the ability to store complex data types on the Web.
- B. They are overtaking RDBMS for all applications.
- C. They are most useful for traditional, two-dimensional database table applications.
- D. All of the above. Discuss
- 4. An extent is which of the following?
Options- A. A keyword that indicates that the subclass inherits from a superclass
- B. A keyword that indicates that the superclass inherits from a subclass
- C. The set of all instances of a class within a database
- D. Only one instance of a class within a database Discuss
- 5. Which of the following is true concerning the following statement: class Manager extends Employee
Options- A. Manager is a concrete class and a superclass.
- B. Manager is a concrete class and a subclass.
- C. Manager is an abstract class and a superclass.
- D. Manager is an abstract class and a subclass. Discuss
- 6. In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
Options- A. all columns of the table are to be returned.
- B. all records meeting the full criteria are to be returned.
- C. all records with even partial criteria met are to be returned.
- D. None of the above is correct. Discuss
- 7. The command to eliminate a table from a database is:
Options- A. REMOVE TABLE CUSTOMER;
- B. DROP TABLE CUSTOMER;
- C. DELETE TABLE CUSTOMER;
- D. UPDATE TABLE CUSTOMER; Discuss
- 8. A subquery in an SQL SELECT statement:
Options- A. can only be used with two tables.
- B. can always be duplicated by a join.
- C. has a distinct form that cannot be duplicated by a join.
- D. cannot have its results sorted using ORDER BY. Discuss
- 9. To define what columns should be displayed in an SQL SELECT statement:
Options- A. use FROM to name the source table(s) and list the columns to be shown after SELECT.
- B. use USING to name the source table(s) and list the columns to be shown after SELECT.
- C. use SELECT to name the source table(s) and list the columns to be shown after USING.
- D. use USING to name the source table(s) and list the columns to be shown after WHERE. Discuss
- 10. SQL query and modification commands make up a(n) ________ .
Options- A. DDL
- B. DML
- C. HTML
- D. XML Discuss
Introduction to SQL problems
Search Results
Correct Answer: All of the above.
Correct Answer: Unary and Binary
Correct Answer: They have the ability to store complex data types on the Web.
Correct Answer: The set of all instances of a class within a database
Correct Answer: Manager is a concrete class and a subclass.
Correct Answer: all columns of the table are to be returned.
Correct Answer: DROP TABLE CUSTOMER;
Correct Answer: has a distinct form that cannot be duplicated by a join.
Correct Answer: use FROM to name the source table(s) and list the columns to be shown after SELECT.
Correct Answer: DML
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.