YOU CAN DOWNLOAD 200+ SUBJECTS PDF BOOK FOR COMPETITIVE EXAMINATIONS
SQL* PLUS, SQL and PL/SQL
Question 41 [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER] |
What will be the output of following query:
Select length(trim(' exam '));
exam | |
exam | |
6 | |
4 |
Question 42 [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER] |
To perform a backup, you must be a member of one of the following roles. Choose three
fixed server role sysadmin | |
Global admin role | |
Data base admin role | |
correctchoice Db backupoperator fixed role |
Question 43 [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER] |
Which field is the key field?
ID | |
Name | |
HighScore | |
Competition |
Question 44 [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER] |
Which of the following can add a row to a table?
Add | |
Insert | |
Update | |
Alter |
Question 45 [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER] |
SQL Server Audit is the primary auditing tool in SQL Server
True | |
False |
Question 46 [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER] |
Which of the following statements are true regarding views? (Select all that apply)
A sub query that defines a view cannot include the GROUP BY clause | |
A view is created with the sub query having the DISTINCT keyword can be updated | |
A Data Manipulation Language (DML) operation can be performed on a view that is created with the sub query having all the NOT NULL columns of a table | |
correctchoice A view that is created with the sub query having the pseudo column ROWNUM keyword cannot be updated |
Question 47 [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER] |
Which of the following holds temporary data?
Northwind | |
Master | |
Tempdb | |
Msdb |
Question 48 [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER] |
What criteria would you use in the field Age to find all the people aged 18 or below?
>=18 | |
<=18 | |
=18 | |
Greater or equal to 18 |
Question 49 [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER] |
During which phase are foreign keys introduced?
Conceptual Design | |
Logical Design | |
Physical Design |
Question 50 [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER] |
Online page restore is only supported in which SQL Server edition
AZURE SQL Server edition | |
AZURE Datawarehouse | |
AZURE BLOB STORAGE | |
SQL Server Enterprise edition |
There are 50 questions to complete.