Advanced SQL - General Questions Online Exam Quiz
Advanced SQL - General Questions GK Quiz. Question and Answers related to Advanced SQL - General Questions. MCQ (Multiple Choice Questions with answers about Advanced SQL - General Questions
What type of join is needed when you wish to include rows that do not have matching values?
Options
A : Equi-join
B : Natural join
C : Outer join
D : All of the above.
What type of join is needed when you wish to return rows that do have matching values?
Options
A : Equi-join
B : Natural join
C : Outer join
D : All of the above.
Which of the following is true concerning a procedure?
Options
A : You do not create them with SQL.
B : They do not need to have a unique name.
C : They include procedural and SQL statements.
D : They are the same thing as a function.
A CASE SQL statement is which of the following?
Options
A : A way to establish an IF-THEN-ELSE in SQL.
B : A way to establish a loop in SQL.
C : A way to establish a data definition in SQL.
D : All of the above.
Which of the following statements is true concerning routines and triggers?
Options
A : Both consist of procedural code.
B : Both have to be called to operate.
C : Both run automatically.
D : Both are stored in the database.
Which of the following is one of the basic approaches for joining tables?
Options
A : Subqueries
B : Union Join
C : Natural join
D : All of the above
Which of the following is true concerning systems information in an RDBMS?
Options
A : RDBMS store database definition information in system-created tables.
B : This information can be accessed using SQL.
C : This information often cannot be updated by a user.
D : All of the above.
The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID
Options
A : Equi-join
B : Natural join
C : Outer join
D : Cartesian join
Embedded SQL is which of the following?
Options
A : Hard-coded SQL statements in a program language such as Java.
B : The process of making an application capable of generating specific SQL code on the fly.
C : Hard-coded SQL statements in a procedure.
D : Hard-coded SQL statements in a trigger.
A UNION query is which of the following?
Options
A : Combines the output from no more than two queries and must include the same number of columns.
B : Combines the output from no more than two queries and does not include the same number of columns.
C : Combines the output from multiple queries and must include the same number of columns.
D : Combines the output from multiple queries and does not include the same number of columns.
Advanced SQL - General Questions more Online Exam Quiz
Namespaces - General Questions
Polymorphism - General Questions
Properties - General Questions
Structures - General Questions
Data and Database Administration - General Questions
Database Design Using Normalization - General Questions
Database Processing for BIS - General Questions