Advanced SQL Database Online Test

Which of the following is true concerning triggers?


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 ;


How many tables may be included with a join?


Which of the following is a correlated subquery?


Which of the following statements is true concerning subqueries?


A UNION query is which of the following?


Embedded SQL is which of the following?


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


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


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


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


A CASE SQL statement is which of the following?


Which of the following is true concerning a procedure?


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


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

















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

1777 days 8 hours 31 minutes ago

Arun

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

2130 days 2 hours 41 minutes ago

Bhavik Mehta

Nice test..

2836 days 15 hours 13 minutes ago

Sirgwaje

SO TECHNICAL

2864 days 22 hours 17 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