Sybase Quiz :: 2
10 Questions
| Attempts: 398
Sybase SQL , T-SQL Quiz
Questions and Answers
- 1.Which SQL command is used to extract data from tables?
- A.
EXTRACT
- B.
SELECT
- C.
FIND
- D.
None of above
- 2.Which SQL keyword is used to sort the result set?
- A.
ORDER
- B.
SORT
- C.
ORDER BY
- D.
SORT BY
- 3.The AND operator displays a record if ANY of the conditions listed are true.
- A.
True
- B.
False
- 4.Stored procedures can be execute on remote Adaptive Servers.
- A.
YES
- B.
NO
- 5.In Create stored procedure, the Parameter names can be a maximum of 30 bytes long, including the @ sign.
- A.
True
- B.
False
- 6.Which of the following command will be used for execute a Stored procedure? A) exec procedure_name B) execute procedure_name C) procedure_name
- A.
A and B
- B.
Only A
- C.
Only B
- D.
All A, B and C
- 7.Count(*) returns the total number of non-NULL values in the column.
- A.
True
- B.
False
- 8.Assume that today's is monday and today's date is 11 apr 2011. Result of the following query: select datename(dw,getdate())
- A.
11 apr 2011 monday
- B.
11 apr 2011
- C.
Monday
- D.
Error
- 9.Assume that today's is monday and today's date is 11 apr 2011. Result of the following query: select datepart(dw,getdate())
- A.
Monday
- B.
Apr
- C.
11
- D.
2
- 10.We can define primary key and foreign key on views.
- A.
True
- B.
False
Related Topics
Recent Quizzes
Featured Quizzes
Popular Topics
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
Back to top