AMCAT Database Important Questions 2 | AMCAT Preparation

AMCAT DETAILS is here again with latest important questions on the topic of Database Management System for Computer Section in AMCAT exam. We hope you will be helpful from these questions and score well in your AMCAT exam.

ALL THE BEST!

Question: What will be the output of the following SQL query? 
SELECT Name, Age FROM tbl_student WHERE Age NOT BETWEEN 12 AND 15; 

Option (a) Displays only NULL values. 

Option (b) Does not display NULL values. 

Option (c) May display NULL values. 

Option (d) Error in the query.

---

Answer: (b) 

Question: Which of the following queries can be used to find out the rows containing the data about the candidates who took the entrance test more than two years ago?

 
Option (a) SELECT * FROM Candidates WHERE dateOfTest<GETDATE(); 

Option (b) SELECT * FROM Candidates WHERE                        dateOfTest<DATEADD(yy,-2,GETDATE()); 

Option (c) SELECT * FROM Candidates WHERE dateOfTest<DATEDIFF(yy,-2,GETDATE());

 
Option (d) SELECT * FROM Candidates WHERE dateOfTest>(yy,-2,GETDATE());

---

Answer: (b)

Question: Which of the following queries provide the correct syntax to create a vertical view for customer table? 

customer(cust_name,cust_id,location,order_date,order_price) 

Option (a)CREATE VIEW cust As SELECT * FROM customer WHERE cust_name='John';

 
Option (b) CREATE VIEW cust As SELECT cust_name,cust_id FROM customer; 

Option (c) CREATE VERTICALVIEW cust As SELECT * FROM customer WHERE cust_name='John';

 
Option (d) CREATE VERTICALVIEW cust As SELECT cust_name,cust_id FROM customer;

Answer: (b)

************************************************************

For elitmus preparation log onto https://amcatdetails.blogspot.in

**********************************************************