날아보자!

Index Architecture Types How many index architecture type classifications are there in MS SQL Server? => 2. 2 Indexes - 2 Which of the following statement is true about row locators in non-clustered indexes in MS SQL Server? => 3. If the table has a clustered index, or the index is on an indexed view, the row locator is the clustered index key for the row. Indexes - 3 Consider the following two ..

Relational Algebra - 3 Which is a join condition contains an equality operator? => 1. Equijoins Relational Algebra - 4 In precedence of set operators the expression is evaluated from: => 2. Left to right Database Query Languages Using which language can a user request information from a database ? => 1. Query Procedural Language Which one of the following is a procedural language ? => 3. Relatio..

Basics of Sets and Relations #1 A, B 합집합의 개수? {1,2,3,4,5,6,7,8} => 8 Basics of Sets and Relations #2 A, B 교집합의 개수? {2,3,4,5,6} => 5 Basics of Sets and Relations #3 A, B 차집합의 개수? {1} => 1 Basics of Sets and Relations #4 A x B 카테시안 곱으로 나올 수 있는 총 수는? 6 x 7 = 42 Basics of Sets and Relations #5 σ 는 표준편차라고 한다. σ(Number 2 select count(*) from Student where number < 3000; Basics of Sets and Relations #6..

Julia conducted a 15 days of learning SQL contest. The start date of the contest was March 01, 2016 and the end date was March 15, 2016. Write a query to print total number of unique hackers who made at least 1 submission each day (starting on the first day of the contest), and find the hacker_id and name of the hacker who made maximum number of submissions each day. If more than one such hacker..