• databases Online Quiz - 216
Back
0

databases Online Quiz - 216

Description: databases Online Quiz - 216
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

technology databases

  1. True

  2. False

Show answer
Correct Option: B

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

technology databases

  1. SELECT * FROM Persons SORT BY 'FirstName' DESC

  2. SELECT * FROM Persons SORT 'FirstName' DESC

  3. SELECT * FROM Persons ORDER BY FirstName DESC

  4. SELECT * FROM Persons ORDER FirstName DESC

Show answer
Correct Option: C

Which SQL statement is used to extract data from a database?
technology databases

  1. OPEN

  2. EXTRACT

  3. SELECT

  4. GET

Show answer
Correct Option: C

Which SQL statement is used to update data in a database?
technology databases

  1. UPDATE

  2. MODIFY

  3. SAVE

  4. SAVE AS

Show answer
Correct Option: A

Which SQL statement is used to insert new data in a database?

technology databases

  1. ADD NEW

  2. INSERT INTO

  3. ADD RECORD

  4. INSERT NEW

Show answer
Correct Option: B

What does SQL stand for?

technology databases

  1. Strong Question Language

  2. Structured Query Language

  3. Structured Question Language

  4. Strong Query Language

Show answer
Correct Option: B

With SQL, how do you select all the columns from a table named "Persons"?
technology databases

  1. SELECT * FROM Persons

  2. SELECT [all] FROM Persons

  3. SELECT Persons

  4. SELECT FROM Persons

Show answer
Correct Option: A

Which SQL statement is used to return only different values?

technology databases

  1. SELECT DIFFERENT

  2. SELECT UNIQUE

  3. SELECT DISTINCT

  4. SELECT EXACT

Show answer
Correct Option: C

AI Explanation

To answer this question, you need to understand how to retrieve only distinct values from a table using SQL queries. Let's go through each option to understand why it is correct or incorrect:

Option A) SELECT DIFFERENT - This option is incorrect because there is no SQL keyword or function called "DIFFERENT" to retrieve only different values.

Option B) SELECT UNIQUE - This option is incorrect because "UNIQUE" is not used as a keyword or function to retrieve only different values. Instead, "UNIQUE" is used to enforce uniqueness on a column or a combination of columns in a table.

Option C) SELECT DISTINCT - This option is correct because the "DISTINCT" keyword is used in SQL to retrieve only different values from a column or a combination of columns in a table. It eliminates duplicate values and returns only unique values.

Option D) SELECT EXACT - This option is incorrect because there is no SQL keyword or function called "EXACT" to retrieve only different values.

The correct answer is Option C) SELECT DISTINCT. This option is correct because the "DISTINCT" keyword is used to return only different values.

With SQL, how can you insert a new record into the "Persons" table?

technology databases

  1. INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

  2. INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

  3. INSERT ('Jimmy', 'Jackson') INTO Persons

  4. INSERT VALUES ('Jimmy', 'Jackson')

Show answer
Correct Option: A

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
technology databases

  1. INSERT INTO Persons (LastName) VALUES ('Olsen')

  2. INSERT ('Olsen') INTO Persons (LastName)

  3. INSERT INTO Persons ('Olsen') INTO LastName

  4. INSERT INTO Persons ('Olsen')

Show answer
Correct Option: A

With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
technology databases

  1. DELETE ROW FirstName='Peter' FROM Persons

  2. DELETE FROM Persons WHERE FirstName = 'Peter'

  3. DELETE FirstName='Peter' FROM Persons

  4. REMOVE FROM Persons WHERE FirstName = 'Peter'

Show answer
Correct Option: B

Which SQL statement is used to delete data from a database?

technology databases

  1. DELETE

  2. COLLAPSE

  3. REMOVE

  4. ERASE

Show answer
Correct Option: A

With SQL, how do you select a column named "FirstName" from a table named "Persons"?
technology databases

  1. EXTRACT FirstName FROM Persons

  2. SELECT FirstName FROM Persons

  3. SELECT Persons.FirstName

  4. SELECT * FROM Persons

Show answer
Correct Option: B

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
technology databases

  1. SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

  2. SELECT FirstName='Peter', LastName='Jackson' FROM Persons

  3. SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

  4. SELECT * FROM Persons WHERE FirstName='Jackson' AND LastName='Peter'

Show answer
Correct Option: A

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

technology databases

  1. SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName

  2. SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

  3. SELECT LastName>'Hansen' AND LastName

  4. SELECT LastName<>'Hansen' AND LastName<>'Pettersen' FROM Persons

