SQL Technology Quiz: Can You Solve?
SQL is the standard and acceptable language for storing, manipulating and retrieving data in databases. This technology helps the specialists in undertaking their work. How good are you with different SQL concepts? Find out below.
Questions and Answers
- 1.
You can add a row using SQL in a database with which of the following?
- A.
ADD
- B.
CREATE
- C.
INSERT
- D.
MAKE
Correct Answer
C. INSERTExplanation
In SQL, the INSERT statement is used to add a new row or multiple rows into a table in a database. It allows you to specify the values for each column in the new row or use a SELECT statement to insert data from another table. The ADD, CREATE, and MAKE keywords are not used to add a new row in SQL.Rate this question:
-
- 2.
The command to remove rows from a table 'CUSTOMER' is:
- A.
REMOVE FROM CUSTOMER ...
- B.
DROP FROM CUSTOMER ...
- C.
DELETE FROM CUSTOMER WHERE ...
- D.
UPDATE FROM CUSTOMER ...
Correct Answer
C. DELETE FROM CUSTOMER WHERE ...Explanation
The correct answer is "DELETE FROM CUSTOMER WHERE ...". This is the correct command to remove rows from a table in SQL. The "DELETE" statement is used to delete rows from a table, and the "WHERE" clause is used to specify the condition for which rows should be deleted.Rate this question:
-
- 3.
Which of the following is the original purpose of SQL?
- A.
To specify the syntax and semantics of SQL data definition language
- B.
To specify the syntax and semantics of SQL manipulation language
- C.
To define the data structures
- D.
All of the above.
Correct Answer
D. All of the above.Explanation
The original purpose of SQL is to encompass all the options mentioned in the given choices. It was designed to specify the syntax and semantics of both the SQL data definition language and the SQL manipulation language. Additionally, it is used to define the data structures in a database. Therefore, the correct answer is "All of the above."Rate this question:
-
- 4.
Which one of the following sorts rows in SQL?
- A.
SORT BY
- B.
ALIGN BY
- C.
GROUP BY
- D.
ORDER BY
Correct Answer
D. ORDER BYExplanation
ORDER BY is used in SQL to sort the rows of a result set in ascending or descending order based on one or more columns. It is commonly used to organize the data in a meaningful way for analysis or presentation purposes. The other options, SORT BY, ALIGN BY, and GROUP BY, are not valid SQL sorting clauses.Rate this question:
-
- 5.
SQL is:
- A.
A programming language.
- B.
A data sublanguage.
- C.
An operating system.
- D.
A DBMS.
Correct Answer
B. A data sublanguage.Explanation
SQL stands for Structured Query Language and is primarily used for managing and manipulating relational databases. It is not a standalone programming language but rather a specialized sublanguage that is used within programming languages to interact with databases. SQL allows users to define, manipulate, and retrieve data from databases using various commands and statements. Therefore, the correct answer is that SQL is a data sublanguage.Rate this question:
-
- 6.
What type of join is needed when you wish to include rows that do not have matching values?
- A.
Outer join
- B.
Inner join
- C.
Equi-join
- D.
Natural join
Correct Answer
A. Outer joinExplanation
An outer join is needed when you wish to include rows that do not have matching values. Unlike an inner join, which only includes rows with matching values, an outer join includes all rows from one table and the matching rows from the other table. This means that even if there is no matching value in the other table, the row will still be included in the result set.Rate this question:
-
- 7.
Which Oracle access method is the fastest way for Oracle to retrieve a single row?
- A.
Primary key access
- B.
Access via unique index
- C.
Table access by ROWID
- D.
Full table scan
Correct Answer
A. Primary key accessExplanation
Primary key access is the fastest way for Oracle to retrieve a single row because the primary key is a unique identifier for each row in a table. This means that Oracle can directly access the specific row using the primary key value, without having to search through an index or perform a full table scan. This method provides the most efficient and direct access to the desired row, resulting in faster retrieval times.Rate this question:
-
- 8.
Which of the following can be a valid column name?
- A.
Column
- B.
1966_Invoices
- C.
Catch_#22
- D.
#Invoices
- E.
None of the above
Correct Answer
C. Catch_#22Explanation
The column name "Catch_#22" can be a valid column name because it follows the rules for column names in databases. Column names can contain letters, numbers, and underscores, but they cannot start with a number or contain special characters like "#" or spaces. Therefore, "Catch_#22" is a valid column name.Rate this question:
-
- 9.
Which character function can be used to return a specified portion of a character string?
- A.
INSTR
- B.
SUBSTRING
- C.
SUBSTR
- D.
POS
Correct Answer
C. SUBSTRExplanation
The SUBSTR function can be used to return a specified portion of a character string. This function allows you to extract a substring from a larger string by specifying the starting position and the length of the desired substring. It is commonly used in SQL queries to manipulate and extract data from character fields.Rate this question:
-
- 10.
The highest level in the hierarchy of data organization is called
- A.
Data bank
- B.
Data base
- C.
Data file
- D.
data record
Correct Answer
B. Data baseExplanation
The highest level in the hierarchy of data organization is called a database. A database is a collection of organized and structured data that is stored and accessed electronically. It is designed to efficiently manage and manipulate large amounts of data, allowing for easy storage, retrieval, and analysis. A database provides a centralized and integrated approach to data management, making it the highest level in the hierarchy of data organization.Rate this question:
-
- 11.
A top-to-bottom relationship among the items in a database is established by a
- A.
Hierarchical schema
- B.
Network schema
- C.
Relational schema
- D.
All of the above
Correct Answer
A. Hierarchical schemaExplanation
A hierarchical schema establishes a top-to-bottom relationship among the items in a database. This means that the data is organized in a tree-like structure, where each item has a parent and can have multiple children. This type of schema is commonly used in systems such as file systems, where there is a clear hierarchy of folders and files. In contrast, a network schema allows for more complex relationships between items, and a relational schema organizes data into tables with relationships established through keys. Therefore, the correct answer is hierarchical schema.Rate this question:
-
- 12.
Which of the following is a problem of file management system?
- A.
Difficult to update
- B.
Lack of data independence
- C.
Data redundancy
- D.
program dependence
- E.
All of above
Correct Answer
E. All of aboveExplanation
The file management system has multiple problems. It is difficult to update files because it requires manual intervention and can be time-consuming. There is also a lack of data independence, meaning that changes made to the structure of the file can affect the programs that use it. Data redundancy is another issue, where the same data is stored in multiple files, leading to wastage of storage space. Lastly, there is program dependence, where programs are written specifically to work with certain file formats, limiting flexibility. Therefore, all of the mentioned options are problems of the file management system.Rate this question:
-
- 13.
Information can be transferred between the DBMS and a
- A.
spreadsheet program
- B.
word processor program
- C.
graphics program
- D.
All of the above
Correct Answer
D. All of the aboveExplanation
The correct answer is "all of the above" because a DBMS (Database Management System) can transfer information to and from spreadsheet programs, word processor programs, and graphics programs. This means that data can be imported from these programs into the DBMS for storage and analysis, and data can also be exported from the DBMS to these programs for further manipulation and presentation. Therefore, all of these programs can be used to exchange information with a DBMS.Rate this question:
-
- 14.
In a large DBMS
- A.
Each user can "see" only a small part of the entire database
- B.
Each subschema contains every field in the logical schema
- C.
each user can access every subschema
Correct Answer
A. Each user can "see" only a small part of the entire databaseExplanation
In a large DBMS, each user can "see" only a small part of the entire database. This is because the database is often divided into multiple subschemas, and each user is assigned access to a specific subschema. This ensures that users only have access to the data that is relevant to their needs or permissions, while also maintaining data security and privacy. By limiting the visibility of the database to each user, it allows for better control and management of the data within the system.Rate this question:
-
- 15.
Primitive operations common to all record management system include
- A.
Print
- B.
Sort
- C.
Look-up
- D.
all of above
Correct Answer
C. Look-upExplanation
The correct answer is "look-up" because all record management systems commonly involve the operation of looking up specific records or information within the system. This operation allows users to search for and retrieve specific data based on certain criteria, such as searching for a particular record by its unique identifier or searching for records that meet specific conditions.Rate this question:
-
- 16.
What is the language used by most of the DBMSs for helping their users to access data?
- A.
High level language
- B.
SQL
- C.
Query Language
- D.
4GL
Correct Answer
C. Query LanguageExplanation
Most of the DBMSs use a query language to help their users access data. Query Language allows users to retrieve, manipulate, and manage data stored in the database. It provides a standardized way to interact with the database and perform operations such as querying, inserting, updating, and deleting data. SQL (Structured Query Language) is one of the most commonly used query languages in DBMSs. It is a high-level language specifically designed for managing relational databases.Rate this question:
-
- 17.
Which of the following fields in a student file can be used as a primary key
- A.
Class
- B.
Social Security Number
- C.
GPA
- D.
Major
Correct Answer
B. Social Security NumberExplanation
The Social Security Number can be used as a primary key in a student file because it uniquely identifies each student. Primary keys are used to ensure that each record in a database table is unique, and the Social Security Number meets this requirement as it is assigned to each individual and does not repeat. The other fields such as class, GPA, and major may not be unique for each student, as multiple students can have the same class, GPA, or major. Therefore, the Social Security Number is the most suitable field to be used as a primary key in a student file.Rate this question:
-
- 18.
Which of the following is not an advantage of the database approach
- A.
Elimination of data redundancy
- B.
Ability of associate deleted data
- C.
Increased security
- D.
Program/data independence
- E.
All of the above
Correct Answer
E. All of the aboveExplanation
The correct answer is "all of the above". This means that all of the given options - elimination of data redundancy, ability to associate deleted data, increased security, and program/data independence - are not advantages of the database approach. In other words, the database approach does not provide these benefits.Rate this question:
-
- 19.
A transparent DBMS
- A.
Can not hide sensitive information from users
- B.
keeps its logical structure hidden from users
- C.
Keeps its physical structure hidden from users
- D.
Both b and c
Correct Answer
C. Keeps its physical structure hidden from usersExplanation
A transparent DBMS keeps its physical structure hidden from users. This means that users are not aware of how the data is stored or organized within the database. They only interact with the database through a logical structure, such as tables and queries, without needing to understand the underlying physical implementation. This allows for easier use and management of the database system, as users do not need to have knowledge of the internal workings of the system.Rate this question:
-
- 20.
Large collection of files are called
- A.
fields
- B.
Records
- C.
Database
- D.
sectors
Correct Answer
C. DatabaseExplanation
A large collection of files is called a database. A database is a structured set of data that is organized and stored in a way that allows for efficient retrieval, management, and manipulation of the data. It typically consists of multiple files or tables that are related to each other in some way. Databases are commonly used in various applications and industries to store and manage large amounts of information.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 15, 2023Quiz Edited by
ProProfs Editorial Team -
Nov 02, 2011Quiz Created by
NithyaUthaman
Back to top