Tag: databases

Questions Related to databases

Which part of the following function definition will generate an error?CREATE FUNCTION dbo.Tomorrow ()RETURNS DATETIMEASBEGIN DECLARE @TodaysDate DATETIME SET @TodaysDate = GETDATE() SET @TodaysDate = DATEADD(DD, DATEDIFF(DD, 0, @TodaysDate), 0) RETURN DATEADD(DD, 1, @TodaysDate)ENDGO
technology databases

  1. SET @TodaysDate = GETDATE()

  2. SET @TodaysDate = DATEADD(DD, DATEDIFF(DD, 0, @TodaysDate), 0)

  3. RETURN DATEADD(DD, 1, @TodaysDate)

  4. No error is generated. The function will be created.

Show answer
Correct Option: A

What is a candidate key?
technology databases

  1. Used to uniquely identify a row

  2. Alias for primary key

  3. Used to identify a column

  4. Alias for foreign key

Show answer
Correct Option: A

Can I call a trigger directly called from an application?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

A view is nothing but a ________ table or a stored query
technology databases

  1. Dymanic

  2. Real

  3. Virtual

  4. Static

Show answer
Correct Option: C
Explanation:

To solve this question, the user needs to know about views in database management systems. A view is a virtual table that does not store any data but only displays data from one or more tables in the database.

Based on this information, the correct answer is:

The Answer is: C. Virtual

How can we get the number of records or rows in a table?

technology databases

  1. Using COUNT

  2. Using NUM

  3. Using NUMBER

  4. Both a and c above

Show answer
Correct Option: A

An outer join requires each record in the two joined tables to have a matching record.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

How do I find out all databases starting with ‘test to which I have access to?
technology databases

  1. SHOW DATABASES LIKE ‘%tech%’;

  2. SHOW DATABASES LIKE ‘%tech;

  3. SHOW DATABASES LIKE ‘'tech'%’;

  4. SHOW DATABASES LIKE ‘tech%’;

Show answer
Correct Option: D

Can I define multiple unique constraints on a table?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

When do we use a HAVING clause?
technology databases

  1. To limit the output of a query

  2. To limit the output of a query using an aggregate function only

  3. When GROUP by is used

  4. both b and c above

Show answer
Correct Option: B

USE keyword is used to select a ___________ .
technology databases

  1. Table

  2. Column

  3. Database

  4. All the above

Show answer
Correct Option: C