Show answer
Correct Option: B
Explanation:

To solve this question, the user needs to know the syntax for the SELECT statement in SQL and how to use the WHERE clause to filter records based on a specific condition. The user must also understand the BETWEEN operator in SQL that is used to select values within a range.

Now, let's go through each option and explain why it is right or wrong:

A. SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName'Hansen' AND LastName'Hansen' AND LastName<>'Pettersen' FROM Persons This option is incorrect. The query selects all the records except the records with the last name "Hansen" and "Pettersen" from the "Persons" table, which is not what we want. We need to select records with last name between (and including) "Hansen" and "Pettersen".

The Answer is: B

Which SQL statement defines a FOREIGN KEY constraint on the DEPT NO column of the EMP table?
technology databases

  1. CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);

  2. CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));

  3. CRETE TABLE EM (empno NUMBER(4), ename VARCHAR2(35) deptno NUMBER (7,2) NOT NULL, CONSTRAINT em_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));

  4. CREATE TABLE EMP (empno NUMBER (4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));

Show answer
Correct Option: B
Explanation:

To understand this question, the user needs to know how to define foreign key constraints in SQL. A foreign key is a column or combination of columns that is used to establish a link between the data in two tables. The FOREIGN KEY constraint is used to prevent actions that would destroy links between tables.

Let's go through each option and explain why it is right or wrong:

A. CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);

This option is incorrect because it has a syntax error. The FOREIGN KEY constraint is not properly defined. It is missing parentheses around the column name, and the table name should be followed by the column name in parentheses.

B. CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));

This option is correct. It defines a FOREIGN KEY constraint called emp_deptno_fk on the deptno column of the EMP table. The constraint references the DEPTNO column of the DEPT table.

C. CRETE TABLE EM (empno NUMBER(4), ename VARCHAR2(35) deptno NUMBER (7,2) NOT NULL, CONSTRAINT em_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));

This option is incorrect because it has a syntax error. The table name is misspelled, and the FOREIGN KEY constraint is not properly defined. It should be defined before the REFERENCES keyword.

D. CREATE TABLE EMP (empno NUMBER (4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));

This option is incorrect because it has a syntax error. The FOREIGN KEY constraint is not properly defined. It is missing parentheses around the column name, and the table name should be followed by the column name in parentheses.

Therefore, the correct answer is:

The Answer is: B

Evaluate the set of SQL statements: CREATE TABLE dept (deptbi NUMBER (2) dname VARCHAR2(14), Ioc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?

technology databases

  1. The DESCRIBE DEPT statement displays the structure of the DEPT table

  2. The ROLLBACK statement frees the storage space occupied by the DEPT table.

  3. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist

  4. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.

Show answer
Correct Option: A

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) The DESCRIBE DEPT statement displays the structure of the DEPT table - This option is correct. The DESCRIBE statement in SQL is used to display the structure of a table. In this case, the DESCRIBE DEPT statement will display the structure of the DEPT table.

Option B) The ROLLBACK statement frees the storage space occupied by the DEPT table - This option is incorrect. The ROLLBACK statement in SQL is used to undo the changes made in a transaction. It does not directly free the storage space occupied by a table.

Option C) The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist - This option is incorrect. Since the DEPT table is created using the CREATE TABLE statement, the DESCRIBE DEPT statement will not return an error and will display the structure of the DEPT table.

Option D) The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement - This option is incorrect. The DESCRIBE statement can be used to display the structure of a table regardless of whether there is a COMMIT or ROLLBACK statement introduced.

The correct answer is A) The DESCRIBE DEPT statement displays the structure of the DEPT table. This option is correct because the DESCRIBE statement is used to display the structure of a table, and in this case, it will display the structure of the DEPT table.

Which two are attributes of /SQL* Plus? (Choose two).
technology databases

  1. /SQL * Plus commands cannot be abbreviated

  2. /SQL* Plus commands are accessed from a browser.

  3. /SQL*Plus commands are used to manipulate data in tables

  4. /SQL* Plus command manipulate table definitions in the database

  5. /SQL* Plus is the Oracle proprietary interface for executing SQL statements.

Show answer
Correct Option: C,E

Is the database and DBMS software together is called as Database system?

technology databases

  1. True

  2. False

Show answer
Correct Option: A

which of the following are the advantages of DBMS? (Select 2)

technology databases

  1. Redundancy is controlled

  2. graphical and statistical capabilities

  3. proprietary formats may limit arichival quality of data

  4. Providing multiple user interfaces

Show answer
Correct Option: A,D
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
961 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions