introduction-to-sql database question and answers -Page 5

CuriousTab

CuriousTab

C Programming C# Programming C++ Programming Database Java Programming Networking

Biochemical Engineering Biochemistry Biotechnology Chemical Engineering Civil Engineering Computer Science Digital Electronics Electrical Engineering Electronics Electronics and Communication Engineering Mechanical Engineering Microbiology Technical Drawing

Current Affairs General Knowledge

Data Interpretation Logical Reasoning Non Verbal Reasoning Verbal Ability Verbal Reasoning

AIEEE Bank Exams CAT GATE IIT JEE TOEFL

Analyst Bank PO Database Administrator IT Trainer Network Engineer Project Manager Software Architect

Introduction to SQL problems

1. The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."
Options
A. True
B. False

Correct Answer: False

2. Indexes can usually be created for both primary and secondary keys.
Options
A. True
B. False

Correct Answer: True

3. Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.
Options
A. True
B. False

Correct Answer: False

4. Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.
Options
A. True
B. False

Correct Answer: False

5. DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.
Options
A. True
B. False

Correct Answer: False

6. SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.
Options
A. True
B. False

Correct Answer: False

7. The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.
Options
A. True
B. False

Correct Answer: False

8. The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.
Options
A. True
B. False

Correct Answer: True

9. There is an equivalent join expression that can be substituted for all subquery expressions.
Options
A. True
B. False

Correct Answer: False

10. The ADD command is used to enter one row of data or to add multiple rows as a result of a query.
Options
A. True
B. False

Correct Answer: False

First 2 3 4 5 6 7

More in Database:

Advanced SQL Data and Database Administration Data Modeling with ER Model Data Models into Database Designs Data Warehousing Database Design Using Normalization Database Processing for BIS Database Redesign Distributed Databases ER Model and Business Rules Introduction to Database Introduction to SQL JDBC, Java Server Pages, and MySQL Logical Database Design Managing Databases with Oracle Managing Multiuser Databases Modeling Data in the Organization Object-Oriented Data Modeling Object-Oriented Database ODBC, OLE DB, ADO, and ASP Physical Database Design SQL for Database Construction SQL Server 2000 The Client-Server Database The Database Development Process The Database Environment The Internet Database Environment The Relational Model and Normalization XML and ADO.NET

Aptitude

Time and Distance
Volume and Surface Area
Problem on Trains
Permutation and Combination

Engineering

Civil Engineering
Computer Science
Mechanical Engineering
Technical Drawing

Programming

C Programming
C# Programming
C++ Programming
Java Programming

Reasoning

Logical Reasoning
Non Verbal Reasoning
Verbal Ability
Verbal Reasoning

Links

About Us
Contact Us
Privacy Policy
Sitemap

Social

Copyright �CuriousTab. All rights reserved.