Halaman

Wednesday, August 7, 2019

Answer Sections 1 Quiz Database Programming with SQL 2019 Learner - English


Sections 1

The _______ clause can be added to a SELECT statement to return a subset of the data.                                                                   
                                               
                WHICH

                                               
                WHERE (*)


                                               
                ANYWHERE

                                               
                EVERY

                                                                               
All computers in the world speak the same languages, so you only need to learn one programming language - Oracle SQL. True or False?     
                                               
                True

                                               
                False (*)

                                                                               
You cannot use computers unless you completely understand exactly how they work. True or False?                                                 
                                               
                True

                                               
                False (*)

                                                                               
What command can be used to create a new row in a table in the database?   
                                               
                INSERT (*)

                                               
                ADD

                                               
                NEW

                                               
                CREATE

                                                                               
There is only one kind of software used by all computers. True or False?      
                                               
                True

                                               
                False (*)

What is a NULL value?                     
                                               
                An unknown value (*)

                                               
                A perfect zero

                                               
                A known value less than zero

                                               
                A blank space

                                                                               
In which clause of a SELECT statement would you specify the name of the table or tables being queried?                                                       
                                               
                The FROM clause (*)

                                               
                The SELECT clause

                                               
                The WHERE clause

                                               
                Any of the above options; you can list tables wherever you want in a SELECT statement.

                                                                               
Evaluate this SELECT statement:
SELECT (salary * raise_percent) raise
FROM employees;

If the RAISE_PERCENT column only contains null values, what will the statement return?
                                                               
                                               
                A null value or a numeric value depending on the value of the SALARY column

                                               
                A null value or a zero depending on the value of the SALARY column

                                               
                Only zeroes

                                               
                Only null values (*)

                                                                               
In a SELECT clause, what is the result of 2 + 3 * 2?            

                                               
                8 (*)

                                               
                10

                                               
                13

                                               
                6

                                                                               
You want to create a list of all albums that have been produced by the company. The list should include the title of the album, the artist's name, and the date the album was released. The ALBUMS table includes the following columns:
ALB_TITLE VARCHAR2(150) NOT NULL
ALB_ARTIST VARCHAR2(150) NOT NULL
ALB_DATE DATE NOT NULL

Which statement can you use to retrieve the necessary information?
                                                          
                                               
                SELECT alb_title; alb_artist; alb_date
FROM albums;

                                               
                SELECT *
FROM albums;
(*)


                                               
                SELECT alb_title, alb_artist, alb_dates
FROM albums;

                                               
                SELECT alb_title, alb_artist, alb_dates
FROM album;

The basic storage structure in a Relational Database is a _________:     

                                               
                Table (*)

                                               
                Row

                                               
                Key

                                               
                Field

                                                                               
Columns in a database table contain data with the same _________:    
                                               
                Type (*)

                                               
                Row

                                               
                Field

                                               
                Key

                                                                               
Every row in a relational database table is unique.           
                                               
                True (*)

                                               
                False

                                                                               
A Relational Database generally contains two or more tables. True or False?    
                                               
                True (*)

                                               
                False

                                                                               
In the real world, databases used by businesses generally have a single table . True or False?                                                                                 
                                               
                True

                                               
                False (*)

No comments:

Post a Comment

Final Exam Java Programming 2019 Learner - English

Final Exam