• databases Online Quiz - 3
Back
0

databases Online Quiz - 3

Description: databases Online Quiz - 3
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

We cannot decide if a server is a linked server by using sys.servers catalog view. True or False?

technology databases

  1. True

  2. False

Show answer
Correct Option: B

In the Table employee_Details there are two columns: Employee_Id-Integer[10] and Employee_Name-Char[10],The following select query Select distinct(Employee_Name) from employee_Details where Employee_Id='1232' fails due to:

technology databases

  1. The field mentioned in the where clause should be one of the columns selected

  2. The distinct function can not be used on a field of type Char

  3. The Integer value mentioned in the where clause should not be enclosed by quotes since it is of integer type.

  4. none of the above.

Show answer
Correct Option: C

The ORDER BY keyword sort the records in descending order by default.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

fill up:A LEFT JOIN Return all rows from the _________ table, even if there are no matches in the __________ table

technology databases

  1. left,right

  2. right,left

  3. left,left

  4. right,right

Show answer
Correct Option: A

AI Explanation

To answer this question, you need to understand the concept of a LEFT JOIN in SQL.

A LEFT JOIN returns all rows from the left table, even if there are no matches in the right table.

Let's go through each option to understand why it is correct or incorrect:

Option A) left, right - This option is correct because a LEFT JOIN returns all rows from the left table, even if there are no matches in the right table. Option B) right, left - This option is incorrect because a RIGHT JOIN returns all rows from the right table, even if there are no matches in the left table. Option C) left, left - This option is incorrect because a LEFT JOIN returns all rows from the left table, even if there are no matches in the right table. Option D) right, right - This option is incorrect because a RIGHT JOIN returns all rows from the right table, even if there are no matches in the left table.

The correct answer is Option A) left, right. This option is correct because a LEFT JOIN returns all rows from the left table, even if there are no matches in the right table.

Fill Up: The UNION operator selects only distinct values by default. To allow duplicate values, use __________

technology databases

  1. UNION ENTIRE

  2. FULL UNION

  3. UNION ALL

  4. none of the above

Show answer
Correct Option: C

The following query fails. Select employee_name,employee_id,count() from employee_Details group by employee_id where count()>2; The right format is:

technology databases

  1. Select employee_name,count() from employee_Details group by employee_id where count()>2;

  2. Select employee_name,employee_id,count() from employee_Details group by employee_id having count()>2;

  3. Select employee_name,employee_id,count() from employee_Details order by employee_id where count()>2;

  4. NONE of THE ABOVE

Show answer
Correct Option: B

Select * from employee_Details with ur; in the follwoing query UR stands for:

technology databases

  1. Under Read

  2. neither a,c or d

  3. Uncommitted Read

  4. Uncommitted Ride

Show answer
Correct Option: C

An application program containing query with UR

technology databases

  1. can read data that has been changed and committed.

  2. can read data that has been changed but is not yet committed.

  3. both a and b

  4. neither a or b

Show answer
Correct Option: C

Select the right syntax to delete all the rows from the table employee_Details but retain the table :

technology databases

  1. delete * from employee_Details

  2. delete from employee_Details

  3. truncate table employee_Details

  4. drop table employee_Details

Show answer
Correct Option: B,C

What command(s) you have to execute to know the processes running inside SQL server.

technology databases

  1. Sp_helpdb

  2. sp_helpprocess

  3. sp_who2

  4. select * from sys.sysprocesses

Show answer
Correct Option: C,D

On which port does SQL server runs.

technology databases

  1. 1433

  2. 1434

  3. 1432

  4. 1435

Show answer
Correct Option: A

AI Explanation

To answer this question, we need to understand the default port on which SQL Server runs.

Option A) 1433 - This option is correct. SQL Server typically runs on port 1433 by default. This port is used for the default instance of SQL Server.

Option B) 1434 - This option is incorrect. Port 1434 is used for the SQL Server Browser service, which helps clients locate named instances of SQL Server on a network. It is not the default port for SQL Server itself.

Option C) 1432 - This option is incorrect. Port 1432 is not the default port for SQL Server.

Option D) 1435 - This option is incorrect. Port 1435 is not the default port for SQL Server.

The correct answer is option A) 1433. This option is correct because it represents the default port on which SQL Server runs.

Wchich recovery model should database be in for database mirroring to be configured on it

technology databases

  1. Bulk logged

  2. Half

  3. Full

  4. Simple

Show answer
Correct Option: C

What are the modes of authentication in SQL server database.

technology databases

  1. Builtin/Administrator

  2. Windows authentication

  3. Mixed mode

  4. SQL authentication

Show answer
Correct Option: B,C

What is process to truncate a transaction log in SQL server

technology databases

  1. Fire truncate command

  2. Backup the transaction log

  3. Backup the database

  4. Logs cannot be truncated in SQL Server

Show answer
Correct Option: B

Mark all the indexes which are their in SQL server

technology databases

  1. Bit Map

  2. clustered

  3. Non clustered

  4. filter

  5. covering

  6. Composite

Show answer
Correct Option: B,C,D,E,F

How many types of system database are therand which database stores information about jobs running on the SQL server

technology databases

  1. 4,Model

  2. 4,MSDB

  3. 5,MSDB

  4. 5,Master

Show answer
Correct Option: C

Waht is page size and Extent size in SQL server

technology databases

  1. 8,64 MB

  2. 8,64 KB

  3. 16,64 KB

  4. 10,86 MB

Show answer
Correct Option: B

What is view in sql server database

technology databases

  1. Logical form of table

  2. Physical view of table

  3. Logical view of table

  4. View are thoes which are created on Stored procedure

Show answer
Correct Option: C

What are HA Options in SQL server 2005 database.

technology databases

  1. Data Guard

  2. Clustering

  3. Mirroring

  4. Transaction log shipping

  5. RAC

Show answer
Correct Option: B,C,D

Which edition of SQL server supports Asynchronous mirroring.

technology databases

  1. Workgroup

  2. Express

  3. Standard

  4. Enterprise

Show answer
Correct Option: D
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
962 Quizzes
19148 Questions
 history
1132 Quizzes
13047 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions