Tag: databases

Questions Related to databases

DBD is physical description of database.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

The mysql contains a user root?

technology databases

  1. True

  2. False

Show answer
Correct Option: B

The default password of root user is
technology databases

  1. My$ql

  2. Linuxab$

  3. ""

  4. None of the above

Show answer
Correct Option: C

What will be the output of the query select * from table1 order by rand()

technology databases

  1. Error

  2. All columns ordered randomly

  3. rows picked in a random way

  4. None of the above

Show answer
Correct Option: C

Is it a valid mySQL statements? SELECT @min_price:=MIN(price),@max_price:=MAX(price) FROM shop; SELECT * FROM shop WHERE price=@min_price OR price=@max_price;
technology databases

  1. True

  2. False

Show answer
Correct Option: B

What will be the output of the query SELECT column FROM table ORDER BY column DESC LIMIT 7,10;

technology databases

  1. Would skip the first 7, and then get you the next ten highest.

  2. not a valid mysql query

  3. Would skip the first 10, and then get you the next 7 highest.

  4. None of the above

Show answer
Correct Option: A

The mysql contains a user root?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

The default password of root user is

technology databases

  1. My$ql

  2. Linuxab$

  3. ""

  4. None of the above

Show answer
Correct Option: C

What will be the output of the query select * from table1 order by rand()
technology databases

  1. Error

  2. All columns ordered randomly

  3. rows picked in a random way

  4. None of the above

Show answer
Correct Option: C

Is it a valid mySQL statements? SELECT @min_price:=MIN(price),@max_price:=MAX(price) FROM shop; SELECT * FROM shop WHERE price=@min_price OR price=@max_price;
technology databases

  1. True

  2. False

Show answer
Correct Option: B