Advanced SQL Database Online Test

What type of join is needed when you wish to include rows that do not have matching values?


What type of join is needed when you wish to return rows that do have matching values?


Which of the following is true concerning a procedure?


A CASE SQL statement is which of the following?


Which of the following statements is true concerning routines and triggers?


Which of the following is one of the basic approaches for joining tables?


Which of the following is true concerning systems information in an RDBMS?


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


Embedded SQL is which of the following?


A UNION query is which of the following?


Which of the following statements is true concerning subqueries?


Which of the following is a correlated subquery?


How many tables may be included with a join?


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 ;


Which of the following is true concerning triggers?

















Description:

Also check out these courses on WizIQ: Hadoop and Big Data Certified Online Training Course Comprehensive Introduction to SQL SQL (pron.: /ˈɛs kjuː ˈɛl/ "S-Q-L";[3] or Structured Query Language) is a special-purpose programming language designed for managing data in relational database management systems (RDBMS).
Originally based upon relational algebra and tuple relational calculus, its scope includes data insert, query, update and delete, schema creation and modification, and data access control.
SQL was one of the first commercial languages for Edgar F. Codd's relational model, as described in his influential 1970 paper, "A Relational Model of Data for Large Shared Data Banks".[4] Despite not adhering to the relational model as described by Codd, it became the most widely used database language.[5][6] Although SQL is often described as, and to a great extent is, a declarative language (4GL), it also includes procedural elements. SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standards (ISO) in 1987. Since then, the standard has been enhanced several times with added features. However, issues of SQL code portability between major RDBMS products still exist due to lack of full compliance with the standard, and proprietary vendor extensions which lead to vendor lock-in, partly due to the large size and incomplete specification of the standard.

Discussion

Supurna

I have doubt for Q.12.
In case of correlated query, the values from outer query should be passed to the inner query as input.
Correct me if I am wrong

1658 days 18 hours 18 minutes ago

Arun

I doubt if the answer to question 2 is correct :/

2011 days 12 hours 28 minutes ago

Bhavik Mehta

Nice test..

2718 days 1 hours 1 minutes ago

Sirgwaje

SO TECHNICAL

2746 days 8 hours 5 minutes ago

Mushtaq Naik
Sr. System Administration (Windows Servers)
User
52 Followers

Your Facebook Friends on WizIQ

More Tests By Author

Basics of Networking Part 2
10 Questions | 1140 Attempts

Windows Server 2008 R2, Server Virtualization (Hyper-v)
7 Questions | 1122 Attempts

Windows Server 2008 Active Directory Configuring
15 Questions | 4627 Attempts