SQL* PLUS, SQL and PL/SQL

YOU CAN DOWNLOAD 200+ SUBJECTS PDF BOOK FOR COMPETITIVE EXAMINATIONS

CLICK HERE TO DOWNLOAD

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 '));

A
exam
B
exam
C
6
D
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

A
fixed server role sysadmin
B
Global admin role
C
Data base admin role
D
correctchoice Db backupoperator fixed role
Question 43 [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which field is the key field?

SQL* PLUS, SQL PL SQL MCQ
A
ID
B
Name
C
HighScore
D
Competition
Question 44 [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following can add a row to a table?

A
Add
B
Insert
C
Update
D
Alter
Question 45 [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
SQL Server Audit is the primary auditing tool in SQL Server

A
True
B
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
A sub query that defines a view cannot include the GROUP BY clause
B
A view is created with the sub query having the DISTINCT keyword can be updated
C
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
D
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?
A
Northwind
B
Master
C
Tempdb
D
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? SQL* PLUS, SQL PL SQL MCQ
A
>=18
B
<=18
C
=18
D
Greater or equal to 18
Question 49 [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
During which phase are foreign keys introduced?

A
Conceptual Design
B
Logical Design
C
Physical Design
Question 50 [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Online page restore is only supported in which SQL Server edition

A
AZURE SQL Server edition
B
AZURE Datawarehouse
C
AZURE BLOB STORAGE
D
SQL Server Enterprise edition
There are 50 questions to complete.