You are now heading for the midterm exam and one of the topics you covered is advanced databases. How conversant are you with the new technologies involving databases and their use? Take up the quiz to ensure you do not fail that exam. All the best as you prepare for it.
AND
OR
NOT
NOT OR
Rate this question:
True
False
Rate this question:
True
False
Rate this question:
AND
OR
NOT
XOR
Rate this question:
The SELECT statement retrieves values from EMPLOYEES table whose salary is less than or equal to 3,000.
The SELECT statement retrieves the last name and salary from the EMPLOYEES table for any employee whose salary is less than or equal to 3,000.
The SELECT statement retrieves the EMPLOYEES table for any employee whose salary is less than or equal to 3,000.
The SELECT statement retrieves the last name and salary from the EMPLOYEES table for any employee whose salary is less than 3,000.
Rate this question:
True
False
Rate this question:
UPPER()
UPPERCASE()
UCASE()
UPCASE()
Rate this question:
It displays employee numbers, last names, salaries, and manager’s employee numbers for all the employees whose manager’s employee number is 100, 101, or 201
It displays all the employees whose manager’s employee number is 100, 101, or 201
It displays employee numbers, last names, salaries, and manager’s employee numbers for all the employees whose manager’s employee number is from 100 to 201
It displays employee numbers, last names, salaries, and manager’s employee numbers for all the employees whose manager’s employee number is btween 100 and 201
Rate this question:
True
False
Rate this question:
RPLACE()
REPLACE()
REMOVE()
SEARCH()
Rate this question:
The SELECT statement retrieves the information of all employees who are in department 90
The SELECT statement retrieves the employee ID, name, job ID, and department number of all employees who are in department 90
The SELECT statement retrieves the employee's ID who are in department 90
The SELECT statement retrieves the values from employees table with department 90
Rate this question:
MON-DD-RR
RR-DD-MON
DD-MON-RR
MM-DD-RR
Rate this question:
It displays the last name and job ID of all employees whose job ID is IT_PROG, ST_CLERK, or SA_REP.
It displays the last name and job ID of all employees whose job ID is not IT_PROG, ST_CLERK, or SA_REP.
It displays the last name and job ID of all employees whose job ID is not between IT_PROG, ST_CLERK, or SA_REP.
It displays the last name and job ID of all employees whose job ID is between IT_PROG, ST_CLERK, or SA_REP.
Rate this question:
SORT BY
ARRANGE
ORDER BY
ORDER IN
Rate this question:
TRACK()
TRACE()
TRIM()
HTRIM()
Rate this question:
Double quotation marks
Single quotation marks
Asterisks
AS keyword
Rate this question:
NULLS?
IS NULLS
ISNULL
IS NULL
Rate this question:
TRUNC()
ROUND()
ROFF()
ROUNDOFF()
Rate this question:
AS
LIKE
SAME
WHERE
Rate this question:
SELECT
WHERE
FROM
LIKE
Rate this question:
COMBINE()
CONCAT()
CONCATENATE()
CONC()
Rate this question:
Logical conditions
Comparison conditions
Arithmetic conditions
Weather conditions
Rate this question:
Uni-Row Functions
Single-Row Functions
One-Row Functions
Unique-Row Functions
Rate this question:
Format-sensitive, case-sensitive
Format-insensitive, case-insensitive
Case-sensitive, format-sensitive
Case-insensitive, format-insensitive
Rate this question:
%
_
*
#
Rate this question:
Commas
Hyphens
Parenthesis
Double qoutations
Rate this question:
Arithmetic operators
Concatenation operator
Comparison conditions
BETWEEN operator
Rate this question:
Methods
Functions
Procedures
Tasks
Rate this question:
True
False
Rate this question:
SIZE()
LENGTH()
LEN()
STRLEN()
Rate this question:
1
2
3
4
Rate this question:
/
\
*
#
Rate this question:
MOD()
MODULO()
MODULUS()
REMAINDER()
Rate this question:
MM-DD-RR
DD-MON-RR
RR-MON-DD
MON-DD-RR
Rate this question:
AS
IN
BETWEEN
LIKE
Rate this question:
%
_
*
#
Rate this question:
INST()
INSTR()
STRLEN
STRPOS()
Rate this question:
40000
####1
40##
4###
Rate this question:
!=
^=
*=
Rate this question:
LOWERCASE()
LCASE()
LOWER()
LOCASE()
Rate this question:
TRUNCATE()
TRUNC()
ROUND()
DROUND()
Rate this question:
Relational
Test
Arithmetic
Logical
Rate this question:
Multiple-Row Functions
Group Functions
Both a and b
None of these
Rate this question:
***2400***
*2*4*6*8*0
*****24000
24000*****
Rate this question:
INITCASE()
ICASE()
ICAP()
INITCAP()
Rate this question:
DUO
DUAL
DOUBLE
DUMMY
Rate this question:
SYSDATETIME
SYSTIME
SYSDATE
DATETIME
Rate this question:
Symbol
Character
String
Char
Rate this question:
Quiz Review Timeline (Updated): Mar 22, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Database Basic Knowledge Quiz! Trivia
Here we are with a database basics knowledge quiz. A database is a collection of data that makes it easy to access through a computer system. Databases are broken down into...
Questions:
10 |
Attempts:
1047 |
Last updated:
Mar 21, 2023
|
True / False Exercise -Database Concepts
This True\/False exercise delves into fundamental Database concepts, assessing understanding of object properties, DBMS efficiency, data sharing, query constraints, and uniqueness...
Questions:
5 |
Attempts:
1826 |
Last updated:
Mar 21, 2023
|
Multiple Choice Questions -Database Concepts
This quiz focuses on fundamental database concepts within relational models, including cardinality, schema, and data records, emphasizing data independence and management...
Questions:
15 |
Attempts:
1669 |
Last updated:
Mar 21, 2023
|
Unit 6 Introduction To Databases Part 1
Explore the basics of databases in 'Unit 6 Introduction to Databases Part 1'. This quiz covers data types, data warehouses, queries, database structures, and more, providing...
Questions:
15 |
Attempts:
735 |
Last updated:
Mar 21, 2023
|
Data And Databases Trivia Quiz!
Explore the world of databases with the Data and Databases Trivia Quiz! Test your knowledge on DBMS, metadata, and data structure management. Ideal for learners interested in...
Questions:
15 |
Attempts:
385 |
Last updated:
Mar 21, 2023
|
Database
This Database quiz evaluates understanding of SQL commands and their functionalities, focusing on query complexity, command syntax, and transaction control. It is ideal for...
Questions:
107 |
Attempts:
1253 |
Last updated:
Mar 21, 2023
|
Wait!
Here's an interesting quiz for you.