0

databases Online Quiz - 13

Description: databases Online Quiz - 13
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

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

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

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

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

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


Correct Option: A

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

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

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

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

  4. INSERT FROM Persons ('Olsen') INTO LastName


Correct Option: B

AI Explanation

To insert "Olsen" as the "LastName" in the "Persons" table using SQL, you can use the following syntax:

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

Explanation: Option A: INSERT ('Olsen') INTO Persons (LastName) - This is an incorrect syntax. The correct syntax for the INSERT statement requires the keyword "INTO" before the table name, followed by the column names in parentheses, and the keyword "VALUES" before the values to be inserted.

Option B: INSERT INTO Persons (LastName) VALUES ('Olsen') - This is the correct syntax. It specifies the table "Persons" and the column "LastName" where the value 'Olsen' will be inserted.

Option C: INSERT INTO Persons ('Olsen') INTO LastName - This is an incorrect syntax. The correct syntax for the INSERT statement requires the keyword "VALUES" before the values to be inserted.

Option D: INSERT FROM Persons ('Olsen') INTO LastName - This is an incorrect syntax. The correct syntax for the INSERT statement does not include the keyword "FROM" before the table name, and the column name should be specified before the keyword "VALUES".

Therefore, the correct answer is B. INSERT INTO Persons (LastName) VALUES ('Olsen').

  1. UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

  2. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

  3. MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

  4. MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'


Correct Option: B
  1. DELETE FROM Persons WHERE FirstName = 'Peter'

  2. DELETE FirstName='Peter' FROM Persons

  3. DELETE ROW FirstName='Peter' FROM Persons

  4. DELETE FROM Persons WHERE FirstName <> 'Peter'


Correct Option: A

With SQL, how can you return the number of records in the "Persons" table?

  1. SELECT COUNT() FROM Persons

  2. SELECT COLUMNS() FROM Persons

  3. SELECT COLUMNS(*) FROM Persons

  4. SELECT COUNT(*) FROM Persons


Correct Option: D

AI Explanation

To return the number of records in the "Persons" table using SQL, you can use the COUNT(*) function.

Let's go through each option to understand why it is correct or incorrect:

Option A) SELECT COUNT() FROM Persons - This option is incorrect because the COUNT() function requires an argument. The argument specifies the column or expression to count. Without the argument, the function will produce an error.

Option B) SELECT COLUMNS() FROM Persons - This option is incorrect because there is no COLUMNS() function in SQL. To select all columns from a table, you can use the * wildcard.

Option C) SELECT COLUMNS(*) FROM Persons - This option is incorrect because there is no COLUMNS() function in SQL. To select all columns from a table, you can use the * wildcard.

Option D) SELECT COUNT() FROM Persons - This option is correct because it uses the COUNT() function to count all records in the "Persons" table. The COUNT(*) function returns the number of rows in the specified table.

The correct answer is D. This option is correct because it uses the appropriate COUNT(*) function to return the number of records in the "Persons" table.

In how many ways the Funnel Stage can operate?

  1. Four

  2. Three

  3. Two

  4. Only one


Correct Option: B

Choose the data type not supported by SQL Server

  1. varchar

  2. int

  3. text

  4. binary

  5. Image


Correct Option: C,E
  1. SQL Developer

  2. SQLWays

  3. Both a and b

  4. Only a


Correct Option: C
  1. MYSQL

  2. SQL Server

  3. DB2

  4. Oracle

  5. All of the above/ Any database suggested by client


Correct Option: B,D
  1. A procedure that is very small

  2. A procedure being invoked by another procedure

  3. A procedure that is not used by application

  4. System stored procedures


Correct Option: B
  1. timestamp

  2. varchar

  3. datetime

  4. number

  5. raw


Correct Option: C

In Sybase what returns the number of row affected by the preceding query

  1. @@trancount

  2. @@rowcount

  3. @@sqlstatus

  4. @@rescount


Correct Option: B
  1. inserted

  2. updated

  3. deleted

  4. created


Correct Option: A,C

Identify the background process which, is responsible for writing data from buffer cache to the datafiles to make changes permanent

  1. Checkpoint (CKPT)

  2. Database Writer (DBWR)

  3. Process Monitor (PMON)

  4. Log Writer (LGWR)


Correct Option: B
  1. Database Buffer Cache

  2. Shared Pool

  3. Data Dictionary

  4. Redolog Group

  5. Redolog Buffer


Correct Option: A,B,E
  1. Database

  2. Controlfile

  3. Table

  4. Datafile

  5. Index

  6. Redolog Group


Correct Option: B,D,F
- Hide questions