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.
Class
Social Security Number
GPA
Major
Rate this question:
To specify the syntax and semantics of SQL data definition language
To specify the syntax and semantics of SQL manipulation language
To define the data structures
All of the above.
Rate this question:
SORT BY
ALIGN BY
GROUP BY
ORDER BY
Rate this question:
ADD
CREATE
INSERT
MAKE
Rate this question:
Outer join
Inner join
Equi-join
Natural join
Rate this question:
Difficult to update
Lack of data independence
Data redundancy
program dependence
All of above
Rate this question:
spreadsheet program
word processor program
graphics program
All of the above
Rate this question:
fields
Records
Database
sectors
Rate this question:
Primary key access
Access via unique index
Table access by ROWID
Full table scan
Rate this question:
Data bank
Data base
Data file
data record
Rate this question:
Hierarchical schema
Network schema
Relational schema
All of the above
Rate this question:
INSTR
SUBSTRING
SUBSTR
POS
Rate this question:
Elimination of data redundancy
Ability of associate deleted data
Increased security
Program/data independence
All of the above
Rate this question:
A programming language.
A data sublanguage.
An operating system.
A DBMS.
Rate this question:
Each user can "see" only a small part of the entire database
Each subschema contains every field in the logical schema
each user can access every subschema
Rate this question:
High level language
SQL
Query Language
4GL
Rate this question:
Column
1966_Invoices
Catch_#22
#Invoices
None of the above
Rate this question:
Sort
Look-up
all of above
Rate this question:
Can not hide sensitive information from users
keeps its logical structure hidden from users
Keeps its physical structure hidden from users
Both b and c
Rate this question:
Quiz Review Timeline (Updated): Aug 7, 2024 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.